Accountin view Report of Material Master

[jaheer_hussain]

Hi,

Is there any standard report for Accounting views of Material master(Price control,total stock,total value and standard price)?

Any tips for this PLEASE?

With Regards,

Jaheer

[former_member187989 · Accepted solution]

Using table MBEW develop a report,see expected results.

[Former Member]

hi,

there is no std report in sap to find out these values, but from table MBEWH , you can find the req values

also this repoprt s_p00_07000139 will give you the same details.

Regards,

velu

[Former Member]

no standard report for your requirement.

chek MBEW table.

[Former Member]

Hi,

Check MM60 for Material List. If it does not solve your problem try with SQVI.

pherasath

[esther_hernanz]

Hi Jaheer,

As far as I am aware there is not such a report, but you can do the following:

In SE16 check the table MBEW for the Material, Plant and Valuation Type (if the material is split valuated) and make note of the value in the field MBEW-KALN1.

With this number go to the table CKMI1 and enter it for KALNR.

Remove the maximum number of hits of 200 and execute the selection.

Once in the result list we need to sort according to two columns at the same time, DATUM and UZEIT.

For this make sure that you are in the ALV mode:

Follow the menu path "Settings" -> "User Parameters" and change to "ALV Grid display".

Now select the two columns for DATUM and UZEIT and sort in ascending order according to them.

You will be able to see all the postings that have affected your valuated stock (material documents, invoices, settlements, price changes, etc.) with the following important columns:

POPER AWTYP AWREF AWORG GLVOR LBKUM SALK3 VERPR STPRS

....

Where:

POPER indicates the posting period.

LBKUM is the stock quantity before the corresponding posting.

SALK3 is the stock value before the corresponding posting.

VERPR is the Moving Average Price before the corresponding posting.

STPRS is the Standard Price before the corresponding posting.

With this table you can have a clear view of the changes in the prices and the valuated stock.

I hope this information helps you.

Best regards,

Esther.