(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

SCREEN - Pack. Inventory analysis - Detailed (Core Query) - BW_QRY_CPSCPK01_0001

Please update the doc there and no longer here.

(warning)    (warning)     (warning)     (warning)


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 - Detailed (Core Query))

Technical NameBW_QRY_CPSCPK01_0001

Application

Screen Packaging

Info-provider

CPSCPK01

Usage type

Analysis

Expected users


Workbook/Query General Description

General parameters

Global properties

TabScreenshotComment
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)FormulaSingle ValueYesFormula variable
Calendar Day (Single value)0DATESingle ValueYes
Plant (Selection Option, Optional)C_PLANTSelection OptionNo
Company Code (Multiple Values, Optional)C_COMPCDEMultiple Single ValuesNo
PRS Company code (Selection option, Optional)C_COMPPRSSelection OptionNo
Qty conv. unit (Single value)0UNITSingle valueNo
Target Curr. for conversion (Single value, Optional)0CURRENCYSingle ValueNo
1 - BFC GBU (Selection option, Optional)CPFCTR1_2Selection OptionNoAuthorization

Variable Sequence

Filters

ObjectFilter ValueExplanation

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

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement






Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No






  • No labels