Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 23, 2010 at 04:48 AM

    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. setting-up-material-movementinventory-with-limit-l

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 23, 2010 at 08:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded