1. Objective and Scope

1.1. Objective of this Operation

The purpose of this documentation is to describe how to perform the monthly check of the WBS elements master data GBU information across different sources to ensure that the CAPEX reports are consistent and avoid issues in the QlikSense report.

1.2. Scope

This operating procedure (OP) applies to all companies with active WBS elements in PF1 and WP1.

2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:

• BW: Business Warehouse
• CAPEX: Capital Expense
• AUC: Asset Under Construction
• BFC: Business Financial Consolidation
• GBU: Global Business Unit
• CGU: Cash Generating Unit
• WBS: Work Breakdown Structure

3. Tasks description

3.1. I perform the BW consistency check

3.1.1. I run the BW consistency check template

Open the attached BW template and open up the option "prompt":

Then, fill the prompt with the following information:

• Calendar year/Month: The month of the closing period for which the check is being done (MM.YYYY)
• Conso View?: 1 
• Project Elarg. to PM?: 0
• Company Code: between ( [] ) 0001 and ZZZZ
• Target curr. for conversion: EUR
• WBSE Type: IM

After that, run the report to get the results.

3.1.2. I check the GBU information inconsistencies

After the report is executed, you will find the inconsistencies by filtering the "Comparison" column:

The "Comparison" column compares the information coming from the AUC (which is aligned with the cost center) and compares with the information that is in the "Customer Field" part of the project (PF1) and the WBS elements (WP1).

You can find the information from column "1 - WBSE BFC GBU (Clt)" in the project/WBS by going to the transaction CJ03, then select the "Details" option and then "customer fields" or "Cust. fields WBS element". 

In PF1:

In WP1:

The information in the "BFC GBU" field is derived from the enterprise code and the business unit. 

If the field needs to be updated in WP1, it needs to be based on the enterprise code and business unit information. 

You can find the information "3 - WBSE BFC Activity (Resp)" in the cost center or the asset under construction. 

In PF1:

In the cost center linked to the WBS element (by checking in CJ03), you can find the business area by opening the cost center in KS03:

Every business area has a division code, which corresponds to the two middle digits of the business area code, therefore in this case if the business area is 3100, the division code is 10.

With the division code, you can find the BFC activity code 2 by checking table ZZF_BFC_DIV_COVV in transaction SM30.

In WP1:

In the asset under construction linked to the WBS element, you can find this info in the "Allocations" tab in transaction AS03:

In the cost center, you can find the info by running transaction ZWFAI052:

3.1.3 I Contact the relevant people 

After the divergences are identified, the relevant people should be contacted. The following matrix should be used:

1. Plant controller
2. Business regional controller
3. Business global controller

When contacting the relevant people, please request their confirmation about the GBU allocation that should be considered as correct. 

3.1.4 I Correct the discrepancy

After their validation, update the relevant information accordingly.

If the correct information to be considered is the one in the the AUC/cost center, you must update the "Customer field" information in the project/WBS element through transaction CJ02.

After the discrepancy is solved, you must wait until the next BW update for it to disappear from the report after you refresh.

Additional Comments

The information from the GBU is extracted from the Business Structures file and the tab "GBU Act 2 Mapping Database" must be updated accordingly.

End of document.