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

SCREEN - Pack. Inventory analysis - Aggregated (Core Query)

Technical NameBW_QRY_CPSCPK01_0002

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

TabScreenshotComment
Display


Rows/Columns


Value DisplayInsert screenshot
Planning


Extended


Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Auth. Scope based on Comp. Code

V_C_COMPCDE__C_AUTHMA_0001

C_COMPCDE__C_AUTHMA

Selection Option

No

Authorization

Conso View ? (1=Yes/0=No)

V_CONSOV_0001

FormulaSingle ValueYesFormula variable

Calmonth (Single value)

V_0CALMONTH_0050

0CALMONTHSingle ValueYes

Company Code (Multiple Values, Optional)

V_C_COMPCDE_0014

C_COMPCDEMultiple Single ValuesNo

Plant (Selection Option, Optional)

V_C_PLANT_0010

C_PLANTSelection OptionNo

PRS Company code (Selection option, Optional)

V_COMPPRS_0006

C_COMPPRSSelection OptionNo

Qty conv. unit (Single value)

V_UNIT_0001

0UNITSingle valueNo

Target Curr. for conversion (Single value, Optional)

V_CURVAR_0003

0CURRENCYSingle ValueNo

1 - BFC GBU (Selection option, Optional)

V_CPFCTR1_2_0024

CPFCTR1_2Selection OptionNoAuthorization

Variable Sequence

Filters

ObjectFilter ValueExplanation
Ex : Status of the trading partner Ex : <> 1 Ex : Exclude intercompanies

Key figures




CK01 Total Inventory (FI var.view) Loc. Curr.

(V_CONSOV_0001 = 0 * RK01) + (V_CONSOV_0001 = 1 * CK02)

























CK02 Total Inventory (FI conso.view) Loc. Curr.

(RK01 - RK02 - RK03 - RK04) * V_K_INTRAT_0001 / 100

























CK03 Total Inventory (FI var.view) Qty

(V_CONSOV_0001 = 0 * CK04) + (V_CONSOV_0001 = 1 * CK05)

























CK04 Total Inventory (FI acct.view) QtyRK05 + RK06 + RK07























CK05 Total Inventory (FI conso.view) Qty

CK04 * V_K_INTRAT_0001 / 100

























CK06 Net Stock (MM) Qty

0RECTOTSTCK - 0ISSTOTSTCK

























CK07 Net Stock (MM conso.view) Qty

RK08 * V_K_INTRAT_0001 / 100

























CK08 Net Stock (MM var.view) Qty

(V_CONSOV_0001 = 0 * RK08) + (V_CONSOV_0001 = 1 * CK07)

























CK09 Total Inventory (FI var.view) Doc. Curr.

(V_CONSOV_0001 = 0 * RK09) + (V_CONSOV_0001 = 1 * CK10)

























CK10 Total Inventory (FI conso.view) Doc. Curr.

(RK09 - RK10 - RK11 - RK12) * V_K_INTRAT_0001 / 100








































































































RK01RK02RK03RK04RK05RK06RK07RK08RK09RK13RK10RK11RK12RK14RK15RK16RK17RK18RK19RK20RK21RK22RK23RK24RK25

Inventories (FI acct.view)
Loc. Curr.		Inv. bus. rule #1 (IT)
(FI conso.view)
Loc. Curr.		Inv. bus. rule #1bis (IT)
(FI conso.view)
Loc. Curr.		Inv. bus. rule #2
(FI conso.view)
Loc. Curr.		Inventories (FI acct.view)
Qty		Inv. - In transit (FI acct.view)
Qty		Inv. - WIP (FI acct.view)
Qty		Net Stock (MM) QtyInventories (FI acct.view)
Doc. Curr.		Net Stock (MM var.view) Qty w/o Consignm.Inv. bus. rule #1 (IT)
(FI conso.view)
Doc. Curr.		Inv. bus. rule #1bis (IT)
(FI conso.view)
Doc. Curr.		Inv. bus. rule #2
(FI conso.view)
Doc. Curr.		Purch. (FI acct.view) QtyCons. (FI acct.view) QtyOthers (FI acct.view) QtyPurch. (FI conso.view) QtyCons. (FI conso.view) QtyOthers (FI conso.view) QtyPurch. (FI acct.view) Doc. curr.Cons. (FI acct.view) Doc. curr.Others (FI acct.view) Doc. curr.Purch. (FI conso.view) Doc. curr.Cons. (FI conso.view) Doc. curr.Others (FI conso.view) Doc. curr.
KF0DEB_CRE_LC0DEB_CRE_LC0DEB_CRE_LC0DEB_CRE_LCK_QTYK_QTYK_QTYCK060DEB_CRE_DCCK080DEB_CRE_DC0DEB_CRE_DC0DEB_CRE_DCCK04CK04CK04CK05CK05CK05RK09RK09RK09CK10CK10CK10
0DOC_NUM-------------<> ###<> ###<> ###<> ###
0GL_ACCOUNT__C_STKACCT--<> XX-------<> XX---
-----
--
C_COMPCDE__0COUNTRY-ITIT-------ITIT----
-----
--
C_COMPCDE__C_COMPPRS---<> 0212
<> 5884		--------<> 0212
<> 5884		---
-----
--
C_COORDER__0ORDCATEG--------------05
40		<> 05
<> 40
05
40		<> 05
<> 40		-05
40		<> 05
<> 40
05
40		<> 05
<> 40
C_DOCTYP-S7
S8
ZU		S7
S8
ZU		-#
WA
WE
WI
WL
UE		-----S7
S8
ZU		S7
S8
ZU		----
-----
--
C_GL_STYP-----IN TRANSITWORK IN PROGRESS---------
-----
--
C_GL_TYPEINVENTORYINVENTORYINVENTORYINVENTORYINVENTORYINVENTORYINVENTORY-INVENTORY-INVENTORYINVENTORYINVENTORY---
-----
--
C_INFOPRODBMMIC01
DBMMIC02
DBFIGL03
DBFIGL06
DBFIGL13
DBFIGL14		DBFIGL03
DBFIGL06
DBFIGL13
DBFIGL14		DBFIGL14DBFIGL14DBMMIC01
DBMMIC02
DBFIGL03
DBFIGL06		DBFIGL13
DBFIGL14		DBFIGL13
DBFIGL14		ABMMIM02R
ABMMIM02S		DBMMIC01
DBMMIC02
DBFIGL03
DBFIGL06
DBFIGL13
DBFIGL14		-DBFIGL03
DBFIGL06
DBFIGL13
DBFIGL14		DBFIGL14DBFIGL14---
-----
--
C_MATNR2-----<>#<>#---------
-----
--
C_SOBKZ---------<> K---------------


