Want to Update the Old Material Number

[Former Member]

Hi all,

I have Old material number (MARA-BISMT) and i want to update the table - MARA in SAP, please tell me ways of updating the same.

Any suggestion welcome.

Regards,

[Former Member]

Hi,

Write a program which does the updating. In the pgm:

define 2 internal tables called it_mara and it_mara1 like mara.

select * from mara into it_mara where (give 1 condition which relates to ur requirements).

loop at it_mara.

change it_mara and move the changes into it_mara1 table.

endloop.

now it_mara1 would have all the modified entries which needs to be updated in the MARA table.

now give the "modify mara from table it_mara1" statement which updates the already existing records in the DB table.

Reward points if helpful.

Thanks,

Archana

[Former Member]

You can also use Transaction MASS for doing such tasks!

which amount of datasets do you want to update?

[Former Member]

Can you tell me steps for same....

Edited by: Navdeep singh on Apr 10, 2008 9:12 PM

[P507709]

hi,

use the bapi fm :BAPI_MATERIAL_EDIT to edit the existing one and do bapi_transaction_commit to be stored in db.see it and tell me correct answer .

reward ifits usefull.

Regards

Durgaprasad.

[Former Member]

Problem resolved......