Functional and Technical rules

Rules & Explanations

This flow, based on CO WBS standard datasources, is the source for the budget, commitments, actual costs and hours key figures in the Project Costs Reporting. Note that commitments and actual costs are also completed by data from PM extractors (cf. WBSE - PM orders costs section).

Moreover, a specific datasource extracts data from COEPD table to enhance the cubes with the capitalized value (fixed assets).

Dataflow:

$TECHNO - BI TEAM > BW CASPEND /!\ Obsolete /!\ > image2016-7-4 11:5:41.png$

https://drive.google.com/file/d/1ekxaEuJ1VwDbGcOdpl8pey1F6Uw6lY0ugsSaN184lKk/view

Capitalized value determination - COEPD dataflow (Solvay & Rhodia) (R1):

The Capitalized value is issued from SAP table COEPD, where original PS documents are updated (Settlement status = 09) when AuC linked to the WBSE is put into service (transfer AuC -> FXA).

$TECHNO - BI TEAM > BW CASPEND /!\ Obsolete /!\ > image2016-6-28 11:8:56.png$

Extraction from COEPD is done using a specific datasource based on Function Module ZFM_BW_EXTRACT_COEPD.

Three FULL infopackages run daily:

Current year + last year (based on the posting date COEPD-ABWDA): it was considered that a settlement can’t occur on a past year but the last year is also extracted to not miss the changes done on the last day of the year (December 31)
Posting date = “00000000”
Reversal indicator = “X”: allow to retrieve cancellations on past years

Infoobject K_WOBGTA is updated in WBSE Actual costs DSO (ODS_WBS6 and ODS6WBS6) by the sum of COEPD line items value in object currency.

Line items settlement with status "03" and "04" and line items with reversal indicator "X" are deleted.

It works only with delta update (old value is deleted by before image, recordmode = "X"), in consequence, K_WOBGTA need to be set to "0" before a full load.

Partner object mapping (R2):

Partner objects are mapped from a generic field "Partner IO val" (RSPAROBVAL) to specific infoobjects "Partner Costs center" (0PART_CCTR), "Partner WBSE" (C_PARTWBS), "Partner Order" (C_PARTORD),... according to the partner type (RSPOBART). It is done using the Function Module 'CO001_BIW_PARTNER_DECODE' as provided by the SAP Business Content.

However, in Solvay ECC (PF1), some costs are defined at PM order operation level. When it happens, and that these costs are distributed to WBSE, the partner type is "0ACT".This partner type is not managed in the Function Module 'CO001_BIW_PARTNER_DECODE' so a specific rule is set to map the Partner Order from the generic partner field: we keep the 12 first characters and check in C_COORDER MD that it corresponds to a real order number.

Datasources customer exit:

0CO_OM_WBS_6: retrieve additional data from tables EKKO, CATSDB, COEPD and COEP. The field zzmbgbtr = COEP-mbgbtr is used to obtain the project hours concerning Networks settlements on WBSE (partner object type = "0NWA").

0CO_OM_WBS_7: retrieve additional data from tables EKKO, EKPO, EBAN.
It also determines an adjusted net due date (zznetdt) that corresponds to the delivery day (or the current date if the delivery date < current date) to which is added the terms of payment.

Dependencies with other applications

Fixed Costs Analysis: Actual costs DSO are sources for the cube CUB_FC002/005/006.

Data loadings

Info providers and objects loaded

Main Chains

Process Chain

Code

Type

Frequency

Comments

CO_OM_OPA / WBS - delta extraction

RSP_COOM

MAIN

launched by RSP_DAILY
Daily
Sunday night to thursday night, around 2:30am
Whole chain lasts around 2 hours

RCS systems
From datasources to cubes
Actual costs, Commitments and Budget

CO_OM_OPA / WBS - delta extraction for non RCS systems

RSP_COOM_OTHER

SLAVE

launched by RSV_COOM_CCA_OTHER
Daily
Sunday night to thursday night, around 3:00am
Whole chain lasts around 2 hours

Non RCS systems
From datasources to cubes
Actual costs and Commitments

Weekly chain for CO and WBS budget (Non RCS)

RPC_CO_WBS_BUDGET_NO_RCS

MAIN

Direct Scheduling
Weekly
Saturday at 3:30am
Whole chain lasts around 2 hours

Non RCS systems
From datasources to cubes
Budget

Loading frequency

Actual Costs = daily Delta

Commitments = daily Full with deletion

Budget = weekly Full with deletion (Acetow & Solvay), daily Full with deletion (Rhodia)

Average performance

Key Figure	Estimation
~ Average Process Chain Runtime	Daily RCS = 2h Daily non RCS = 2h Weekly non RCS = 2h
~ Average nb of rows loaded per load
~ Total nb of rows loaded (if full)
~ Average Runtime for 10k lines

Record Keeping

All records