Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hi Happy,

    you can use cast function in input adepter.

    select cast ( fielda as int) as field from tablea

    Hope this helps

    Add comment
    10|10000 characters needed characters exceeded