SAP BODS Not bringing converted values(Conversion Exit) from SAP

[Former Member]

Hi Experts,

I am using simple SAP table extraction by using Query transform , It is not bringing converted values, I need to bring converted values of SAP . Please let me know the steps to get the converted values of SAP table into DS.

Appreciate your inputs and help. -Emma .M

EX: In SAP the table value for Base UoM is 'PAA' , But in DS it is bringing 'PA' which is not a Conversion Exit Value

Other Example:

Data Service Value:

SAP Value:

PS: This is not about leading Zero , It is SAP internal conversion Exit Value

[former_member187605]

ABAP data fllow or normal one?

[Former Member]

Hi Emma,

IS EAN11 data type INT? If so, expect the 0 to be truncated. Need the 0, change the data type to Varchar in Data Services.

@Dirk, why would that matter? Isn't the ABAP df just a better (faster) way to get data out of SAP? Why would that influence the data types? (i'm just asking:))

Regards,

Bogdan

[former_member187605]

It matters because you can call the conversion routine in the ABAP data flow without performance impact. In a normal data flow, you would use a lookup, but have to load the conversion table first.

The (first part of the) question was not about data types, but about UoM table and converted values, PA and PAA.

[Former Member]

Hi Dirk,

I understand. You made me rest my case. Many thanks for the explanation.

Regards,

Bogdan