The new wiki link for this data flow is here:

BW RTR - Profit and Loss by sales order (P&L)

Please update the doc there and no longer here.

General presentation

The new wiki link for this data flow is here:

BW RTR - Profit and Loss by sales order (P&L)

Please update the doc there and no longer here.

Objective of the application

The objective is to have a new P&L dataflow, same as original (MVCOPA01 & queries BW_QRY_MVCOPA01_0004 + BW_QRY_MVCOPA01_0007) with four new fields:

• Sales Order
• Item Order
• Market Cluster
• Team Cluster.

We created a new hana data flow (calculation views and composite provider) to avoid to store the data.

We not added the new fields in MVCOPA01 flow, because the volume would have been too large.

Project: 11281 - ICM Per Sales Order (P&L) 

Usage information

How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site

History

Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information

Roles & Access

Roles and access

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

Two workbooks was added to the role menu:

Authorization objects

List of autorisation objects mandatory for the application.

BW Catalog of Roles:

https://drive.google.com/file/d/1ibLr8rVvsplr8UX49hVH0Rx-m3Ko5YNK9IOQfTJ-F2M/view

Dataflow overview

The dataflow is composed by 4 calculation views and one composite provider.

Calculation view:

• CV_FMCO_COPA_PL_SOLVAY_0001
• CV_FMCO_COPA_PL_RHODIA_0001
• CV_FMCO_COPA_PL_NONERP_0001
• CV_FMCO_COPA_PL_BFC_0001

In the file below you can find the providers used as sources in calculations view and origin of each fields + filters applied.

Inputs parameters used in caluclations views:

• IP_CALMONTH_FROM
  • Single entry
  • Not  Mandatory
• IP_CALMONTH_TO
  • Single entry
  • Not  Mandatory
• IP_COMPCDE
  • Multiple entries
  • Not  Mandatory
• IP_CALYEAR
  • Single entry
  • Not  Mandatory
• IP_PLANT
  • Multiple entries
  • Not  Mandatory

Composite provider:

CPCOPA03

CV_FMCO_COPA_PL_BFC_0001:

CV_FMCO_COPA_PL_NONERP_0001:

CV_FMCO_COPA_PL_SOLVAY_0001:

CV_FMCO_COPA_PL_RHODIA_0001:

Sales order and Item for solvay DSO.

The objective was to add sales order and item in P&L reporting, for that we had to modify three existing DSO:

DPCOPA23:

• Modification of semantic key "C_KEY02" to add sales order & sales order item in the concatenation (not possible to add new keys, so we used concatenate fields).
• Add Sales order and Item as data fields

DBCOPA34

• Modification of semantic key "C_KEY02" to add sales order & sales order item in the concatenation (not possible to add new keys, so we used concatenate fields).
• Add Sales order and Item as data fields

DBCOPA41

• Sales order and sales order item already present in DSO, just ,eed to adapt the expert routine in transformation TRSF: ODSO DBCOPA35 -> ODSO DBCOPA41 tp use them for the lookup with DBCOPA34.

No reload for historical data was done for these DSO, sales order an item started to be loaded the change  in January 2022.

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way

Dependencies with other applications

Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...

Data loadings

Info providers and objects loaded

No loading, only calculations views are used.

Reporting

Queries End User Documentation

Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.

Main queries

BW_QRY_CPCOPA03_0001 → equivalent of query BW_QRY_MVCOPA01_0004, same fields, same CKF and RKF, only sales order, sales order item, market cluster and team cluster added in free characteristics.

BW_QRY_CPCOPA03_0002 → equivalent of query BW_QRY_MVCOPA01_0007, same fields, same CKF and RKF, only sales order, sales order item, market cluster and team cluster added in free characteristics.

QVSBS_BW_QRY_CPCOPA03_0001 → equivalent of query QVSBS_BW_QRY_MVCOPA01_0004, same fields, same CKF and RKF, only sales order, sales order item, market cluster and team cluster added in free characteristics.

About CKF and RKF we keep same incrementation number, for exemple BW_CKF_CPCOPA03_0001 it's same thing (for CPCOPA03) as BW_CKF_MVCOPA01_0001 (for MVCOPA01).

The only difference between CKF and RKF between MVCOPA01 and CPCOPA03, it's in CPCOPA03 we use "[VF_CCDE_COMPPRS_0001] TING Company" instead "[VF_C_COMPCDE__C_COMPPRS_0001] TING Company".

C_COMPCDE__C_COMPPRS in MVCOPA01 has different sources in the assignment, so we redo the same tule in calculations views in field CCDE_COMPPRS.

You can find the documentation on CKF and RKF here:

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

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

Broadcast

Indicate if there are broadcasts and give some details on the broadcast settings.

Maintenance

Known bugs

To open calculations view Rhodia and Solvay, it's necessary to use WEBIDE, it's not possible to open them with hana studio due to a lack of memory.

https://wbdhana.eua.solvay.com:4300/sap/hana/ide/editor/

Recurring procedure

List recurring procedures

Planned Evolution

Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016