Application Development and Automation 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: 
Read only

regarding LMW

sreeramkumar_madisetty
Active Contributor
0 Likes
1,108

Hi Gurus

While I am uploading a file using LSMW technique in Batch Input method.

I was stucked in 2 things.

Please go thru this and suggest me ur views.

While recording ,for some values for eg: KOMGG-KUNNR or KOMGG-KUNWE from database it will come as 270300 based on condition that

KOMGG-KUNNR ,If RV130-SELKZ(01).

KOMGG-KUNWE,IF RV130-SELKZ(02)

from upload file KUNNR.

How to handle this kind of conditions in LSMW?

A batch-input session has to created for every 1000 data records of the upload file.

How this can be handled in LSMW?

After all processing I have to create a file which has to shows :

Number of Records in Upload file

Number of Records in Batch Session

Number of Records successfully processed.

Please suggest me the steps have to follow.

If anyone provide me the useful code/navigation it will be a great help for me.

Thanks & Regards,

Kumar

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
963

Hi,

Hope this answers.

While recording ,for some values for eg: KOMGG-KUNNR or KOMGG-KUNWE from database it will come as 270300 based on condition that

KOMGG-KUNNR ,If RV130-SELKZ(01).

KOMGG-KUNWE,IF RV130-SELKZ(02)

from upload file KUNNR.

>>> First of all, you do the recording as you do normally, do not think of LSMW. Now when the data is fetched into R/3 say from Excel sheet, you can have user defined routine in LSMW(There's an opiton it's one of the 16 steps, 5th i think)

to restrict/filter the recrod read.

A batch-input session has to created for every 1000 data records of the upload file.

How this can be handled in LSMW?

>>> The similar way you can keep a counter which tells you when to abort after the required number of records have been processed.

After all processing I have to create a file which has to shows :

Number of Records in Upload file

Number of Records in Batch Session

Number of Records successfully processed.

>>> this is very confusing, I am not clear, where do you want to show this information. If you want a seperate report or what else. in LSMW alone you can handle this situation.

Reward if useful.

Kiran

5 REPLIES 5
Read only

Former Member
0 Likes
964

Hi,

Hope this answers.

While recording ,for some values for eg: KOMGG-KUNNR or KOMGG-KUNWE from database it will come as 270300 based on condition that

KOMGG-KUNNR ,If RV130-SELKZ(01).

KOMGG-KUNWE,IF RV130-SELKZ(02)

from upload file KUNNR.

>>> First of all, you do the recording as you do normally, do not think of LSMW. Now when the data is fetched into R/3 say from Excel sheet, you can have user defined routine in LSMW(There's an opiton it's one of the 16 steps, 5th i think)

to restrict/filter the recrod read.

A batch-input session has to created for every 1000 data records of the upload file.

How this can be handled in LSMW?

>>> The similar way you can keep a counter which tells you when to abort after the required number of records have been processed.

After all processing I have to create a file which has to shows :

Number of Records in Upload file

Number of Records in Batch Session

Number of Records successfully processed.

>>> this is very confusing, I am not clear, where do you want to show this information. If you want a seperate report or what else. in LSMW alone you can handle this situation.

Reward if useful.

Kiran

Read only

0 Likes
963

Hi Kiran

Thnaks for ur valuable answers.

Here in Recording itself based on the field value tabname 16 the subsequent field values kunnr kunwe will vary.

So I have to do something at the time of recording itself.

For each 1000 records there is a seperate session:

If u send me the code with ur concerns it will be a great help for me.

After all processing I have to create a file which has to shows :

Number of Records in Upload file

Number of Records in Batch Session

Number of Records successfully processed.

>>> this is very confusing, I am not clear, where do you want to show this information. If you want a seperate report or what else. in LSMW alone you can handle this situation.

All these have to be displayed in a seperate file.

Regards,

kumar

Read only

Former Member
0 Likes
963

Not really, you don't have to take care it in recording, you can have multiple recordings, and then assign one particular recording based on conditions. I wish I could write you the code, but I'm really busy. There's some thread going on, on this topic which will tell how to pick a particular recording based on conditions.

kiran

Read only

Former Member
0 Likes
963

try this

Read only

sreeramkumar_madisetty
Active Contributor
0 Likes
963

Hi

It's Answered.