General presentation

Objective of the application

Functionnal Specification:

Calculate the integrated margin in CPX, like it's done in WBP with program Z_M_INT with data from WPX and WBP and after this calcul, we must send back the data in WBP.

In CPX, program ZBW_M_INT & ZBW_M_INT_ANALYSIS are a replication and adaptation (in name of tables for example) to programs Z_M_INT & ZBW_M_INT_ANALYSIS in WBP.

Apart differences on name of sources tables and internals tables, in program Z_M_INT (WBP) we make the calculation for key figures Integrated Duty (/bic/k_intdut)  and   Integrated Freight (/bic/k_intfrg) and not in program ZBW_M_INT (CPX) because with use data from CPX in WBP to calculate these keys figure.

Tool Leader + IT leader of the application: 

Usage information

History

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

DSO correspondence WBP - CPX :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

In CPX, program ZBW_M_INT is a replication and adaptation (in name of tables for example) to program Z_M_INT in WBP.

We must pay attention to table TVARVC for Z_PERIOD_IM_HIST name: if LOW field is empty, the calculation of integrated margin will be done on current and current period - 1.

If the LOW field is filled (format MMMYYY), the chain will use this period to calculate the integrated margin (to be used in case of recalculation) (same rules inWBP system). 

In DTP: ABCOMM06 (Vault) -> OH_COMM01 - Delta we have a filter to load only data with WX Source of data (to load only data who come from WPX system).

Dependencies with other applications

Data loadings

Info providers and objects loaded

See data flow.

Loading frequency

Monthly, after the execution of process chain RSP_COPCP_MONTHLY in WBP system (second day of workday).

Process chains:

PC_CO_PC_MM_04 - MM: META - M - Integrated Margin

To calculate the Integrated Margin in WPX, we need some informations for WBP. To do that, in WBP we splitted chain RSP_COPCP_MONTHLY in two:

One chain in WBP: RSP_COPCP_MONTHLY load data in WBP and  trigger the chain in CPX (PC_CO_PC_MM_04).

The chain  PC_CO_PC_MM_04 will load data from WPX and WBP (calculated in chain RSP_COPCP_MONTHLY) and calculate the integrated margin for Vault plant.

After that the data will be sent in WBP with help of webmethods and the chain PC_INT_MARGIN (WBP) will calculate the integrated margin with data from WBP and CPX.

Step 1: RSP_COPCP_MONTHLY (WBP)

Step 2: PC_CO_PC_MM_04 (CPX)

Step 3: PC_INT_MARGIN (WBP)

Document for changes in process chain in WBP side.

PC_CO_PC_MM_04 - MM: META - M - Integrated Margin is composed by three sub chains:

1. PC_CO_PC_MM_01 - MM: TD - M - Acquisition Layer - Integrated Margin (Vault)
   Chain to load acquisitions DSO:
   • AACOMM01 - IM - Product Cost Items - Acquisition (source = WPX)
   • AACOMM07 - IM - Product Cost Items - Acquisition (WB) (source = WBP)
   • AACOMM02 - IM - Cost Element Matrix - Acquisition  (source = WBP)
   • AACOMM03 - IM - Released Costs Estimates - Acquisition (source = WBP)
   • AACOMM04 - IM - Plant transfert Cost Transport - Acquisition (source = WBP)
   • AACOPA01 - PA - Transport Costs & Duties - Acquisition (source = WBP)
   In case where we need to reload previous month, a sub chain is used: PC_CO_PC_MM_05 - MM: TD - M - Acquisition Layer - Integrated Margin Hist
   This chain will be executed only in case where in table TVARVC, for Z_PERIOD_IM_HIST the LOW field is not empty, the process chains will use this month to calcul the integrated margin. 
   
   Be carreful, if we don't want reload specific month, the low field for TVARVC table (name Z_PERIOD_IM_HIST) must be empty.
   
   
   
2. PC_CO_PC_MM_02 - MM: TD - M - Propagation Layer - Integrated Margin (Vault)
   
   • APCOMM01 - IM - Product Cost Items - Propagation
   • APCOMM02 - IM - Cost Element Matrix - Propagation
   • APCOMM03 - IM - Released Cost Estimates - Propagation
   • APCOMM04 - IM - Plant Transfert Cost Transport - Propagation
   • APCOPA01 - PA - Transport Cost & Duties - Propagation
   
   
3. PC_CO_PC_MM_03 - MM: TD - M - Business Layer - Integrated Margin (Vault)
   
   • ABCOMM01 - IM - Product Cost Items -Business
   • ABCOMM02 - IM - Cost Element Matrix - Business
   • ABCOMM03 - IM - Released Cost Estimates - Business
   • ABCOMM04 - IM - Plant Transfert Cost Transport - Business
   • ABCOPA01 - PA - Transport Cost & Duties - Business

After these three sub chains, we use program ZBW_TVARVC_ZPERIOD to update TVARVC table for Z_PERIODE,  Z_PERIODE-1 and  Z_PERIODE-2.

Then:

If in TVARVC LOW field is empty for Z_PERIODE_IM_HIST, we execute program ZBW_M_INT with Z_PERIODE1 variant (Z_PERIODE-1 in tvarvc) and Z_PERIODE_M variant (Z_PERIODE in tvarvc).

Else, if in TVARVC LOW field is not empty for Z_PERIODE_IM_HIST, we execute program ZBW_M_INT for the period defined in TVARVC.

Program ZBW_M_INT will calculate the integrated margin and load the result in DSO ABCOMM05.

Data from DSO ABCOMM05 will be loaded in DSO ABCOMM06 and then in open hub destination OH_COMM01.

PC_GLOBAL_ATTR_04 - Global: MD - D - Material unit of quantity (DSO)

This chain needs to be lauched before the cauclation of integrated margin to have last version of material unit quantity in DSO ABMARM01.

Normally this chain is launched every day.

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution