on 07-17-2008 4:57 AM
Dear SAP Gurus
I want to know the stock of materials in my plant on Feb and March earlier date
Is there any way to get the stock
From which table i can get the stock
Can any body give idea and help me
I know MB5B
other than this any thing
or Table name
Please help very urgent
Rgds
Surya
hi
u can use
mc.9
mc.a
mc.1
mc.2
mc.5
reward if helpful
regards
kunal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suryaprakash,
Apart from MB5B, you can retrieve the same data using the below tables:
BKPF
BSIM
MAKT
MARA
MARD
MCHB
MCHA
MBEW
EBEW
QBEW
MKOL
MKPF
MSEG
MSKA
MSKU
MSLB
MSPR
RPGRI
T001
T001K
T001W
T001L
T134M
T156M
T156S
TCURM
ACCHD.
Reg,
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surya,
You could display your stock on Feb and March using MB5B, Fill Posting date between 1st Feb until 29th Feb and you will get beginning stock,stock movement(In/Out), and ending stock in Feb.
Or you can check table MCHBH for stock below from current period.
Regards
Gunawan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The tables are used for MB5B following and you can used ur require table and go for query report.
BKPF Accounting Document Header
BSIM Secondary Index, Documents for Material
EBEW Sales Order Stock Valuation
MAKT Material Descriptions
MARA General Material Data
MARD Storage Location Data for Material
MBEW Material Valuation
MCHA Batches
MCHB Batch Stocks
MKOL Special Stocks from Vendor
MKPF Header: Material Document
MSEG Document Segment: Material
MSKA Sales Order Stock
MSKU Special Stocks with Customer
MSLB Special Stocks with Vendor
MSPR Project Stock
QBEW Project Stock Valuation
Regards,
Biju K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi;
Check in transaction MC.9 or table S031
reward if found useful.
Regards
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
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.