Skip to Content
0

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

Dec 12, 2016 at 07:02 PM

189

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?

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

1 Answer

Bogdan Popescu Dec 13, 2016 at 11:31 AM
0

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

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.

1

Hi Dirk,

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

Regards,

Bogdan

0