You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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 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

Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

Unit : 

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