topic Date format LSMW in Application Development and Automation Discussions

Date format LSMW

Former Member — Tue, 24 Jul 2007 09:59:30 GMT

Hi all,

I am using LSMW. The internal format is yyyymmdd. In my requirement i have to pass current-date sy-datum in a screen field using lsmw.

differrent users may have differrent date formats. how can i overcome this. suggest me.

regards

helpful answeres are surely rewarded.

Re: Date format LSMW

Former Member — Tue, 24 Jul 2007 10:25:44 GMT

Keep the date in the file in the format yyyymmdd and use it in LSMW

irrespective of the users defualt settings it will be taken care

<b>Reward points for useful Answers</b>

Regards

Anji

Re: Date format LSMW

Former Member — Tue, 24 Jul 2007 10:33:27 GMT

Hi,

Get the Format from the User settings. ie got to SU01D TCODE, you could see the date format which is used there. of you can select the date fromat from USRxx table.

In the Maintain field mapping and conversion rules in Change mode, you double click of the respective field name and get into the editor screen. There you can validate the date or convert the date into your format.

And Again in the Read data you can Check the format also, while uploading data. It will automaticly converts.

Regards

Re: Date format LSMW

Former Member — Tue, 24 Jul 2007 11:23:52 GMT

Hi Priyanka,

Before uploading the data just do some changes for ur date formate ,

go to System->userprofile->owndata and

select 4th option as per this code This is the Sample Code for a particular field) and save it and logoff and logon,

whatever the date fields you have in the input file just write code like this in the Mapping Step ( no need to change in the input file for a particular field)

if not as91_ztable-AKTIV is initial.

replace '.' with '' into as91_ztable-AKTIV.

condense as91_ztable-AKTIV no-gaps.

BALTD-AKTIV = AS91_ZTABLE-AKTIV.

else.

baltd-aktiv = '/'.

endif.

let me discuss if any issues,

Thanks

Naveen khan

Re: Date format LSMW

Former Member — Wed, 25 Jul 2007 19:34:39 GMT

Execute in the background - the program will run under the system user id which should use the internal date format exclusively.