use different material different date to calculate stock value by 0ic_c03

[Former Member]

HI,all, here is my question

I want to get each Meterial inventory data from 0IC_C03,but there is a problem, each material have a different start date.

I only want to get the start date stock quantity. and I want to get following result by Query Designer use cube 0ic_c03:

Material Start Date Stock

A 20100103 10

B 20100211 20

hope you can help me, thanks

[Former Member]

Dear Reddy,

User will not give any data.each material have each differrent month.for example. the month of Material A is 201002.the month of Material B is 201005. the month of Material C is 201004. So how to caculate the stock of material according to each material month ,

Best Regards

[former_member181964]

Hi,

Use 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to 0IC_C03 Cube and design the report.

Use :See the steps how to load the data to 0IC_C03.

If it is BI 7 then for BX in in DTP in Extraction Tab you need to select Extacrion mode = NON-Cumulative option.

0VALSTCKVAL " For Value 0VALSTCKQTY " For Qty 0CALMONTH " For Month

Use the above combinations in New Selections in columns and go it.

For Qty Opening:

New Selection, drag and drop following InfoObjects

0VALSTCKQTY " For Qty

0CALMONTH " For Month and restrict with less then or equalto option variable (single value, user input) and set the offeset

" value = -1 bcoz if user will give 12.2009 , so it will display 11.2009 closing stock, this is opening for 12.2009.

For Qty Closing:

New Selection, drag and drop following InfoObjects

0VALSTCKQTY " For Qty

0CALMONTH " For Month and restrict with less then or equalto option variable (single value, user input) .

In the same way build for Value and other Keyfigures on 0IC_C03.

And

Drag & drop

0MATERAIL 0PLANT " Give some Input Variable.

Thanks

Reddy