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
Functional Specification Document :
Report Layout :
https://drive.google.com/file/d/1Ual3p8VzSuxMMfM1jiiaoHlXgT73xX5o/view
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 |
|---|---|---|---|---|
Convert Unit | 0CALDAY | Mandatory | Yes/No | default 'H' |
| Work Center (Select Option, Optional) | ||||
| Planning Senario (Interval Optional) | ||||
| Calendar Year/Month (Select Option, Optional) | ||||
| Plant (Multiple Value, Requiered) |
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
Number of Operators per Work Center
| Description | type | Restricted or Calculated KeyFigure | Source | Calculation rule | Conversion | Comments |
|---|---|---|---|---|---|---|
| Number of Operators per Work Center | CRHD-PARV2 CRHD-PARU2 | |||||
Forecasted Requirements (hours) per month/per Work Center – 18 months | Display | x | x | x | x | |
| Weekly Total Capacity | Keep as-is data logic |
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
| Location | Info-object Name | Info-object Text | Source | Explanation (if needed) |
|---|---|---|---|---|
| Row | 0COUNTRY | Work Center | Key + text | |
| Department | TC27T-PLANR | Key + Text PLANR => Capacity planner group If 2 capacity in certain work center. Capacity Category 001(Machine time) should be selected. CRHD->KAKO-PLANR->TC27T-Capacity Planner Group Text | ||
| Calendar | KAKO-KALID (KAPID??) description in table TFACT description KAKT-KTEXT | Key + text
If 2 capacity in certain work center. Capacity Category 001(Machine time) should be selected. | ||
| Weeks # Calculation based on Work Center/Calendar | ||||
| End date of Week | Based on Week in the report, list date of sunday in that week | |||
| Month | Based on End date of week Determine month and show up in the report |
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
If you have conditions, explain here.
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Ex : Excl if <=10 | Yes/No | Sales Value | Greater Than | 10 | Ex : All Independently |
Exceptions
If you have conditions, explain here.
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |
Data check with WPX
Transaction CR03 to display work center masterdata
Table CRHD Work Center Header