data load into tables directly

[Former Member]

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]

Hi,

Try the following statement......

INSERT MARA FROM WA_MARA.

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

Thanks,

Aditya.

[Former Member]

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]

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]

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