Skip to Content
0
Former Member
Aug 04, 2011 at 07:11 AM

Stock Aging report logic

398 Views

Hi ,

There is a report requirement from stock aging report based on the bucket scenario.

I need to calculate the stock based on quantity(MSEG - MENGE) and moving average price/periodic unit price(MBEW - VERPR).

Then i need to perform the same into bucket scenario like 0-09 ,91-180,180-360,>360.

I can see the field (MENGE) in the standard datasource 2LIS_03_BF which is connecting with the infoobject 0QUANT_B.

But in the update rule/transformation there no assignment for this.

For which infoobject i can map to the cube and what logic i need to perform.

There is a calculation for this in the report for the value of the stock below.

Value = Quantity(MENGE)xmoving average price/periodic unit price(VERPR).

Stock Logic:

Stock is consider based on the movement types: 101,701,712.

Can anyone give me the idea on this how to perform the logic.

Thanks,

satya