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. Inventory analysis (Core Query) |
|---|---|
| Technical Name | BW_QRY_CPSCPK01_0001 |
Application | Screen Packaging |
Info-provider | CPSCPK01 |
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 Day (Single value) | 0DATE | Single Value | Yes | |
| Plant (Selection Option, Optional) | C_PLANT | Selection Option | No | |
| Company Code (Multiple Values, Optional) | C_COMPCDE | Multiple Single Values | No | |
| PRS Company code (Selection option, Optional) | C_COMPPRS | Selection Option | No | |
| Qty conv. unit (Single value) | 0UNIT | Single value | 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_MATNR2 | Material | |
| Free | 0ACCT_TYPE | Account Type | |
| 0BASE_UOM | Base UoM | ||
| 0CALQUARTER | Cal. Quarter | ||
| 0CALDAY | Cal. Day | ||
| 0CALYEAR | Cal. Year | ||
| 0CALMONTH | Cal. Year/Month | ||
| 0CHRT_ACCTS | Chart of Accts | ||
| 0CO_AREA | CO Area | ||
| C_COMPCDE__0COUNTRY | Comp. Country | ||
| C_COMPCDE__C_AUTHMA | Comp. Auth. Scope | ||
| C_COMPCDE__C_CSMETH | Comp. Conso. Method | ||
| C_COMPCDE__C_FLGINT | Comp. Interco Flag | ||
| C_COMPCDE__C_MERGDAT | Comp. Merging date | ||
| C_COMPCDE__C_MNGAREA | Comp. BFC Mgt Area | ||
| C_COMPCDE__C_MNGCTRY | Comp. Mgt Country | ||
| C_COMPCDE__C_PMERBK | Comp. Merged into | ||
| C_COSTCTR | Cost Center | ||
| 0DOC_CURRCY | Doc. Curr. | ||
| 0ITEM_NUM | FI Doc. Item | ||
| 0AC_DOC_NO | FI Doc. Nb | ||
| C_DOCTYP | FI Doc. Type | ||
| 0FISCPER | Fiscal year/Period | ||
| 0FISCVARNT | FY Variant | ||
| 0GL_ACCOUNT | GL Account | ||
| C_GL_STYP | GL Acct WC SubType | ||
| C_GL_TYPE | GL Acct WC Type | ||
| C_INFOPRO | Infoprovider | ||
| 0LOC_CURRCY | Local Curr. | ||
| C_CTMCPKG | MacroPackage | ||
| C_PRODORD__C_MATNR | Manuf. Material | ||
| C_MAT_GRP__C_DOMAIN | Mat. Domain | ||
| C_MAT_GRP | Mat. Material Grp | ||
| C_MAT_GRP__C_SEGT | Mat. Segment | ||
| C_VALCLAS | Mat. Val. Class | ||
| C_PRODORD | Manuf. Order | ||
| 0DOC_YEAR | MM Doc. FY | ||
| C_ZEILE | MM Doc. Item | ||
| C_MBLNR | MM Doc. Nb | ||
| C_MOVETYP | Mvt Type | ||
| C_COORDER | Order | ||
| C_COORDER__0ORDCATEG | Order Categ. | ||
| C_CTPKG | Package | ||
| 4CPSCPK01-PKG_SRC | Pack. Source | ||
| C_PO_ITM | PO Item | ||
| C_PRMATGR | PO Mat. Grp | ||
| 0DOC_NUM | PO Nb | ||
| C_PRMATGR__C_DOMAIN | PO Purch. Domain | ||
| C_PUR_GRP | PO Purch. Grp | ||
| C_PUR_ORG | PO Purch. Org. | ||
| C_PRMATGR__C_SEGT | PO Purch. Segmt | ||
| C_COMPCDE__C_COMPPRS | PRS Comp. code | ||
| C_CTDOMAI | Purch. Domain | ||
| C_CTSEGT | Purch. Segment | ||
| C_SITER | Site | ||
| C_SOBKZ | Special Stock Ind. | ||
| C_SUBACT2 | Sub-Activity 2 | ||
| C_CTSBPKG | Sub-Package | ||
| 0UNIT | UoM | ||
| C_VENDID | Vendor | ||
| C_VENDID__C_DOMAIN | Vendor Purch. Domain | ||
| C_VENDID__C_SEGT | Vendor Purch. Segmt | ||
| C_WBS_EL2 | WBS Element | ||
| CPFCTR1_2 | 1 - BFC GBU | ||
| CPFCTR2_2 | 2 - BFC Grp of Act. | ||
| CPFCTR3_2 | 3 - BFC Activity 2 |
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 | |||||