Skip to Content

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

Dec 12, 2016 at 07:02 PM


avatar image

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
6dn4v.png (60.2 kB)
dgvax.png (33.4 kB)
pv2xu.png (6.4 kB)
10 |10000 characters needed characters left characters exceeded

ABAP data fllow or normal one?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bogdan Popescu Dec 13, 2016 at 11:31 AM

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:))



Show 2 Share
10 |10000 characters needed characters left characters exceeded

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.


Hi Dirk,

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