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