on 06-23-2010 5:11 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.