Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Query in LSMW

Former Member
0 Kudos
92

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos
72

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

5 REPLIES 5

Former Member
0 Kudos
73

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

0 Kudos
72

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..?

0 Kudos
72

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.

0 Kudos
72

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.

0 Kudos
72

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