Problem With TPLNR & TPLMA fields

[Former Member]

Hi,

Source :----SAP   through ABAP_dataflow to Target(SQL Server) with one to one mapping.

TPLNR & TPLMA  fields data coming like  “?010001010086,,,,,,,,,, But Original data like as  "02-002-2A"

In IFLOT  Table.

Any Help appreciated.

[Former Member · Accepted solution]

Hi,

Check the code page of the target 'data store'. Pick 'utf8' and language as 'eng (English)'. Pick the source code page as appropriate. In the target table, change the data type of make all 'varchar' coulmns to 'nvarchar'. Let the forum know if it worked.

Thanks, Arun J.

[Former Member · Accepted solution]

Hi  Arun

Thanks For reply.

I Tried For What ever you suggested i.e  Target Data store  Language  as 'en'  and Code page as 'utf8' and i changed data type to varchar to nvarchar.

But Data has not generated correctly.

[Former Member · Accepted solution]

Hi,

Do you see any difference in the data or still the same kinda data is getting populated? Also check the columns and its data type (and field length) in source & target is mathcing (unless you have done some casting).

Thanks, Arun J.

[Former Member · Accepted solution]

Hi

Still same kind of data is populated. Datatypes and sizes also same in Source and target.