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.
Reporting
Workbook | Query | ||
|---|---|---|---|
| Data Admin - Customer Corporate Group | BW_WBK_SD_CPSDSO54_0001 | Customer Corporate Groups | BW_QRY_CPSDSO54_0009 |
| Data Admin - Customer Group | BW_WBK_SD_ADM_0002 | GBR - Corporate Group (core query) | BW_QRY_MVSDAD02_0009 |
| GBR - GBU Customer Group (core query) | BW_QRY_MVSDAD01_0008 | ||
| Historical Data: Sales Orders (Core query) | BW_QRY_MVSDSO44_SD0002 | ||
| Data Admin - Customer Master Data | BW_WBK_MVSDAD02_0005 | GBR - Customer Master data (core query) | BW_QRY_MVSDAD02_0005 |
| Data Admin - Material Master Data | BW_WBK_MVSDAD02_0006 | GBR - Material Master Data (core query) | BW_QRY_MVSDAD02_0006 |
| Data Admin - End Use | BW_WBK_SD_ADM_0001 | GBR - End Use Link (core query) | BW_QRY_MVSDAD01_0001 |
| GBR - End Use Axis (core query) | BW_QRY_MVSDAD01_0002 | ||
| BW - GBR - End Use Ship to Link (core query) | BW_QRY_MVSDAD01_0010 | ||
| Historical Data: Sales Orders (Core query) | BW_QRY_MVSDSO44_SD0002 | ||
| Data Admin - Material not Converted | BW_WBK_MVSDSO44_SD0009 | Data Admin: Material not converted (Core query) | BW_QRY_MVSDSO44_SD0009 |
| Data Admin - Ship-to KA | BW_WBK_MVSDSO44_SD0002_ADMIN | Historical Data: Sales Orders (Core query) | BW_QRY_MVSDSO44_SD0002 |
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.>