Custom report for month end plant inventory value

[joydeep_mukherjee2]

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

[joydeep_mukherjee2 · Accepted solution]

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

[JL23 · Accepted solution]

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

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[Former Member]

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

[JL23]

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.

[joydeep_mukherjee2]

Dear Jurgen L;

Actually I need the logic to built a custom report ,where need to develop 1)month end  plant wise store inventory Value in lakhs 2) Previous year  ending plant stock value 3) Cumulative value for the year .

For that Z report I need the Tables and field to write my FS .Can you just help regaring the required table fields to dvelop the report .

With regards;

Joydeep

[JL23]

I can give you a link to a wiki that has  all stock tables: http://wiki.sdn.sap.com/wiki/display/ERPSCM/Stock+Tables+and+Stock+Types

but you should look into your SAP and decide which value you want to see in the report.

then you just click F1 field help and at the pop-up click the icon for technical field help, then  you can usually  see what the field name is.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[joydeep_mukherjee2]

This message was moderated.

[Former Member]

Hi,

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

Help full you.