Skip to Content
0

Consume c4codata type fields from SAP OData service in BODS4.2

Jan 25 at 06:28 AM

65

avatar image
Former Member

Hi all,

When we are consuming a SAP Odata Service using Odata Feed or from BODS 4.2 Adapter service, we are noticing that any fields with the following data types go missing in the table schema and not even get populated as fields.

c4codata.ENCRYPTED_LONG_Name (will have language and content)

c4codata.LOCALNORMALIZED_DateTime (will have timezone and datetime)

c4codata.ENCRYPTED_EXTENDED_Name (will have language and content)

c4codata.Amount (this will have currency code and and value)

Did anyone run into similar issue and could suggest a work-around for this please?

When testing the service via MS Excel Odata Feed also these columns show in the preview but will be missing in the spreadsheet output.

When we try using Custom OData Service and consume it via BODS or Excel we do not get all the text fields for a key in one table and we have to use many text tables and use LEFT join in the datawarehouse.

Thanks,

Anil

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

0 Answers