Functional Specification For Opening And closing stock On Particular Date

[Former Member]

Dear Gurus,

I am creating report for opening and closing stock on particular date in which batch and storage location should also be included. I want to know the tables and fields for the same.I have searched the forum and got report on month basis but I want this report on posting day basis.kindly suggest tables and fields. Thanks in Advance

[Lakshmipathi]

When a standard TCode MB5B is there, why do you want to go for zee report. ??

G. Lakshmipathi

[Former Member]

Dear sir,

There are many other colums that client wants to add which are not present in MB5B transaction.columns which client wants to add are as follows...

Material Number

Material Description

Material Type

Material Group

External material Group

Movement Type

Plant

Storage Location

Customer Number

Customer Name

Vendor Number

Vendor Name

Posting Date Receipt Doc. Number

Issue Doc. Number

Reference Issue Document Number

Opening Stock Quanity

Material Receipt Quantity

Material Issue Quantity

Material Closing Stock Quantity

Value Of Closing Stock

And for this I want tables and logic for the same. kindly provide the solution for the same.