topic Re: Need BAPI or Function Module to update MAEX Table in Application Development and Automation Discussions

Need BAPI or Function Module to update MAEX Table

former_member216569 — Tue, 09 Sep 2014 11:46:28 GMT

Hi Experts !!

I need to update the MAEX table in mass level through a batch job.

Updating the table directly is not recommended. So, a BAPI or a FM would have helped.

One more thing, if I update it through a BAPI or FM, will the change history log in MM02 or MM03 be maintained automatically by SAP ?

Also if I directly update the MAEX table, how to maintain the change history log ?

Below are the fields which I want to update.

Re: Need BAPI or Function Module to update MAEX Table

Former Member — Tue, 09 Sep 2014 17:49:56 GMT

You could use function module MATERIAL_N_WRITE_DOCUMENT which supports MAEX to create planned changes, display with MM14 and apply with MM13. Yes, change documents will be created.

Re: Need BAPI or Function Module to update MAEX Table

former_member216569 — Wed, 10 Sep 2014 07:10:04 GMT

Hi Samuli,

I have checked this FM MATERIAL_N_WRITE_DOCUMENT. But this is for updating the change history.......but not for updating the MAEX table.

But yes, if someone wants to a FM to create MAEX change history, this is the FM for it.

I did get another FM to save data into MAEX table. FM MAEX_SAVE.

Re: Need BAPI or Function Module to update MAEX Table

Former Member — Wed, 10 Sep 2014 07:26:05 GMT

The function module can be used to create Planned Changes which can be activated with transaction MM13. We use it extensively to make changes to material master on specified validity date since the standard material master doesn't have a validity date concept, only BOMs do.

Re: Need BAPI or Function Module to update MAEX Table

RaymondGiuseppi — Wed, 10 Sep 2014 09:02:50 GMT

Those FM are update FM (check with SE37) called at end of transaction after checking data validity and must not be called alone in a customer program, using those FM is not better than direct SQL update of database (or you actually want to duplicate SAP standard checking and find every update FM to call, wrong idea usually)

Read also 1710449 - Transaction MM17 (Mass Change) or BAPI BAPI_MATERIAL_SAVEDATA does not support update on database table MAEX. So nowadays the correct solution is the use of Batch Input

Regards,

Raymond

Re: Need BAPI or Function Module to update MAEX Table

PeterJonker — Wed, 10 Sep 2014 09:10:08 GMT

MATERIAL_EXPORTCONTROLL_NEW

Re: Need BAPI or Function Module to update MAEX Table

former_member216569 — Wed, 24 Sep 2014 11:29:16 GMT

Hello Peter,

I think this is not the FM. This FM only brings the pop-up window.