PS:Copy of MBBS report with Date(GR) selection option in selection screen.

[Former Member]

Hi,

We are developing a report, which is Copy of MBBS report, addition as Date(GR) selection option in selection screen to view historical data {i.e.Project Stock(Q) on back dates}.

MBBS is showing Project Stock w.r.t. WBS. So pls suggest Table, which can fulfill the requirement to show the Project Stock from GR w.r.t. Purchase and Production order in back date w.r.t. that WBS.

Pls do the needful.

Thanks,

Amit Jain.

[Former Member · Accepted solution]

Hi Amit ,

The Project Stock Table is MSPR , and the Project stock history table is MSPRH .

Though not through with your actual requirement , There is a standard Report MB5B -- Stock on Posting Date . In the selection screen , we can have the Special Stock Q (Project Stock ) .

If you can develop copying this report instead of MBBS , it would take care of receipts as well as issues ,and from the material Document you can build a relation to the account assignment WBS/Network Activity through MSEG Table .

Hope it helps .

thanks and regards

Kish

[Former Member · Accepted solution]

Thanks Kish,

Requirement: Developing a report same as MBBS to see Present as well as Past project specific stock as on required date. So wanna put GR date in I/p selection screen of new report to see the Project Stock (Historical Data) as on that date.

Pls Suggest.

Amit.