SAP BAPI Returns "ååãéëö" data.

RRR
RRR used Ask the Experts™
on
Hi, Experts.
I am a new in SAP BAPIs and I have a question.
I have some SAP BAPI that return me a recordset in VB6.
The data stored in SAP database is in Arabic/Hebrew language.
I can see the records correctly in SAP GUI.
BUT if you see this record in SQL Server Table you see the "ååãéëö" string; the recordset saved as XML show this "ååãéëö", and in viewer I see "???????".

I think it some shift in memory that SAP doing during the saving the data. But the BAPI do not this shifting again then it returns me the recordset.

What it can be and how can I fix it?

The SAP BAPI writen by a SAP staff, so if you have any comments in "SAP language" that I may no understand it is OK, I will pass all your comments to them.

Thanks, RRR.

I need it ASAP, so I increase the points. And if this answer will be a good for me I will give you 500 points with A grade (500*4=2000)

Thanks :)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Do you have the Arabic/Hebrew language packs installed for SQL server and for VB?
Commented:
Hi RRR,
The SAP translates many things for output to display or print which may be different from  the way it is stored in the actual SAP database.

This is done automatically by standard SAP transactions.
It seems like the custom RFC is getting the data directly from the SAP database.

Depending on how you SAP system is configured one or both of these may work. The RFC needs to transulate the data before you pass it thru the record set.

(1)Try this line of code in the RFC before you select the data.
----------- code --------------
  SET LANGUAGE = 'E'.
-------------------------------

(2) You may have to translate the entire dataset yourself
using code pages in the RFC before you pass it.

TRANSLATE c ...FROM CODE PAGE g1 ...TO CODE PAGE g2.  
------------example 1 ------------------------------
DATA F(72).                                              
TRANSLATE F FROM CODE PAGE '1110' TO CODE PAGE '0100'.    
--------------------------------------------------  translates the contents of F from the HP character set to
EBCDIC (IBM 274).

You have to have a Developer work with a BASIS person to determine what code pages you need to translate.

Here are some hebrew code pages on our system:
0800        IBM  EBCDIC  0941/0424  Hebrew              
0801        IBM  EBCDIC  0941/0424  Hebrew              
1800        ISO  SAP-intern, wie ISO 8859-8     (hebrew)
1801        ISO  ISO 8859-8  pur      (hebrew)          
1802        ISO  ISO 8859-8 Ausgabe    (hebrew)          
                                                         
Hope this helps



RRR

Author

Commented:
Thanks, it is working!!!
RRR.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial