Skip to Content

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

Date format in flat file

Hi all:

I want to create a flat file to load data into an IC.

i have cal month data in my flat file. i am having the format as:

200508

200509

200510

200511 and so on.

i used 0calmonth as my time characteristic in my Infosource and i have a flagged for conversion routine also.

but when i tried to preview in the Infopackage its not showing up. it says error: error 1 when loading data some times and also pern1 error also.

i think its the problem with the date format i am using in myflat file. can anybody please tell how to maniatin the format for calday/ calmonth/ calyear data in an flat file..

Thanks

kedar

Former Member
Former Member replied

dear Kedar,

0calmonth in csv must have format MMYYYY,

and 0calday is YYYYMMDD.

and check your 0calmonth infoobject conversion routine,

it should PERI6, since your error message is pern1 ?

also try to check the infoobject sequences in 'transfer structure' (be careful can different from what you see in transfer rules infoobject mapping), should same as csv file. and try to save csv for just 1 or 2 records.

the other thing check if header for columns used in csv and 'ignore number of rows' in infopackage maintained properly. any infoobject with conversion routine pern1 used ?

separator/delimeter, decimal point, thousand separator etc check as well.

hope this helps.

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