topic Re: Updating table in Application Development and Automation Discussions

Updating table

Former Member — Wed, 11 Mar 2009 15:44:45 GMT

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

Re: Updating table

former_member376453 — Wed, 11 Mar 2009 15:51:13 GMT

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

Re: Updating table

Former Member — Wed, 11 Mar 2009 15:54:06 GMT

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

Re: Updating table

Former Member — Wed, 11 Mar 2009 16:26:54 GMT

use this FM /ISDFPS/PM_RELOC_MPOS_UPD_TASK

Re: Updating table

Former Member — Thu, 12 Mar 2009 13:45:58 GMT

hi mate.....

I cant seem to find that function module?

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

Many thanks

Re: Updating table

former_member376453 — Thu, 12 Mar 2009 13:48:30 GMT

In SE37 -> /ISDFPS/PM_RELOC_MPOS_UPD_TASK

Kuntal

Re: Updating table

Former Member — Thu, 12 Mar 2009 13:52:03 GMT

it doesnt seem to exist in 4.6C

Re: Updating table

former_member376453 — Thu, 12 Mar 2009 13:56:10 GMT

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

Re: Updating table

Former Member — Thu, 12 Mar 2009 14:13:02 GMT

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

Re: Updating table

former_member376453 — Thu, 12 Mar 2009 14:18:05 GMT

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.