topic Re: data load into tables directly in Application Development and Automation Discussions

data load into tables directly

Former Member — Sat, 08 Dec 2007 05:21:25 GMT

hi all,

I got tetx file data of one table , for ex : data of table MARA with all fields data .

now i want to load that data directly into table MARA without using

BDC programs or lsmw .

can anyone provide the program for that.

thanks.

Former Member — Sun, 09 Dec 2007 12:35:45 GMT

Hi,

Try the following statement......

INSERT MARA FROM WA_MARA.

and in WA_MARA store the entries of MARA......

Thanks,

Aditya.

Former Member — Mon, 10 Dec 2007 18:36:27 GMT

Mara is a master table for material data, we should not update data directly to master data tables.

be ensure that the purpose,whether updation is required or not?

and you can use modify statement, which does the creation/modification for material.

modify MARA from WA_MARA.

Former Member — Mon, 10 Dec 2007 19:01:57 GMT

Hi,

First use FM GUI_FUNCTION and pass data to one internal table itab.

 INSERT MARA FROM TABLE ITAB ACCEPTING DUPLICATE KEYS

Since you are updating MARA Table, you need to use Lock Objects on that Table.

Regards,

Satish

Former Member — Mon, 10 Dec 2007 19:12:00 GMT

Don't do this unless you have written instructions from a superior. Even then, don't do it.

Transaction MM01 is used to create materials and it does over 40 inserts to various tables just to create one material.

Rob