on 03-08-2013 9:36 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
Hi,
i think In MC46 t-code you get the month end stock value and previous month stock values.
Help full you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.