Access Management

Role Code

Role Description

Explanation

ZBI_RCS_SD_A01

Application role for Global Sales project / SD data / Orderbook

Role for the application

ZR_RCS_CA_M49

SD - Sales and Distribution

Role menu for the application

List of authorization objects mandatory for the application.

Authorization object

Explanation

CPFCTR1_2

GBU

C_COMPCDE

Legal company

C_SAL_OF

Sales office

WARNING: For the PO part the notion of sales offices doesn't exist. The restriction in sales offices will not be considered for the reports PO and PO+SO.

Data flow

Overview

The corporate trade report is a report which give an high level of details with a lot of information for all billing done by Solvay.

The data flow is based on the LSA method. The data visualization is done on the multiproviders MVSDSO53 (MP: Corporate trade (Global Sales)) .

Global Sales data layers:

  • Propagation Layer
  • Business Layer
  • Reporting Layer
  • Virtual Layer

Please see the data flow of the multiprovider MVSDSO53 (MP: Corporate trade (Global Sales)) generated from Performer Suite.

Propagation layer

The propagation Layer is same than the billing propagation layer of Global sales.

Business layer

List of DSOs used in the business layer:

DSO tech. nameDSO description

source DSO tech. name

source DSO description
DBSDSO9JGlobal sales: Corporate trade (Rhodia)DBSDSO46SO Global: Invoices (Rhodia)
DBSDSO67PO: Transfers orders Invoices (Rhodia)
DPSDSO48Billing Condition Data (Rhodia)
DBSDSO9IGlobal sales: Corporate trade (Solvay)DBSDSO06SO Global: Invoices (Solvay)
DBSDSO27PO: Transfers orders Invoices (Solvay)
DPSDSO08Billing Condition Data (Solvay)

Reporting layer

The reporting layer is the same than the business layer.

Virtual layer

List of infoproviders in the virtual layer:

MP tech. name

MP description

source CUBE tech. name

source CUBE description

MVSDSO53


MP: Corporate trade (Global Sales)

DBSDSO9J

DBSDSO9I

Global sales: Corporate trade (Rhodia)

Global sales: Corporate trade (Solvay)

Reporting

Workbook


Query


Historical Data: Corporate Trade (SO+PO)BW_WBK_MVSDSO53_001BW: Corporate trade by billing date (Core)BW_QRY_MVSDSO53_0001
Historical Data: Corporate Trade by Actual GI (SO+PO)BW_WBK_MVSDSO53_002BW: Corporate trade by actual GI date (Core)

BW_QRY_MVSDSO53_0002

Data loading

Main Process ChainFinal Info ProviderFrequencyStart TimeDuration
PC_GLOBAL_SALES_MAINCRSDSO41, 42...Daily~1:30am CET~3.5h
PC_SD_MAINCRSDSO01, 02...Daily~2:00am CET~1h
PC_GL_SALES_MAIN_POCRSDSO51, 52...Daily~6:00am CET~1h
PC_OBAS_TRANSFERS_MAINCRSDSO11, 12...Daily~6:00am CET~0.5h


Data Quality Controls

Data comes from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticality, workarounds and resolution plan.>

Roadmap