rules for legacy fields to SAP fields

[Former Member]

please clarify urgently

Can you pls let me know the various format/ scenario of numeric number in legacy to be handle in SAP like amount which has being populated in CHAR field for data migration as per mappings

1. will it go as it is in target field.

2. If the SAP target field is < source field e.g in above case it is CHAR(5) , how will the amount go in target field.

e.g. 1. Does the numeric value e.g.. $888.45 go in target files as 888,45 or $888,45 or $888.45 etc

2. if the legacy value is -22222.334 and target field is 1. char(16) 2. char (9) 3. Char(5)

3. How will be negative values handle in SAP for eg if in AR is debit populated as -ve , will it go as +ve against debit posting key or as in legacy.

pls possible pls send the std document regarding the formats

[Former Member]

please clarify urgently

Can you pls let me know the various format/ scenario of numeric number in legacy to be handle in SAP like amount which has being populated in CHAR field for data migration as per mappings

1. will it go as it is in target field.

2. If the SAP target field is < source field e.g in above case it is CHAR(5) , how will the amount go in target field.

e.g. 1. Does the numeric value e.g.. $888.45 go in target files as 888,45 or $888,45 or $888.45 etc

2. if the legacy value is -22222.334 and target field is 1. char(16) 2. char (9) 3. Char(5)

3. How will be negative values handle in SAP for eg if in AR is debit populated as -ve , will it go as +ve against debit posting key or as in legacy.

pls possible pls send the std document regarding the formats

[Former Member]

Hi venkatarao,

1. will it go as it is in target field

The raw data which is contained in text file,

has to be uploaded in fields having CHAR format.

so if in text file, value is

12369983.87

then, the CHAR field has to be of atleast length 11.

This CHAR funda is only for uploading

from file, to INTERNAL Table.

After uploading in internal table,

this data is assigned to another internal table

which is EXACTLY same as required, ie. Numeric format.

Hence, further actions take place properly.

2. If the SAP target field is < source field e.g in above case it is CHAR(5) , how will the amount go in target field.

The value will be truncated and wrong value will go.

123456789

from that

only 12345 will go (or 56789)

3. . Does the numeric value e.g.. $888.45 go in target files as 888,45 or $888,45 or $888.45 etc

It depends upon how it is uploaded.

NEVER UPLOAD CURRENCY Signs.

Just upload pure figures.

4.

How will be negative values handle in SAP for eg if in AR is debit populated as -ve , will it go as +ve against debit posting key or as in legacy

It goes into sap AS IT IS.

At that time debit/credit does not matter.

I hope it helps.

regards,

amit m.