Reg: Read multiple worksheet data sent in XSTRING format

[Former Member]

Hi All,

Below is my requirement:

Netweaver team would send the data from excel sheet having multiple workbooks in the XSTRING format to SAP. How do I decode the data and fill my internal tables.

Tried to convert the XSTRING to STRING format using the below ways:

1. Use of standard FMs - HR_KR_XSTRING_TO_STRING,

2. Use of  cl_abap_conv_in_ce=>create and read

But none of them are giving me readable format.

Should this data be first converted to XML or anyother format and then to our internal tables?

Please guide me!!

Thanks in advance!!

Regards,

Deepika.

[Former Member]

Search the forum...  Look also at SCMS* function modules, which would allow you to convert xstring to a binary table.  Function modules in that group would also allow conversion from binary to text in a second step.  Or, you could go rom xstring to string, etc.  There are several paths, probably, to get to something that you can import to a defined structure or table.