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 | |
|---|---|
| Technical Name | |
Application | |
Info-provider | |
Usage type | |
Expected users |
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 | ||
| Rows/Columns | ||
| Value Display | ||
| Planning | ||
| Extended |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
Convert Unit | Mandatory | default 'H' | ||
| Work Center (Select Option, Optional) | ||||
| Planning Senario (Interval Optional) | ||||
| Calendar Year/Month (Select Option, Optional) | ||||
| Plant (Multiple Value, Requiered) |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
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
Calculation rule detail
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
| Location | Info-object Name | Info-object Text | Source | Explanation (if needed) |
|---|---|---|---|---|
| Row | C_WORKCTR | Work Center | Key + text | |
| C_PLANR | 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 | |
| C_WORKCTR__0FACTCAL_ID | 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. | |
| 0WEEK | Weeks # Calculation based on Work Center/Calendar | |||
| C_WEEKDAY | End date of Week (Sunday) | Based on Week in the report, list date of sunday in that week | ||
| 0CALMONTH | Month | Based on End date of week (Sunday) Determine month and show up in the report |
Cells
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||
Data check with WPX
Transaction CR03 to display work center masterdata
Table CRHD Work Center Header