on 09-22-2008 11:39 AM
Dear all,
I am an ABAPER.
My requirement is to develop a Material balancing report.
In which i have to display
Opening Stock
Value
Receipt
Value
Consumption
Value
Closing stock
Closing value
for a material.
Here I need to know the table and fields for the above mentioned output fields.
Particularly i need to know what are the
movement types for Receipt and
movement types for Consumption
Can anyone let me know?
Regards,
Prem
Hi
Stock Tables:
MARC Plant Data for Material
MARD Storage Location Data for Material
MKOL Special Stocks from Vendor
MSKU Special Stocks with Customer
MSLB Special Stocks with Vendor
MSPR Project Stock
MSEG -Material Doc
MKPF-Header doc
Vivek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please go to the table T156. It is the table for movement types whih all the moment type charecatesrtcs.This table tells which movement type debits/credit stock and which moment type have consumption indicator.
From this you can come to a conclusion about the movement types of receipts (which increases the plant stock) and consumption (which reduces valuated stock).
pl award points if useful.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
101 - Good receipt against purchase order,
501 - Good receipt without purchase order,
201 - good issue for consumption against cost center.
Other wise enter MB11 and click F4 field of movement type. so you get list of move. type
Reagrds,
Mahesh Wagh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For receipt 101
Consumption to Cost Center - 201
You can check in MIGO transaction or MB51..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
few reports are:
MC45 INVCO: Analysis of Usage Values
MC46 INVCO: Analysis of Slow-Moving Items
MC47 INVCO: Analysis of Reqmt Values
MC48 INVCO: Anal. of Current Stock Values
MC49 INVCO: Mean Stock Values
MC50 INVCO: Analysis of Dead Stock
MB51......
TAbles:
MVER - Material consumption.....
MARC Plant Data for Material
MARD Storage Location Data for Material
MSLB Special Stocks with Vendor
MSPR Project Stock
MKOL Special Stocks from Vendor
MSKU Special Stocks with Customer
you can see al the mvt types in T156 table...
Hope it helps...
Regards
Priyanka.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.