topic Direct Input Program in Application Development and Automation Discussions

Direct Input Program

Former Member — Wed, 10 Oct 2007 20:08:15 GMT

Hi,

I am using LSMW for loading materials and RMDATIND. I need to load only materials whose old material number does not exist in the table MARA.

For example: in the spreadsheet , if i have Old material number:

RECORD OLD MATERIAL NUMBER

REC1 345

REC2 345

Since it does not exist in the table MARA, it is loading both the records.

But I want REC1 to be loaded, not REC2.......

Is it possible to load only REC1?

Re: Direct Input Program

Former Member — Wed, 10 Oct 2007 20:18:49 GMT

Vamsee,

if you want to write any sort of logic u can write in begin of record or begin of transaction in field mapping and conversion step...

while you are passing the material number you can check whether the material is already existing in mara or not...

it is existing then skip the record and write to the error log so that u can have the track of the records..

if it is not existing then load the material

I think it would be helpful for you

~~Guduri

Re: Direct Input Program

Former Member — Wed, 10 Oct 2007 20:29:58 GMT

Hi,

You can write your custom code in the "Maintain Field Mapping and conversion rules Step". .

To be able to see all the events available in LSMW , change the layout using ( Ctrl + F7 ) in this step. Then you will be able to see events like "__GLOBAL_DATA__" , "__BEGIN_OF_PROCESSING__" ... etc.

Now write a code in the Begin of processing as below:

1) Check wether we have the material available in MARA , if the material is available the say CONTINUE ( This skips the current record & gets the second record). If there is no record available in MARA then continue your current process.

Hope this helps you..

Regards,

Suresh