Query BW

Access the query

The query to be used for the 1st release is BW_QRY_CPCOCT01_R1_0001  – Cost Transparency – Release 1 

=> Go to Analysis for Office in excel 

=> Click "Open Data Source"

Go to the tab "Search" and enter "BW_QRY_CPCOCT01_R1_0001" in the search bar. 

Double-click on the query to open it

Run the query

It is mandatory to enter:

• The Period FROM and TO (even if there is one month, you must enter FROM 01.2020 TO 01.2020) (1)
• At least one company code (3)

It is also possible to enter:

• a GBU 
• a Macro-Package
• a Cost Package
• a Function

Click "OK" 

The report is displayed with the list of:

• Cost Sub Packages
• Cost Packages
• Cost Macro Packages

Responsible cost center 

You can add the characteristic Origin Flow (1) to see where the costs are posted:

• CCA: direct posting in cost center (ex: Cost center 0087-1000 (3))
• OPA: posting in CO or PM order (ex: Order 12141464 (2))
• WBS: posting in WBS element (ex: WBS OPT-C18014 (4))

=> The characteristic Resp. CC (5) corresponds to the cost center (3) or the responsible cost center of the order (2) or the WBS (4)

When the responsible cost center is not assigned, it means that it is not well maintained in the order master data (in KO03 - Display Internal Order)

Ex: there is no responsible cost center in the master data of the order 12050670

The Responsible cost center is used to assign costs to: 

• a GBU (with its profit center in WP1, its Business area in PF1)
• a plant with its profit center
• a function with the hierarchy ZCBS and a BSA when it is maintained

Package assignment

Add the object "Package Derivation Source" to see how the sub-package is assigned to a posting: 

• MATERIAL: there is a material code in the posting. A material group is assigned in its master data that is itself assigned to a sub-package,
• PURCHDOC: There is no material but a purchase order. There is a material group in the purchase order that is assigned to a sub-package,
• COSTELMNT: There is neither material nor purchase order. The cost element is used to assign the sub-package. 

In some cases a package can not be assigned. 

When the assignement is not possible, there is a reason code in the column Cost Sub Package.

• NC_MATNR (1): There is a material code with a material group but the material group is not assigned to a sub-package. 

In the example, the material group 0112 (2) is assigned to the material code 1062492 (3) however the material group 0112 is not assigned to a sub-package in the transcodification table. 

=> The material group 0112 should be included in the table and assigned to a sub-package. 

• NC_PURDOC (1): There is a purchase order with a material group but the material group is not assigned to a sub-package. 

In the example, the material group 0078 (2) is not assigned to a sub-package in the transcodification table. 

=> The material group 0078 should be included in the table and assigned to a sub-package. 

• NC_FIN (1): There is a cost element that is not assigned to a sub-package. 

In the example, the material group 98120010 (2) is not assigned to a sub-package in the transcodification table. 

=> The material group 98120010 should be included in the table and assigned to a sub-package. 

Dashboard QlikSense