Weekwise Inventory report

[Former Member]

hello all

i am working on one report on the inventory cube 0IC_C03. the report goes like

for a particular plant, inventory value for that week

say,

Plant

0VALSTKVAL

Week1 100

Week2 50

Week3 150

Week4 100

inventory value for Week1 will be value on 7th day, for Week2 will be value on 15th day, for Week3 will be value on 23rd day, likewise. nw my ques is there is no dimension of Week in the inventory cube. So how will i find the stock value??????

pls help.

[Former Member]

Hi,

I have a similar requirement in Inventory Aging.

Create a variable on 0calday with processing type customer exit.

Stock value = stock received - stock issued.

Using this calculated key figure, create restricted key figures with variable on 0calday.

Use set offset for variable(select variable and right click you can see) on variable to 7, 15, 21 for the respective key figures.

Or

Keep the calculated key figure in row.

Create a new structure in columns and create 4 selections using the variable with set offset for variables.

Thanks,

Ashok

[shanthi_bhaskar]

Hi Priyadharshini,

Assuming that 0calday is there in ur data provider.

Create NewSelections with name Week1 by restricting with Zcalday1 (which is 1st varaible to 0calday type:singlevalue processing by: customer exit) and Inventory KF.

like this create 4 Newselections with with Zcalday1, Zcalday2, Zcalday3, Zcalday4.

u can write Customer exit to populate data...that will be like this...

data: yy(4) value sy-datum(4),

mm(2) value sy-datum+4(2),

calday like sy-datum.

If i_vnam = 'zcalday1'.

concatenate yy mm '07' into calday.

l_s_range-low = calday.

append l_s_range to e_t_range.

clear l_s_range.

endif.

If i_vnam = 'zcalday2'.

concatenate yy mm '15' into calday.

l_s_range-low = calday.

append l_s_range to e_t_range.

clear l_s_range.

endif.

If i_vnam = 'zcalday3'.

concatenate yy mm '23' into calday.

l_s_range-low = calday.

append l_s_range to e_t_range.

clear l_s_range.

endif.

If i_vnam = 'zcalday4'.

concatenate yy mm '31' into calday.

l_s_range-low = calday.

append l_s_range to e_t_range.

clear l_s_range.

endif.

Regards

Bhaskar