Co$ta - Tool to track PO Material Group change

>> Back to the Co$ta project home page

 




there is currently a SOLVAY process for updating the "material group" field in purchase orders. Because "material group" is used to determine  "Package /Subpackage"  , this process may have a retroactive impact on COSTA queries.
.


In order to facilitate the analysis of changes of "material group" field in purchase orders, a dedicated query have been created to to monitor modified documents. This query focus on "restated " Purchase Order for a for a period of months of document modification. The query also focus on COSTA posting where Costa Packagae have been derivated from Purchase Order (Cost Package derivation = "PURCHDOC").

Remark : a Purchase order can be updated many times . Period of months of document modification is the month of the last Purchase order modification .

Access the workbook

The workbook to be used is BW_WBK_COSTA_0007  – Tool to track PO Material Group change

=> Go to Analysis for Office in excel 

=> Click "Open Workbook"



Go to the tab "Role"

Open the folder "Cost Transparency" and select the workbook "BW_WBK_COSTA_0007  – Tool to track PO Material Group change" 

Double-click on the workbook to open it

If you can not access the workbook => go to the page Co$ta - BW Authorization 



Run the workbook

Enter:

  • A Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020). It's the Fiscal period of data you are looking for (1)
  • The period of the last change of Purchase order
  • Enter the GBU / Package / Company as in the standard workbook (3)


Click "OK" 



Dimensions

The workbook is similar to the standard workbook Co$ta - Access & run BW query but with: 

  • 1 dimension can give you the month of Purchase order month  
    • PO MatGrp Chge Mth

Ex: In this example we can trace all purchase order where Material group have been changed in 01.2022 , the new Material Group and the previous one