Skip to Content
avatar image
Former Member

How to reconcile Inventory Report by Storage Location?

Hi All

How to reconcile data for inventory cube 0IC_C03 by storage location with SAP?

I dont know how the Keyfigures behaved in Inventory based on those movement types routines in transformation..

What does datasource 2lis_03_bf info provides to create report?

the sameway datasource 2lis_03_um ...wht info provides?

I dont know which key figure to use to check the stock balance as on the particular month say 08.2011 for Valuated Value of Stock

Pls give some inputs...I think inventory is an hectic report in BI..

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 26, 2011 at 08:38 AM

    Hi,

    Refer below thread might be helpful

    [http://wiki.sdn.sap.com/wiki/display/B1/SAPBusinessOne...ToGo-3.TheBasicsofFinancial+Accounting]

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 26, 2011 at 08:50 AM

    hi,

    The material reports can be reconciled on the total Quantity stock and total Stock value key figures with the SAP tcodes MB5B or MB51. The Qty and value KF in 0IC_C03 are non cumulative key figures. These non cumulative KF are based on Receipts and issue KF in cube. i.e. Qty stock is receipts - issue. Now based on movement types the records value are populated in either receipts or issues. Search the forum you would find loads of information for inventory management.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi krishnan ,

      i have a similar kind of problem ,where in ECC clients are moving materials from different storage locations to one storage location as they wanted to implement Warehouse management..But already in BW system we have delta loads going to this everyday from BF and UM extractor to 0ic_c03 cube.In this case how to handle the materials shifting to storage locations in ECC,what would happen to BW.What kind of data comes in to BW after running the program in ECC.please suggest as i am handling inventory cube since couple of days never worked on inventory.

      Example (currently in ECC)

      Plant Sloc Material qty

      001 01 v0001 4

      001 02 v0001 6

      After running the program in ECC ,during downtime

      Plant sloc Material Qty

      001 01 vooo1 10

      001 02 v0001 0

      What happens to data in BW already.And in which form data is loaded to BW in deltas from same system after downtime.

      Thanks in Advance.

  • avatar image
    Former Member
    Jul 05, 2013 at 08:45 AM

    Hi ,

    Try MB5L Report.

    Thanks

    Kamal

    Add comment
    10|10000 characters needed characters exceeded