Moving Average Price (MAP)

[Former Member]

Hi,

We have a requirement to send new MAP (MBEW-VERPR)

to a third party system each time change been happend to the

material MAP in a plant.

Please guide me. If it has morethan one solution let me know.

Thnaks & Regards

Prasad Raju

[Former Member · Accepted solution]

Hi,

you consult your SAP ABAP team to write a report for that.

There is no standard report to track the Moving average price.

it will varies from time to time whenever good receipts is

happening and invoice is verified.

G.Ganesh Kumar

[Former Member]

I would suggest to use ALE. Create an IDOC each time your material is updated.

Go to transaction BDTP and setup your MATMAS message

go to transaction WE20 and setup your communication profiles and ports.

You can also send material information using BD10, but you may need to contact your basis administrator to get the correct event and filter so you can trigger the transmission at the moment you change MAP.

Using BD21 you use change pointers, that can also help.(select MATMAS message type)

Hope this helps,

GS

Edited by: G S on May 20, 2008 10:32 PM

[Former Member]

Ganesh,

What am trying to tell you is, MBEW table reflects the MAP changes but only displays the current MAP not the history.

My problem here is when i change the MAP for a material in transaction MR21 the trace is displaying in table CDHDR. The same is not happening when the MAP changed due to either GR or IR.

Regards

Prasad

[JL23]

exact. MR21 is a manual change, while the GR is a automatic change.

You will not have any transaction that shows you all the MAP changes with date and time.

you would have to develope your own ABAP or procedure to capture all changes.

You ccould create a Z-table and copy stock and price every day. But this is still just a daily number, if the value changes more than one time during a day, you will not see it then.But you can certainly see when the price startet to jump.

I often use a mix of MR51 and Excel.

Run MR51, add coloumn for entry date, sort it in sequence of entry date.

download it to Excel.

Add a first line with quantity and value from last periods record from table MBEW and calculate the price.

Then you can start calculating the MAP for each and every line.

[Former Member]

Dear Prasad

I have the same requirement of triggering the MAP changes to an external system. Can you share with me how you managed to solve this problem, cause as you've discussed only direct changes are reflected in Change Pointer tables and not the indirect ones.

[Former Member]

Dear Prasad,

I too have a similar requirement.

Could you please share how you solved this issue.

Thanks,

Ameesha

[Former Member]

Thanks for your view Ganesh.

As you said, yes we don't have standard report to track material MAP changes.

I need a trigger point when MAP changed for a particular material. How ABAP person come to know when it got changed.

MBEW table reflects the current MAP price. When i check the change pointer tables (BDCP, CDHDR & CDPOS) on MBEW the record is not being added to these tables when the MAP changed due to GR & Invoice posting.

Regards

Prasad

[Former Member]

hi,

I dont agree with you point in the table MBEW not getting updated. Whenever any transaction is performed, it will updated the table.

Please check with your ABAP team

Whatever changes is happening it will be reflected in CDHDR

G.Ganesh Kumar.

[JL23]

CDHDR and CDPOS capturing manual changes. Automatic changes like MAP when a MIGO is done are not captured in change history tables.

[Former Member]

Hi,

Can you please suggest for the solution.

The requirement is urgent.

Regards

Prasad