Versions Compared

Old Version 12

changes.mady.by.user Romane MULLER

Saved on

compared with

New Version Current

changes.mady.by.user ROLLIER, Charlotte

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

BW query : Physical inventory coverage rate 

 

To get BW installed : Business warehouse

 

The reference for the coverage rate is the BW query

Physical

physical inventory coverage rate


1 - How to run the query ?


  1. I open Start menu

  2. I open 

Image RemovedImage Removed

Image Removed

 

Image Removed

 

Image Removed

 

Image Removed

 

Image Removed

 

Image Removed

 

 

 

 

 

 

 

 

 

  1. Open Start menu
    Open Analysis for Microsoft Excel in the Start Menu / All program
    In File, Analysis click


Image Added

     3.  In File tab, I select Analysis. Then I click icon open workbook (from SAP NetWeaver)


     Image Added

     4.  I select the data source BW

Logon the BW server = BW

- Production - WBP

And

     5.  And I click on Next


Image Added

    6.  Enter

Enter

user and password

Image Added

     7. Select folders tab and then choose Role in order

Select Folders then select Role

to select core workbooks


Open

 

      8.  Open the workbook physical inventory         coverage rate (core workbook)

press


      9.  Press OK

 

Image Added

      10.  Click on Image Added(Analysis tab)

Image Added

      11.  Enter

Click on Image Removed
Enter

the data you want to display in the

report
  • Press OK

    •         report. Here is only mandatory the company code. 

     

           12.  Press ok 

    Image Added

     

     There   There are two spreadsheets in the file:

    • one for the FI (Z120 & Z125)
    and
    •  
    • one for other type of
    materials Image Removed How to receive the broadcast
    • materials

      

    Image Added

     

    2 - Why the coverage rate is lower than expected ?


    • Answer 1 : The physical inventory is not finished
    • Answer 2 : There is no more quantity of some materials that were in the inventory at last year end
    • Answer 3 : Inventory flag is updated in BW on Saturday

    For question related to physical inventory procedure in RCS, please refer to APM training document : 

    Image AddedWarehouses in IM                                                        Image Added Warehouses in WM

     

    Status
    colourBlueGreen
    titleAnswer 1
     The  The physical inventory is not finished

     

    There are 7 steps in a physical inventory in MM when there is no variance and 10 spteps steps when a recount is needed

    Physical inventory creation

    		MI31 
    Inventory count from printingMI21 
    Physical stock calculationOut of RCS 

    Inventory count entry

    		MI04counted
    Inventory count differences printingMI20 
    Inventory count differences validationMI07validated

    Results display

    		MB03 
    Inventory recount if neededMI11 
    Inventory recount entryMI04counted
    Inventory recount differences validationMI07validated
    A physical inventory is taken into account in the BW query when the status is validated (step 6 & 10)

     

     

    Status
    colour

    Blue

    Green
    titleAnswer 2
     

     There

    There is no more quantity of some materials that were in the inventory at last year

    end 

    end 

    The reference used by the calculation of the coverage rate is the inventory at the end of the previous year.

    It is recommended to count all inventories even if the quantity is equal to zero and follow this procedure :

    • Create the inventory document with MI13 and select "only materials with zero stock". If necessary you can change in the control section to the relevant "MA. no. items/doc"
    • In MI04 (inventory count) click on "set zero count" =
    =
    • > All item ZC box will be checked
    • Validate with MI07
    • Create a new inventory document with MI31 and select materials "only materials w/o zero stock" and complete the procedure

    Image Added

     

     

    Image Removed

     

     

     

    Image Added

     

     

    Status
    colourBlueGreen
    titleAnswer 3
     Inventory  

    Inventory flag is updated in BW on saturday Saturday

    The query reports the coverage rate as of last friday night. Either you run the query as previously explained or you can receive automatically a monthly broadcast.

     

    Template of the broadcast

     

    Image Removed

     

    Attach physical inventory report in the Excel template

    Image Removed

    Image Removed

    1. Choose "insert"
    2. Click on the "object" button
    3. This window will open
    4. Select "Create from file"
    5. Add you file by clicking on "Browse"
    6. Select "Display as icon"
    7. Select OK

     

    E mail of 3 - E-mail validation from GCCO

     

    • By september September coverage rate in value is above 80% of prior yeatyear-end value for the FI, and above 90% for other type of material knowing that each reference is counted every 3 years for manufacturing supplies and every year for all other types of materials.

    • In case of exceptions to the rules defining the physical coverage rate for year end, the FRA publishes last quarter physical inventory planning and require GCCO validation.

    • The validation mail is posted in the Electronic Control Evidence Depository Depository

     

    For information : SBS dashboard - Coverage rate

    indocator

    indicator


    Inventory coverage rates are followed using this indicator in SBS dashboard

     

     

    Image Removed

    Image Added

     


     

    Info
    titleTo receive automatic broadcast

    Either you run the query as previously explained or you can receive automatically a monthly broadcast

     

    Include Page
    CostFAQ:Broadcast
    CostFAQ:Broadcast
    Show If
    useralepercq
    viewtracker