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. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO9J | Global sales: Corporate trade (Rhodia) | DBSDSO46 | SO Global: Invoices (Rhodia) |
| DBSDSO67 | PO: Transfers orders Invoices (Rhodia) | ||
| DPSDSO48 | Billing Condition Data (Rhodia) | ||
| DBSDSO9I | Global sales: Corporate trade (Solvay) | DBSDSO06 | SO Global: Invoices (Solvay) |
| DBSDSO27 | PO: Transfers orders Invoices (Solvay) | ||
| DPSDSO08 | Billing 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_001 | BW: Corporate trade by billing date (Core) | BW_QRY_MVSDSO53_0001 |
| Historical Data: Corporate Trade by Actual GI (SO+PO) | BW_WBK_MVSDSO53_002 | BW: Corporate trade by actual GI date (Core) | BW_QRY_MVSDSO53_0002 |
Data loading
| Main Process Chain | Final Info Provider | Frequency | Start Time | Duration |
|---|---|---|---|---|
| PC_GLOBAL_SALES_MAIN | CRSDSO41, 42... | Daily | ~1:30am CET | ~3.5h |
| PC_SD_MAIN | CRSDSO01, 02... | Daily | ~2:00am CET | ~1h |
| PC_GL_SALES_MAIN_PO | CRSDSO51, 52... | Daily | ~6:00am CET | ~1h |
| PC_OBAS_TRANSFERS_MAIN | CRSDSO11, 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.>