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 | SCRE - Pack. Manuf. Consumption analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_CPSCPK03_0001 |
Application | Screen Packaging |
Info-provider | CPSCPK03 |
Usage type | Analysis |
Expected users |
Workbook/Query General Description
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 |
|---|---|---|---|---|
Auth. Scope based on Comp. Code | C_COMPCDE__C_AUTHMA | Selection Option | No | Authorization |
| Conso View ? (1=Yes/0=No) | Formula | Single Value | Yes | Formula variable |
| Calendar Month/Year (Interval, Mandatory) | 0CALMONTH | Interval | Yes | |
| Company Code (Multiple Values, Optional) | C_COMPCDE | Multiple Single Values | No | |
| Plant (Selection Option, Optional) | C_PLANT | Selection Option | No | |
| PRS Company code (Selection option, Optional) | C_COMPPRS | Selection Option | No | |
| Target Curr. for conversion (Single value, Optional) | 0CURRENCY | Single Value | No | |
| 1 - BFC GBU (Selection option, Optional) | CPFCTR1_2 | Selection Option | No | Authorization |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
Key figures
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 | Explanation (if needed) |
|---|---|---|---|
| Row | 0LOGSYS | Source Sys. | |
| Row | C_COMPCDE | Company Code | |
| Row | C_PLANT | Plant | |
| Row | C_MATPNT2 | Material (Prod.) | |
| Row | C_ORIMAT | Material (Pack.) | |
| Free | 0CALYEAR | Cal. Year | |
| Free | 0CALMONTH | Cal. Year/Month | |
| Free | 0CALQUARTER | Cal. Year/Quarter | |
| Free | 0CHRT_ACCTS | Chart of Accts | |
| Free | 0CO_AREA | CO Area | |
| Free | C_COMPCDE__C_AUTHMA | Comp. Auth. Scope | |
| Free | C_COMPCDE__C_CSMETH | Comp. Conso. Meth. | |
| Free | C_COMPCDE__0COUNTRY | Comp. Country | |
| Free | C_COMPCDE__C_FLGINT | Comp. Interco Flag | |
| Free | C_COMPCDE__C_MERGDAT | Comp. Merging Date | |
| Free | C_COMPCDE__C_PMERBK | Comp. Merged into | |
| Free | C_COMPCDE__C_MNGAREA | Comp. Mgt Area | |
| Free | C_COMPCDE__C_MNGCTRY | Comp. Mgt Country | |
| Free | 0COSTELMNT | Cost Element | |
| Free | 0CURRENCY | Currency | |
| Free | 0FISCVARNT | FY Variant | |
| Free | 0GL_ACCOUNT | GL Account | |
| Free | C_INDEX1 | Index1 | |
| Free | C_INFOPRO | InfoProvider | |
| Free | C_CTMCPKG | Macro-Package | |
| Free | C_MAT_GRP | Mat. Grp (Pack.) | |
| Free | C_ORIMAP3 | Mat. (Technical) (Pack.) | |
| Free | C_VALCLAS | Mat. Val. Class (Pack.) | |
| Free | C_COORDER | Order | |
| Free | C_COORDER__0ORDCATEG | Order Cat. | |
| Free | C_CTPKG | Package | |
| Free | 4CPSCPK03-PKG_SRC | Pack. Source | |
| Free | C_COMPCDE__C_COMPPRS | PRS Comp. Code | |
| Free | C_CTDOMAI | Purch. Domain | |
| Free | C_CTSEGT | Purch. Segment | |
| Free | C_CTSBPKG | Sub-Package | |
| Free | C_SITER | Site | |
| Free | C_SUBACT2 | Sub-Activity | |
| Free | U_UNITUM | UoM (Pack.) | |
| Free | CPFCTR1_2 | 1-BFC GBU | |
| Free | CPFCTR2_2 | 2-BFC Grp of Act. | |
| Free | CPFCTR3_2 | 3-BFC Activity |
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 | |||||