Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Keeping leading zeroes in flat file

I am loading data from a flat file to a DSO.

One of the columns in the flat file is data type CHAR with a length of two. The data values will be either 01, 02 or 03.

When I load the data, the leading zeroes are dropped. Thus, I see 1, 2 and 3 in my DSO. How can I prevent this happening?

Former Member

You can either change the number format to text format in the excel sheet and then try to load the data.

Or concatenate the value 0 to the field value in transformation (update rule/transfer rule) using a routine. Then load the data.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question