Material Reconciliation report

[Former Member]

SAP offers a standard material reconciliation report MIRCMR. The pre-requisites being a reconciliation class - 50, a few characteristics and a PI sheet.

I do not have PI sheet implemented. Is it possible to run this report without PI sheets? Moreover, I am unable to assign the reconciliation class to any of the component materials - neither in the BOM nor in the recipe. Is this normal?

[Former Member · Accepted solution]

Hi,

You can use PI functionality to achieve this.

Use the standard process message RECON and assign it to your phase.

==>> EDIT You do not have to add the process message RECON - only do it if you want to access the material reconciliation from a PI sheet.

I have also noticed that it is not possible to assign class 050 to existing components in a BOM. But here is a work around to get you going. Pick a component that you want to reconcile (in your BOM) and delete it. Add it back again to your BOM with another item number. If you now go to the batch classification screen, you should be able to change the class and select class 050.

Rgds.

Edited by: Pascal on Oct 21, 2009 9:46 AM

[Former Member · Accepted solution]

Thank you, Pascal.

I used the config guide (help.sap.com/bp_bblibrary/.../P16_BB_ConfigGuide_EN_DE.doc) to configure the data. I have maintained the parameters. But I fail to understand how the parameters can fetch the values that I need.

For instance, I want to compare planned vs actual consumption of components. If I assign the movement types in SPRO, where are the value fields linked to the parameter? There is one field at bottom of parameter configuration, but that is limited to table TC22's fields - which unfortunately does not have the fields that I need.

Can you please elaborate the value fetching configuration?

Thank you for clarifying

Edited by: Venkatesh Ramakrishnan Iyer on Oct 21, 2009 9:12 AM

[Former Member · Accepted solution]

>

> For instance, I want to compare planned vs actual consumption of components. If I assign the movement types in SPRO, where are the value fields linked to the parameter? There is one field at bottom of parameter configuration, but that is limited to table TC22's fields - which unfortunately does not have the fields that I need.
>

If that is all you want to do, then why don't you just use report COOIS - it will give you that.

If you want to use the material reconciliation to do that, then just create a formula that takes the parameters PC_P01 and PC_P02 into condieration.

I.e create a formula that does 'PC_P01 - PC_P02' and set the expected value to be 0 (not this is just an example - it is not realistic because it does not take cancellations into consideration)

in customizing you have three customizing points - check under 'process data documentation / material reconciliation' in the pp-pi section.

- create formula paramaters - if you need to create some use any of the PC_PXX as a reference - they are all the same - otherwise use the standard ones they should be sufficient

- assign movement types to parameters - assign the above parameters to a movement type (or multiple)

- create formulas - this is where you set up the calculation you want to do for your material reconciliation - this formula you will assign to the relevant characteristic in your 050 class

hope this answers your questions