RFC_READ_TABLE get GUID

Hello,

when I use RFC_READ_TABLE function to read the R/3(CRM) table, which has a GUID field, the GUID field data is not fully-formed, but when I use ABAP data flow, there is no problem.

I got : 07A3004A41634643
R/3 table: 07A3004A41634643E10000000A4282F4

Please suggest any solution to avoid this problem using RFC_READ_TABLE.

Thanks.


JonasL (BOB member since 2010-10-27)

Seems to be a length issue. Can you open the SAP table from the object library, right click and select “properties” for the field, double the length for this field. Also, make sure you are not losing the longer chars downstream in your flow afterwards, e.g. assigning the now varchar(32) to a query column with varchar(16).


Werner Daehn :de: (BOB member since 2004-12-17)

Hi Daehn,

The field length has no problem.

It seems to be the issue of function rfc_read_table. when I test the function in R/3 system, the GUID data is also not complete.


JonasL (BOB member since 2010-10-27)

Please try it out to proof me wrong. The only other thing I can think of is a codepage mismatch. Is your SAP system Unicode? What is the codepage of the datastore?


Werner Daehn :de: (BOB member since 2004-12-17)

Hi Werner,

Thanks for your reply.

I tried as what you said, doubling the length for GUID field, and no missing chars in my dataflow afterwards. The problem still exists in fucntion call module, but ABAP dataflow can made it.

And my system is unicode, the codepage of datastore is utf-8.
I tested both in utf-8 and default codepage.

FYI.
Table and field
table name: CRMD_MKTTG_SET_H
field name: GUID
field type: RAW
field length: 16
text.jpg
se16.jpg
rfc_read_table_in_SE37.jpg


JonasL (BOB member since 2010-10-27)

Let me ask around what others have in mind about the RAW datatype. Right now it is not-supported.


Werner Daehn :de: (BOB member since 2004-12-17)