Updating table

[Former Member]

Hi all,

I need to update a table called MPOS.

I know that you are not supposed to directly update SAP tables but I need to fill in entries based on 2 criteria and there are 1000s of records.

Whats the best way to do this?

Thanks

[Former Member]

That might be, I am looking into ECC 6. But still I think you should not go for only updating this table, this is more or less like direct update only.

Kuntal

[former_member376453]

Hi I am not sure, You can try to findout some FM / BAPI to update the table entry. By the way, are you trying to do something with transaction MD04?

Kuntal

[Former Member]

Hi,

The best way could be finding out from which transaction the table MPOS gets the records and in those transaction if you have the fields you want to modify,

then you can use BDC with that transaction and execute them for all the records,

Regards,

Siddarth

[Former Member]

use this FM /ISDFPS/PM_RELOC_MPOS_UPD_TASK

[Former Member]

hi mate.....

I cant seem to find that function module?

Could you please tell me how to display it and use it?

Many thanks

[former_member376453]

In SE37 -> /ISDFPS/PM_RELOC_MPOS_UPD_TASK

Kuntal

[Former Member]

it doesnt seem to exist in 4.6C

[former_member376453]

That might be, I am looking into ECC 6. But still I think you should not go for only updating this table, this is more or less like direct update only.

Kuntal

[Former Member]

i cant find a function that does this and because some of the entries do not have MPOS-MITYP it errors when trying to load screen.

How can I directly update this table.

Thanks

[former_member376453]

I am giving you the code for the above FM. But still look for something else. Don't go for direct table update. This actually disturb, standard data consistancy. Wait for some more replies from the forum.

  CHECK NOT i_mpos-wapos IS INITIAL.
  UPDATE mpos FROM i_mpos.