stock on posting date (custom report)

[former_member605564]

Dear all,

is there any cds or query for report MB5B (stock on posting date)

i check cds I_MaterialStockTimeSeries, but didnt get opening, closing value and incoming or outgoing 

we need copy that report, to add some column

or somebody can help how to create this report?

thanks

[Kamal_Jain · Accepted solution]

Hello,

There is CDS I_MATERIALSTOCK which has 4 fields Stock Quantity(MatlWrhsStkQtyInMatlBaseUnit), Consumption Quantity(MatlCnsmpnQtyInMatlBaseUnit), Stock Increase Qty(MatlStkIncrQtyInMatlBaseUnit) and Stock Decrease Qty(MatlStkDecrQtyInMatlBaseUnit), hope this can be used for the requirement. Also we can create Custom CDS based on CDS 'I_MATERIALSTOCK' and 'I_MATERIALSTOCKTIMESERIES' for required fields.

Regards,

Kamal Jain

[PollyGan]

Hi,

You can refer to analytic query Goods movement analysis and create your own customer query to achieve that.

Kind regards,

Polly