P_COPCCOrderAndItemCostsCube

CO PCC Order Costs Cube | view: PFIPCCOAICSTCUBE | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCP, ACDOCA, COSB, COSP_BAK, COSS_BAK, COKEY, T001, TKA02, TKA01, CSKB, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, T000, TKV09, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
CostElement General Ledger Account
CtrlgOriginClassification null
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
MfgOrderBusTransactionType Business Transaction on Manufacturing Orders Show values
OriginCostCenter Sender cost center
OriginCostCtrActivityType Origin Activity Type
OriginBusinessProcess Business Process
OriginOrder Origin Order Number
CostOriginType Origin Type
OriginObject Origin for Primary and Secondary Cost Elements
CostOriginGroup Origin Group
PartnerCostCenter Sender cost center
PartnerCostCtrActivityType Partner activity
PartnerBusinessProcess Partner Business Process
PartnerOrder Partner Order
Partner Partner Object for Secondary Cost Elements
UnitOfMeasure Unit of Measure for Valuation Quantity
Column Name Description
💲 Order Currency (CompanyCodeCurrency):
CreditActlCostInCtrlgAreaCrcy null
DebitActlCostInCtrlgAreaCrcy null
ActlCostInCtrlgAreaCrcy null
CrdtActlFxdCostInCOCrcy null
DebitActlFxdCostInCOCrcy null
ActlFixedCostInCtrlgAreaCrcy null
DebitActlVarblCostInCOCrcy null
CrdtActlVarblCostInCOCrcy null
ActlVarblCostInCtrlgAreaCrcy null
CreditActlCostInCoCodeCrcy null
DebitActlCostInCoCodeCrcy null
ActlCostInCoCodeCrcy null
CreditActlFixedCostInCCCrcy null
DebitActlVarblCostInCoCodeCrcy null
CreditActlVarblCostInCCCrcy null
ActlVarblCostInCoCodeCrcy null
ActlFixedCostInCoCodeCrcy null
DebitActlFixedCostInCoCodeCrcy null
PlanCostInCtrlgAreaCrcy null
CreditPlanCostInCtrlgAreaCrcy null
DebitPlanCostInCtrlgAreaCrcy null
CrdtPlnFxdCostInCtrlgAreaCrcy null
DebitPlnFxdCostInCtrlgAreaCrcy null
PlanFixedCostInCtrlgAreaCrcy null
DebitPlnVarblCostInCOCrcy null
CrdtPlnVarblCostInCOCrcy null
PlanVarblCostInCtrlgAreaCrcy null
PlanCostInCoCodeCrcy null
CreditPlanCostInCoCodeCrcy null
DebitPlanCostInCoCodeCrcy null
DebitPlanVarblCostInCoCodeCrcy null
CreditPlanVarblCostInCCCrcy null
PlanVarblCostInCoCodeCrcy null
PlanFixedCostInCoCodeCrcy null
DebitPlanFixedCostInCoCodeCrcy null
CreditPlanFixedCostInCCCrcy null
DebitStdCostInGlobalCrcy null
DebitStdFxdCostInGlobalCrcy null
DebitStdVarblCostInGlobalCrcy null
DebitStdCostInCoCodeCrcy null
DebitStdFxdCostInCoCodeCrcy null
DebitStdVarblCostInCoCodeCrcy null
CrdtTargetCostInCtrlgAreaCrcy null
DebitTargetCostInCtrlgAreaCrcy null
TargetCostInCtrlgAreaCrcy null
CreditTargetCostInCoCodeCrcy null
DebitTargetCostInCoCodeCrcy null
TargetCostInCoCodeCrcy null
TargetWIPAmountInCtrlgAreaCrcy null
TargetWIPAmountInCoCodeCrcy null
CrdtPlanCtrlCostInGlobCrcy null
DebitPlanCtrlCostInGlobCrcy null
PlanCtrlCostInGlobCrcy null
CrdtPlanCtrlCostInCCCrcy null
DebitPlanCtrlCostInCCCrcy null
PlanCtrlCostInCoCodeCrcy null
CrdtActlCtrlCostInGlobCrcy null
DebitActlCtrlCostInGlobCrcy null
ActlCtrlCostInGlobCrcy null
CrdtActlCtrlCostInCCCrcy null
DebitActlCtrlCostInCCCrcy null
ActlCtrlCostInCoCodeCrcy null
InptPrVarcAmtInCtrlgAreaCrcy null
InptQtyVarcAmtInCtrlgAreaCrcy null
RsceUsgeVarcAmtInCtrlgAreaCrcy null
InptRmngVarcAmtInCtrlgAreaCrcy null
MixedPrVarcAmtInCtrlgAreaCrcy null
OutpPrVarcAmtInCtrlgAreaCrcy null
LotSizeVarcAmtInCtrlgAreaCrcy null
OutpQtyVarcAmtInCtrlgAreaCrcy null
OutpRmngVarcAmtInCtrlgAreaCrcy null
ScrapVarcAmtInCtrlgAreaCrcy null
CostVarianceInCOCrcy null
InptPriceVarcAmtInCoCodeCrcy null
InptQtyVarcAmtInCoCodeCrcy null
RsceUsgeVarcAmtInCoCodeCrcy null
InputRmngVarcAmtInCoCodeCrcy null
MixedPrVarcAmtInCoCodeCrcy null
OutpPrVarcAmtInCoCodeCrcy null
LotSizeVarcAmtInCoCodeCrcy null
OutpQtyVarcAmtInCoCodeCrcy null
OutputRmngVarcAmtInCoCodeCrcy null
ScrapVarcAmtInCoCodeCrcy null
CostVarianceInCoCodeCurrency null
WIPCostInCtrlgAreaCrcy null
UnrlzdCostRsrvAmtInGlobCrcy null
WIPCostInCoCodeCrcy null
UnrlzdCostRsrvAmtInCoCodeCrcy null
DebitActlPlnDiffCostInCOCrcy null
DebitActlPlnDiffCostInCCCrcy null
ActlPlanDiffCostInCOCrcy null
ActlPlanDiffCostInCoCodeCrcy null
DebitActlTgtDiffCostInCOCrcy null
DebitActlTgtDiffCostInCCCrcy null
ActlTgtDiffCostInCOCrcy null
ActlTgtDiffCostInCoCodeCrcy null
Column Name Description
ActualQuantity null
PlanQuantity null
TargetQuantity null
PlanControlQuantity null
ActualControlQuantity null
WIPQuantity null
ActlPlanDiffQuantity null
ActlTgtDiffQuantity null
Column Name Description
Column Name Description
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
MfgOrderBusTransactionType Business Transaction on Manufacturing Orders Show values
OrderCategory Order Category Show values
Column Name Description Domain name
OrderDescription Order Description TEXT40
Plant Plant WERKS
Material Material Number MATNR
DebitActlPlanDiffPercent Plan Debit/Actual Debit Cost Variance(%) KKB_PROZABW
CtrlgAreaCrcyActlPlanDiffPct Plan/Actual Cost Variance(%) KKB_PROZABW
CoCodeCrcyActlPlanDiffPercent Plan/Actual Cost Variance(%) KKB_PROZABW
ActlPlanDiffQtyPct null
DebitActlTgtDiffPercent Target Debit/Actual Debit Cost Variance(%) KKB_PROZABW
CtrlgAreaCrcyActlTgtDiffPct Target/Actual Variance (%) KKB_PROZABW
CoCodeCrcyActlTgtDiffPercent Target/Actual Variance (%) KKB_PROZABW
ActlTgtDiffQtyPct null
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == TGSB.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_COPCCORDERANDITEMCOSTSCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODE == T001.BUKRS
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == T001.MANDT
Order Currency
  • Client
  • Controlling Area Currency
  • Order Currency
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == TCURC.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • P_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == TKA01.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == TKA01.KOKRS
Controlling Area Currency
  • Client
  • Controlling Area Currency
  • Order Currency
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == TCURC.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • P_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Order Type
  • Client
  • Order Type
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == T003O.CLIENT
  • P_COPCCORDERANDITEMCOSTSCUBE.ORDERTYPE == T003O.AUART
Profit Center
  • ?
  • Client
  • Profit Center
  • Controlling Area
  • P_COPCCORDERANDITEMCOSTSCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == CEPC.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.PROFITCENTER == CEPC.PRCTR
  • P_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == CEPC.KOKRS
Reference Order Number
  • Client
  • Reference Order Number
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == AUFK.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.REFERENCEORDER == AUFK.AUFNR
Responsible Cost Center
  • Responsible Cost Center
  • ?
  • Client
  • Controlling Area
  • P_COPCCORDERANDITEMCOSTSCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • P_COPCCORDERANDITEMCOSTSCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • P_COPCCORDERANDITEMCOSTSCUBE.MANDT == CSKS.MANDT
  • P_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == CSKS.KOKRS