Query in LSMW

[Former Member]

In LSMW, how do to convert dd/mm/yyyy format in flat file to SAP date format..?

[Former Member]

use the same format 23.03.1979 like that no need to convert

step : process one transaction manually and find how the system is accpeting the dat.

then accordingly give the input in flat file.

why date is required are you doing any transaction through LSMW???

SK

[Former Member]

I am migrating date from flat file to SAP ..

in my flat file dte is in yyyy/mm/dd format.

But in my database table it is in dd/mm/yyyy format.

wat conversion rule to be given in LSMW..?

[former_member184494]

Ramya,

Is it not possible to change the format in the flat file itself instead of doing it through a routine / workaround ?

My 0.02.

Arun

P.S Moving it to the ABAp forums for more relevant answers.

[former_member156446]

hi Ramya

During loding data,, the main thing u need to take care is the settings in ur system.. or ur user settings of the date... first check those settings.

[Former Member]

Hi,

In LSMW 5th Step, we have to write a conversion rule for date format like <b>'DD/MM/YYYY'.</b>

Take date variable and use offset operation and then concatenate.

Thanks,

Anil