Skip to Content
avatar image
Former Member

Custom report for month end plant inventory value

Dear all;

we need to develop a custom report for month end stock value and previous month stock value .

can any one tell me what would be my logic

Regards;

Joydeep

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 11, 2013 at 12:57 PM

    Dear Jurgen ;


    I have seen the tables and field ,

    I am trying the below logic to develop one custom report that should show the plant wise month end stock value for all materials relevant for the plant ,Customer need only the " Total stock value " ie SALK3 field .

    1) from the MARC we will get the list of materials relevant for the plant .

    2) Pass the matrerial code numbers to MBEWH tables and .

    3) Filter out the month

    4) filter out the year .

    5 ) Get the summattion of the filed "SALK3" .

    kindly suggest us is it a correct approach for the plant wise month end stock value ?

    If not then kindly give me the correct logic .

    Regards;

    Joydeep

    Add comment
    10|10000 characters needed characters exceeded

    • from my point of view a wrong approach, because

      - you do not have for any period a MBEWH record.

      Please read the OSS notes 415349 - Usage of modules XXXX_EXTEND for previous period

      and Note 193554 - Stock/valuation data of previous periods

      to understand how the H tables work and what you need to do to read them correctly

      - if your valuation level is plant level, then you do not need to select the materials in MARC first, you can directly go to pull them from MBEW.

      - MBEW is just one of several tables that hold stock values


  • Mar 08, 2013 at 10:22 AM

    I wonder why you want the logic from us.

    if you have to develope such a report then your customer should give you the functional design and explain to you what he wants to see on the report. And usually as well the transactions and tables where he currently sees the values which do not fully satisfy him. At least this is what is expected from us if we give development requests to our developers in India.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2013 at 10:44 AM

    Hi Joydeep,

    i agree with Jurgen..

    means while there are many standard SAP repots which shows stock qnty/value as on posting date.

    - MB5B

    - MC.9

    - J3RFLVMOBVED

    please study these reports, you can get the logic.

    Hope this will help you.

    Regds,

    nilesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2013 at 10:00 AM

    Hi,

    i think In MC46 t-code you get the month end stock value and previous month stock values.

    Help full you.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 11:58 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 11:59 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 12:00 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 12:22 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded