2006 Nov 28 3:42 AM
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
2006 Nov 28 5:39 AM
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
2006 Nov 28 5:39 AM
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
2006 Nov 28 5:56 AM
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
2006 Nov 28 6:02 AM
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
2006 Nov 28 6:03 AM
2007 May 23 11:40 AM
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |