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 data flow is based on the LSA method. The data visualization is done on the MultiProviders MVSDSO56 (Global Sales: Historical data (SO+PO)) and MVSDSO57 (Global Sales: Historical data JUMP (PO+SO)).
Global Sales data layers:
- Propagation Layer
- Business Layer
- Reporting Layer
- Virtual Layer
See the data flow of the MultiProvider MVSDSO56 (MP: Global PO (Global Sales)) generated from Performer Suite.
See the data flow of the MultiProvider MVSDSO57 (Global Sales: Historical data JUMP (PO+SO)) generated from Performer Suite.
Propagation layer
The propagation layer is same than for Historical data sales order and Historical data transfers orders
Business layer
List of InfoProviders used in the business layer:
| DSO tech. name | DSO description | source DSO tech. name | source DSO description |
|---|---|---|---|
| DBSDSO9O | Global sales: Delivery (PO+SO) (Rhodia) | DBSDSO54 | SO Global: Deliveries (Rhodia) |
| DBSDSO69 | PO Global: Transfers orders delivery (Rhodia) | ||
| DBSDSO9N | Global sales: Delivery (PO+SO) (Solvay) | DBSDSO14 | SO Global: Deliveries (Solvay) |
| DBSDSO29 | PO Global: Transfers orders delivery (Solvay) | ||
| DBSDSO9Q | Global sales: Invoice (PO+SO) (Rhodia) | DBSDSO46 | SO Global: Invoices (Rhodia) |
| DBSDSO67 | PO: Transfers orders Invoices (Rhodia) | ||
| DBSDSO9P | Global sales: Invoice (PO+SO) (Solvay) | DBSDSO06 | SO Global: Invoices (Solvay) |
| DBSDSO27 | PO: Transfers orders Invoices (Solvay) | ||
| DBSDSO9M | Global sales: Order line (PO+SO) (Rhodia) | DBSDSO51 | SO Global: Sales Document Item Data (Rhodia) |
| DBSDSO70 | PO: Order line Transfers orders (Rhodia) | ||
| DBSDSO9L | Global sales: Order line (PO+SO) (Solvay) | DBSDSO11 | SO Global: Sales Document Item Data (Solvay) |
| DBSDSO30 | PO: Order line Transfers orders (Solvay) |
Reporting layer
List of infoproviders used in the reporting layer:
CUBE tech. name | CUBE description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
| CRSDSO58 | Global Sales: Delivery (PO+SO) (Rhodia) | DBSDSO9O | Global sales: Delivery (PO+SO) (Rhodia) |
| CRSDSO56 | Global Sales: Delivery (PO+SO) (Solvay) | DBSDSO9N | Global sales: Delivery (PO+SO) (Solvay) |
| CRSDSO60 | Global Sales: Invoice aggregated (PO+SO) (Rhodia) | DBSDSO9Q | Global sales: Invoice (PO+SO) (Rhodia) |
| CRSDSO59 | Global Sales: Invoice aggregated (PO+SO) (Solvay) | DBSDSO9P | Global sales: Invoice (PO+SO) (Solvay) |
| CRSDSO55 | Global Sales: Order line (PO+SO) (Rhodia) | DBSDSO9M | Global sales: Order line (PO+SO) (Rhodia) |
| CRSDSO49 | Global Sales: Order line (PO+SO) (Solvay) | DBSDSO9L | Global sales: Order line (PO+SO) (Solvay) |
| CRSDTR03 | TR Rep: Shipment Costs (Rhodia) | DBSDTR03 | TR Bus: Shipment Costs (Rhodia) |
| CRSDTR23 | TR Rep: Shipment Costs (Solvay) | DBSDTR23 | TR Bus: Shipment Costs (Solvay) |
Virtual layer
List of InfoProviders used in the virtual layer:
MP tech. name | MP description | source CUBE tech. name | source CUBE description |
|---|---|---|---|
MVSDSO56 | Global Sales: Historical data (SO+PO) | CRSDSO58 CRSDSO56 CRSDSO60 CRSDSO59 CRSDSO55 CRSDSO49 CRSDTR03 CRSDTR23 | Global Sales: Delivery (PO+SO) (Rhodia) Global Sales: Delivery (PO+SO) (Solvay) Global Sales: Invoice aggregated (PO+SO) (Rhodia) Global Sales: Invoice aggregated (PO+SO) (Solvay) Global Sales: Order line (PO+SO) (Rhodia) Global Sales: Order line (PO+SO) (Solvay) TR Rep: Shipment Costs (Rhodia) TR Rep: Shipment Costs (Solvay) |
| MVSDSO57 | Global Sales: Historical data JUMP (PO+SO) | DBSDSO9O DBSDSO9N DBSDSO9Q DBSDSO9P DBSDSO9M DBSDSO9L | Global sales: Delivery (PO+SO) (Rhodia) Global sales: Delivery (PO+SO) (Solvay) Global sales: Invoice (PO+SO) (Rhodia) Global sales: Invoice (PO+SO) (Solvay) Global sales: Order line (PO+SO) (Rhodia) Global sales: Order line (PO+SO) (Solvay) |
Reporting
Workbook | Query | ||
|---|---|---|---|
| Historical Data : Deliveries SO/PO (Detailed) | BW_WBK_MVSDSO57_0002 | BW - Deliveries details SO&PO (core query) | BW_QRY_MVSDSO57_0002 |
| Historical Data: Invoices Document Flow by creation date (SO+PO) | BW_WBK_MVSDSO57_0005 | BW - Invoices document flow details SO&PO (core query) | BW_QRY_MVSDSO57_0005 |
| Historical Data: Invoices SO/PO (Detailed) | BW_WBK_MVSDSO57_0001 | BW - Invoices details SO&PO (core query) | BW_QRY_MVSDSO57_0001 |
| Historical Data: Orders SO/PO (Detailed) | BW_WBK_MVSDSO57_0003 | BW - Orders details SO&PO (core query) | BW_QRY_MVSDSO57_0003 |
| Historical Data: Invoices vs Transport. Costs (SO/PO) | BW_WBK_MVSDSO56_0007 | Historical Data: Invoices vs Transp.Costs SO/PO (core query) | BW_QRY_MVSDSO56_0007 |
| Historical Data: Sales & Purchase deliveries | BW_WBK_MVSDSO56_0001 | Historical Data: Deliveries SO/PO (core query) | BW_QRY_MVSDSO56_0001 |
| Historical Data: Sales & Purchase invoices | BW_WBK_MVSDSO56_0003 | Historical Data: Invoices SO/PO (core query) | BW_QRY_MVSDSO56_0003 |
| Historical Data: Sales & Purchase orders | BW_WBK_MVSDSO56_0003 | Historical Data: Orders SO/PO (core query) | BW_QRY_MVSDSO56_0002 |
| Historical Data: Sales & Purchase overview | BW_WBK_MVSDSO56_0004 | Historical Data: Sales & Purchase Overview (core query) | BW_QRY_MVSDSO56_0004 |
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.>
Roadmap
<List past & future evolutions for the application (including links to MED/FSD/TSD)>