Skip to Content
0
Former Member
Mar 23, 2009 at 07:58 PM

Inventory Management 0IC_C03: Beginning and ending inventory

141 Views

Hi Gurus

My report is based on Inventory Management cube and I have a requirement where in I need to show Begining Inventory and Ending Inventory for Plant per Period.

There is no KF for Beginning Invin SAP standard model in inventory management cube (0IC_C03 cube), so I thought to restricting total quantity by Fiscal period and Offset by minus one to get begining inventory.

Here is my report layout:

I have got : Period , Plant in rows and Beginning and ending inventory in Columns.

Desired Output:

Fiscal Period | Plant | | Begining Inventory | Ending Inventory.

03/2009 | 1001 | 100 | 50

Actual Report output

Fiscal Period | Plant | | Begining Inventory | Ending Inventory.

02/2009 | 1001 | 100 |

03/2009 | 1001 | | 50

So basically report is being split on two lines for current and previous (due to restriction in begining period : Offset =-1 on period).

Question is how to achieve both begining and ending inventory for a period in same line.

Thanks in avdance for help and time

SA