SAP MM (Materials Management)
SAP MM (Materials Management) Forum
SAP Purchasing Forum
Please let me know that which T-code i use for taking opening + purchase-issue+closing stock report.
Dear Mr. Shankar Iyer
It depends on the process elements also apart from Opening balance and Closings balances, Example in SAP issuing stock to quality is also issues and receiving only accepted stock apart from initial GRN is also receipts. The calculation goes like Opn=9(+)GRN=34(-)Issues to Quality=34(+)Receipt from Quality=30(-)Issues to production=25(=) Closing Balance=14Ea
If run any typical T.code like MB5B, MCBC, MB1B etc. you may find Opn and closing stock matching to physical stock but receipts and issues may have different values. Receipts will be showing as 34+30=64 and issues will be showing as 34+25=59, so by that Opn=9(+)Receipt=64(-)Issues=59(=)Cls.Bal=14Ea
if you are looking for the same you can use above t.codes
Also you may please use other ledger T.Code : J3RFLVMOBVED, S_P00_07000139, S_P00_07000140
Otherwise you need to go for ABAP programing with functional team help based on excluding some unwanted movement types to summarise the report.
Sign up for STechies