Skip to Content
avatar image
Former Member

Weekwise Inventory report

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 03, 2008 at 12:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2008 at 05:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded