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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

LSMW for KL02

Former Member

‎09-04-2008 5:23 AM

0 Kudos

Hi,

i am uploading the data for KL02 transaction through LSMW.(in batch input recording),But my problem is the data is not reading from flat file...in my flat file the date is in the format DDMMYYYY,please provide any pointers.

6 REPLIES 6

bpawanchand
Active Contributor

‎09-04-2008 6:00 AM

0 Kudos

Hi

You need to convert

check this thread

Regards

Pavan

Former Member

‎09-04-2008 6:42 AM

0 Kudos

Hi,

Please check the date format in ur user settings (t-code - SU01). It should be same as the date format u r passing in the file.

Regards,

Asif

Former Member

‎09-04-2008 8:36 AM

0 Kudos

Hi ,

Do the following.

In the step "Maintain source fields"

Select your Date coloumn and click on " Table Maintenance".

Then, place the cursor in the column "Type" and click on F4.

Then , you will see that there are 3 options for date .

One is DDMY, second is DMDY and third is DYMD.

Select the first one i.e., DDMY.

And then give the length as '8'.

"SAVE" and come back.

Now go to the step "Maintain Field Mapping".

There select your date field and click on " Assign Source Field".

From the list of fields that pop up, select your date field.

Immediately, a screen with 3 radio button options for date will pop up.

select the second radio button one which is "DDMMYY".

Thats it , done. Now it should pick up the date properly.

It will, because it has for me.

Warm regards,

Hari Kiran

Former Member

‎09-04-2008 9:32 AM

0 Kudos

Hi

From SAP easy acess page Goto System------ > user profile -

> own data -

> defaults -

> date format -

> DD.MM.YYYY.This will change your user profile.Run it in the forgroung and check whethet you are getting '' invalid date format '' or '' no batch input data found ''.Than it will be easy to track down the issue.

Regards

Somnath

Former Member

‎09-05-2008 7:52 AM

0 Kudos

Hi

The most simple solution for the problem is

just change the date format in your flat file to YYYYMMDD.

it will defintly work

Regards,

Lokesh

Former Member

‎09-10-2008 7:49 PM

0 Kudos

Hi,

You have mentioned that "my problem is the data is not reading from flat file". Is it in anyway related to the date format???

Try to use the FM 'CONVERT_DATE_TO_EXTERNAL' to make the date in system specific format.

Thanks

Sumi