ABAP Data Flow converting varchar to date

dataservices job design
1

Hi Experts,

I have an ABAP data flow which is extracting data from SAP ECC table T001.

For the currency field ‘WEARS’ which is already a varchar field, it is converting the data in this column into some number like 20130426 when import it into DS and this same value is appearing in all the cells in this currency field.
Please if someone can help me to find out the reason why it is happening and what may be the solution I should apply. Thanks in advance for your support.

Note: Data in actual table is varchar(3) and have data like ‘EUR’,‘GBP’…

BOBJFan (BOB member since 2011-09-24)

2

Fields T001.WAERS contains the currency key and is recognized as a varchar(5) by BODS.

That data gets corrupted is not due to the contents of the field.

Are you doing any transformations?

Johannes Vink :netherlands: (BOB member since 2012-03-20)

3

Thanks for your reply Johannes,
Yes, I am doing some joins of T001 with 2 other tables in the transform.

Surprisingly, If I extract data just from T001 table in my abap dataflow without any conditions or making joins with any other tables, it retrives the currency in correct format as ‘EUR’, ‘GBP’ but if I am using multiple tables and joins then it is giving me data as numeric value which looks like date -‘20130426’ looks like 26th April and this value is appearing in all the cells of this currency column…

Does anyone else has ever faced this situation before, I will really appriciate your input …please help me out what could be possible reason for this data conversion…?

BOBJFan (BOB member since 2011-09-24)