Characteristics

LocationInfo-object NameInfo-object TextExplanation (if needed)
Row0LOGSYSSource Sys.
Row C_COMPCDECompany Code 
Row C_PLANTPlant 
RowC_MATNR2Material
Free0ACCT_TYPEAccount Type
Free0BASE_UOMBase UoM
Free0CALQUARTERCal. Quarter
Free0CALDAYCal. Day
Free0CALYEARCal. Year
Free0CALMONTHCal. Year/Month
Free0CHRT_ACCTSChart of Accts
Free0CO_AREACO Area
FreeC_COMPCDE__0COUNTRYComp. Country
FreeC_COMPCDE__C_AUTHMAComp. Auth. Scope
FreeC_COMPCDE__C_CSMETHComp. Conso. Method
FreeC_COMPCDE__C_FLGINTComp. Interco Flag
FreeC_COMPCDE__C_MERGDATComp. Merging date
FreeC_COMPCDE__C_MNGAREAComp. BFC Mgt Area
FreeC_COMPCDE__C_MNGCTRYComp. Mgt Country
FreeC_COMPCDE__C_PMERBKComp. Merged into
FreeC_COSTCTRCost Center
Free0DOC_CURRCYDoc. Curr.
Free0ITEM_NUMFI Doc. Item
Free0AC_DOC_NOFI Doc. Nb
FreeC_DOCTYPFI Doc. Type
Free0FISCPERFiscal year/Period
Free0FISCVARNTFY Variant
Free0GL_ACCOUNTGL Account
FreeC_GL_STYPGL Acct WC SubType
FreeC_GL_TYPEGL Acct WC Type
FreeC_INFOPROInfoprovider
Free0LOC_CURRCYLocal Curr.
FreeC_CTMCPKGMacroPackage
FreeC_PRODORD__C_MATNRManuf. Material
FreeC_MAT_GRP__C_DOMAINMat. Domain
FreeC_MAT_GRPMat. Material Grp
FreeC_MAT_GRP__C_SEGTMat. Segment
FreeC_VALCLASMat. Val. Class
FreeC_PRODORDManuf. Order
Free0DOC_YEARMM Doc. FY
FreeC_ZEILEMM Doc. Item
FreeC_MBLNRMM Doc. Nb
FreeC_MOVETYPMvt Type
FreeC_COORDEROrder
FreeC_COORDER__0ORDCATEGOrder Categ.
FreeC_CTPKGPackage
Free4CPSCPK01-PKG_SRCPack. Source
FreeC_PO_ITMPO Item
FreeC_PRMATGRPO Mat. Grp
Free0DOC_NUMPO Nb
FreeC_PRMATGR__C_DOMAINPO Purch. Domain
FreeC_PUR_GRPPO Purch. Grp
FreeC_PUR_ORGPO Purch. Org.
FreeC_PRMATGR__C_SEGTPO Purch. Segmt
FreeC_COMPCDE__C_COMPPRSPRS Comp. code
FreeC_CTDOMAIPurch. Domain
FreeC_CTSEGTPurch. Segment
FreeC_SITERSite
FreeC_SOBKZSpecial Stock Ind.
FreeC_SUBACT2Sub-Activity 2
FreeC_CTSBPKGSub-Package
Free0UNITUoM
FreeC_VENDIDVendor
FreeC_VENDID__C_DOMAINVendor Purch. Domain
FreeC_VENDID__C_SEGTVendor Purch. Segmt
FreeC_WBS_EL2WBS Element
FreeCPFCTR1_21 - BFC GBU
FreeCPFCTR2_22 - BFC Grp of Act.
FreeCPFCTR3_23 - 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)

OperatorValueCharacteristic 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

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10