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
replied

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

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question