Skip to Content

Accountin view Report of Material Master

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 21, 2010 at 07:16 AM

    Using table MBEW develop a report,see expected results.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2010 at 07:22 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 07:23 AM

    Hi,

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

    pherasath

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 07:27 AM

    no standard report for your requirement.

    chek MBEW table.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 07:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded