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

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	$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-14-33.png$
Rows/Columns	$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-15-27.png$
Value Display	Insert screenshot
Planning	$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-17-9.png$
Extended	$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-17-55.png$

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

$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-18-30.png$

Filters

Object	Filter Value	Explanation
Ex : Status of the trading partner	Ex : <> 1	Ex : Exclude intercompanies

$TECHNO - BI TEAM > SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001 /!\ Obsolete /!\ > image2020-12-9_15-44-19.png$

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

Location	Info-object Name	Info-object Text
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

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