Tables for capturing th goods receipt date of project stock

[Former Member]

Hi,

We are developing a report for showing the goods receipt date of project stock. ( Copy of MBBS with additional fields to display such GR date of material)

A material becomes a project stock upon goods receipt against a purchase order or goods receipt of a production order , both of which are account-assigned to a wbs.

Please advise which tables to use to get GR date for purchase order and GR date of production order, by giving material number , special procurement key , wbs number as input.

Thanks in advance,

Manohar

[Former Member]

Hi

Try MSPR table ( this has got a "created date" field in it ) along with MSEG ( for GR values )

and PO values are in EKPO table and Production order values are in AUFK table

All 4 tables !!

hope this helps.

Best Regards,

M.Amarendra

[Former Member]

Hi,

Try MSPR table ( this has got a "created date" field in it )

hope this helps.

Best Regards,

M.Amarendra

[virendra_pal]

try MSEG with matnr as input