The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work. Remove the sections that are not relevant. |
Description | Ex : BW - Working Capital for GBU (Core Workbook) |
|---|---|
| Technical Name | Ex : BW_QRY_MPR_FC001_0022 |
Application | Ex : FIWC - Working Capital |
Info-provider | Ex : MPR_WC02 |
Usage type | Direct execution in Analyzer / Broadcast / Qlikview Source / ... |
Expected users | Ex: GBU zone and WW controllers |
Workbook/Query General Description
Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display | Insert screenshot | |
| Rows/Columns | Insert screenshot | |
| Value Display | Insert screenshot | |
| Planning | Insert screenshot | |
| Extended | Insert screenshot |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
Ex : Calendar Day | 0CALDAY | Single/Multiple/SelectOption/SAPexit/ClientExit | Yes/No | Explanation for the use of this variable |
Variable Sequence
Add screenshot
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
Add screenshot if relevant
Key figures
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Info-object Name | Info-object Text | Explanation (if needed) | DR |
|---|---|---|---|
| 0CALMONTH | Calendar Year/Month | Text | Column |
| 0LOGSYS | Source System | No display to avoid the display of the prefix for compound characteristics. | Row |
| C_MATNR2 | Material | Key + Text | Row |
| C_SHIPTID | SAP Ship-to | Key + Text Previously, the Ship-to was C_SHIPTO, but description were not daily loaded. Previous 30/10/2017, the description was 'Ship-to' | Row |
| 0DISTR_CHAN | Distribution Channel | Key + Text Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU. Also available for Logility flow, coming from Exclusion table since 01.2018 | Row |
| C_DYN_024 | Ship-to (including Prospects) | Will be available soon Available for DynaSys since 30/10/2017 | Free |
| CPFCTR1_2 | BFC Global Business Unit | Key + Text From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU | Free |
| C_MATNR2__0PROD_HIER | Prod. Hierarchy | Key + Text | Free |
| C_MATNR2__C_PROD | Commercial Product / Material Group | Key + Text Commercial Product for RCS WP1. Material Group for SOLVAY PF1. | Free |
| C_CUSTGP2 | Enterprise Customer Group (APO) | Key + Text Since 30/11/2017, only for APO (new axis for Dyn). Old description 'Enterprise Customer Group' | |
| C_SHTCTRY | Ship-to Country | Text | Free |
| C_SOLDID | Sold-to | Key + Text Previously, the Sold-to was C_SOLDTO, but description were not daily loaded. | Free |
| C_SOLDID__C_GRCUST | Industrial Group | Text V1 = C_CUSTOMR__C_GRCUST For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones. | Free |
| C_DYN_017__C_SAL_GRP | Sales Group | Sales Group = Sales Rep for RCS WP1 Only Source :
| Free |
| C_SHTCTRY__C_GZONE | Geo Zone | No description available | |
| C_DYN_005__C_TACTIC2 | Tactical Material | Description are available since 08/12/2016 | |
| C_DYN_017__C_ZIPART | CSO | Customer Service Officer (CSO) Only filled for RCS | |
| C_CUSTOMR__0REGION | Ship-to Region | ||
| C_CUSTOMR__0CITY | Ship-to City | Since 30/10/2017, for DynaSys info it comes from C_DYN_024 to get city for both SAP Ship-to and Sales Force Prospects | |
| C_DYN_018__C_MPPLANT | Main Shipping Plant | ||
| C_MATNR2__C_MAT_GRP | Material Group | ||
| C_MATNR2__C_MATGR2 | Packaging Type | Previous name : Material Group 2 (Release March 2017) For Solvay PF1 only | |
| C_MATNR2__C_DIVISN | Division | ||
| C_DYN_010 | BU | ||
| C_DYN_018__C_MSHCOND | Main Shipping Cond. | Available since 07/02/2017 Shipping Condition of the last M3 sales order not rejected (No reason for Rejection , Item Category M3N, most recent change on date) | |
| |||
| C_DYN_018__C_DYN_016 | Key Account (Ship-to KA) (APO) | RCS notion Text in MD C_GRCUST Available since 14/03/2017 Since 30/10/2017, For DynaSys/Logility, use Ship-to KA (GBR) (C_GBR15__C_SHIPKA) Will be removed soon. Use now the GBR one => item 480 | |
| C_MATNR2__C_MAGRV | Packaging Materials | Only for RCS Available since 14/03/2017 | |
| C_DYN_018__C_VEPART | Account Manager | PF1 notion Release April 2017 | |
| C_DYN_018__C_VWPART | CCS Rep | PF1 notion Release April 2017 | |
C_DYN_021__C_DYN_020 | Planning Zone | DYN Only Changed to C_DYN_021 27/11/2018 | |
| C_GBR14__C_GBR1 | Application | Previous to 30/10/2017, field was C_GBR5__C_GBR1 | |
| C_GBR14__C_GBR2 | Market | Previous to 30/10/2017, field was C_GBR5__C_GBR2 | |
| C_GBR14__C_GBR3 | Segment | Previous to 30/10/2017, field was C_GBR5__C_GBR3 | |
| C_GBR14__C_GBR4 | Corporate End Use | Previous to 30/10/2017, field was C_GBR5__C_GBR4 | |
| C_DYN_021__C_DYN_022 | ABC Class (auto) | DYN Only | |
| C_DYN_021__C_DYN_023 | ABC Class (manual) | DYN Only | |
| C_GBUZONE__C_ZONEH1 | GBU zone (hierarchy | Key and Text => Dyn Only | |
| C_GBUZONE__C_ZONEH2 | GBU zone (hier. 2) | Key and Text =>Dyn Only | |
| 0G_CWWE01 | IECRA | APO Only | |
| C_GBR18__C_GBR19 | GBU Material Group | Key and Text
| |
| C_GBR13__C_GBR9 | GBR Customer Sub Group | Key and Text Available since since 30/10/2017 | |
| C_GBR13__C_GBR6 | GBR Customer Group | Key + Text Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group' | |
| C_GBR15__C_SHIPKA | Ship-to KA (GBR) | Key and Text Available since since 30/10/2017 | |
| C_SHTCTRY__C_ZONE | BFC Geographie/Zone | Key and Text Available since since 30/10/2017 | |
| C_DYN_024__C_PROSP | Flag Prospect | Key and Text Available since since 30/10/2017
'X' Prospect
' ' Ship-to | |
| 0INFOPROV | InfoProvider | Key and Text Available since 30/10/2017 | |
| C_GBR18__C_GBR20 | GBU Material Sub-grp | Key and Text Available since 28/11/2017 | |
| C_MATNR2__C_LIP05 | Product line 05 | Key and Text Available since 28/11/2017 | |
| C_DYN_018__PRDFACT | Default Production Factory | Available since 31/05/2018 Attribut maintained only in DynaSys for RCS Material/Shipto | |
| C_MATNR2__C_LPROD | Product line 00 | Will be available soon | |
| C_MATNR2__C_LIP04 | Product Line 04 | Will be available soon | |
| C_MATNR2__C_FMPRD | Product Family | Will be available soon | |
| C_SOTCTRY | Sold-to Country | Will be available soon | |
| C_SOTCTRY__C_ZONE | Sold-to BFC Geographie/Zone | Will be available soon | |
| C_DYN_005__C_GRPPGMI | Product Group (PGMI) | Will be available soon. Available only for TS (filter on PGMI IC*) | |
| C_DYN_017__C_SALEMP | Sales Employee | To add | |
| C_DYN_018__C_INCOTRM | Incoterms (Solvay) | Key | |
| C_DYN_018__C_INCOTM2 | Incoterms 2 (Solvay) | Key | |
| C_DYN_017__C_INCOTRM | Incoterms (RCS) | Key Available since 18/10/2018 | |
| C_DYN_017__C_INCOTM2 | Incoterms 2 (RCS) | Key Available since 18/10/2018 | |
| C_GBR23__SGINFO4 | GBR Segment Info 4 | Available 13/12/2018 RCS only (depending on IECRA) | |
| C_GBR23__SGINFO5 | GBR Segment Info 5 | Available 13/12/2018 RCS only (depending on IECRA) |