Skip to Content
0

How to handle GUID/UUID or UID data type in SAP ESP?

Aug 14, 2017 at 09:48 AM

55

avatar image
Former Member

Hi All,

I am using SAP ESP 5.1 SP11. I am importing data from SQL using generic adapter, In my database in the table I have field with Uniquieidentifier/UUID/GUID datatype. So when I see data in ESP I see special characters and for humans they wont make any sense.

In the schema I only have string datatype available. I am not sure how to handle this issue. Can someone please help?

I have attached screenshot of what i see in output window.

Thanks in advance,

Happy

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Aug 17, 2017 at 04:10 AM
0

Hi Happy,

you can use cast function in input adepter.

select cast ( fielda as int) as field from tablea

Hope this helps

Share
10 |10000 characters needed characters left characters exceeded