I_COPCCOrderAndItemCostsCube

CO PCC Order and Item Costs Cube | view: IFIPCCOAICSTCUBE | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCP, ACDOCA, COSB, COSP_BAK, COSS_BAK, COKEY, T001, TKA02, TKA01, CSKB, TKA01, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, T000, TKV09, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
CostElement General Ledger Account
CtrlgOriginClassification Origin Indicator Show values
ControllingDebitCreditCode Debit Indicator
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
PartnerCostObject Partner Object for Secondary Cost Elements
UnitOfMeasure Unit of Measure
Column Name Description
💲 Controlling Area Currency (ControllingAreaCurrency):
CreditActlCostInCtrlgAreaCrcy null
DebitActlCostInCtrlgAreaCrcy null
ActlCostInCtrlgAreaCrcy null
CrdtActlFxdCostInCOCrcy null
DebitActlFxdCostInCOCrcy null
ActlFixedCostInCtrlgAreaCrcy null
DebitActlVarblCostInCOCrcy null
CrdtActlVarblCostInCOCrcy null
CreditPlanCostInCtrlgAreaCrcy null
DebitPlanCostInCtrlgAreaCrcy null
CrdtPlnFxdCostInCtrlgAreaCrcy null
DebitPlnFxdCostInCtrlgAreaCrcy null
DebitPlnVarblCostInCOCrcy null
CrdtPlnVarblCostInCOCrcy null
PlanCostInCtrlgAreaCrcy null
PlanFixedCostInCtrlgAreaCrcy null
DebitStdCostInGlobalCrcy order standard cost debit in global currency
DebitStdFxdCostInGlobalCrcy Order Fixed Standard Cost Debit In Global Currency
DebitStdVarblCostInGlobalCrcy Order Variable Standard Cost Debit In Global Currency
CrdtTargetCostInCtrlgAreaCrcy null
DebitTargetCostInCtrlgAreaCrcy null
TargetCostInCtrlgAreaCrcy Target Cost Credit
TargetWIPAmountInCtrlgAreaCrcy null
CrdtPlanCtrlCostInGlobCrcy null
DebitPlanCtrlCostInGlobCrcy null
PlanCtrlCostInGlobCrcy Control Cost at Plan
CrdtActlCtrlCostInGlobCrcy null
DebitActlCtrlCostInGlobCrcy null
ActlCtrlCostInGlobCrcy Control cost at actual in global currency
InptPrVarcAmtInCtrlgAreaCrcy null
InptQtyVarcAmtInCtrlgAreaCrcy null
RsceUsgeVarcAmtInCtrlgAreaCrcy null
InptRmngVarcAmtInCtrlgAreaCrcy null
MixedPrVarcAmtInCtrlgAreaCrcy null
OutpPrVarcAmtInCtrlgAreaCrcy null
LotSizeVarcAmtInCtrlgAreaCrcy null
OutpQtyVarcAmtInCtrlgAreaCrcy null
OutpRmngVarcAmtInCtrlgAreaCrcy null
ScrapVarcAmtInCtrlgAreaCrcy null
CostVarianceInCOCrcy Cost Variance
WIPCostInCtrlgAreaCrcy null
UnrlzdCostRsrvAmtInGlobCrcy Reserves for Unrealized Costs
TotalWIPAmountInCOCrcy Total WIP
ActlPlnDiffCostInCOCrcy Plan/Actual Cost Variance
ActlTgtDiffCostInCOCrcy Target/Actual Cost Variance
💲 Order Currency (CompanyCodeCurrency):
CreditActlCostInCoCodeCrcy null
DebitActlCostInCoCodeCrcy null
ActlCostInCoCodeCrcy null
ActlVarblCostInCtrlgAreaCrcy null
DebitActlFixedCostInCoCodeCrcy null
CreditActlFixedCostInCCCrcy null
DebitActlVarblCostInCoCodeCrcy Debit Actual Variable Cost In Company Code Currency
CreditActlVarblCostInCCCrcy Credit Actual Variable Cost In Company Code Currency
ActlVarblCostInCoCodeCrcy Actual Variable Cost In Company Code Currency
ActlFixedCostInCoCodeCrcy null
CreditPlanCostInCoCodeCrcy null
DebitPlanCostInCoCodeCrcy null
DebitPlanFixedCostInCoCodeCrcy null
CreditPlanFixedCostInCCCrcy null
PlanCostInCoCodeCrcy null
DebitPlanVarblCostInCoCodeCrcy Debit Plan Variable Cost In Company Code Currency
CreditPlanVarblCostInCCCrcy Credit Plan Variable Cost In Company Code Currency
PlanVarblCostInCoCodeCrcy Plan Variable Cost In Company Code Currency
PlanVarblCostInCtrlgAreaCrcy null
PlanFixedCostInCoCodeCrcy null
DebitStdCostInCoCodeCrcy Order Standard Cost Debit In Company Code Currency
DebitStdFxdCostInCoCodeCrcy Order Fixed Standard Cost Debit In Company Code Currency
DebitStdVarblCostInCoCodeCrcy Order Variable Standard Cost Debit In Company Code Currency
CreditTargetCostInCoCodeCrcy null
DebitTargetCostInCoCodeCrcy null
TargetCostInCoCodeCrcy Target Cost In Company Code Currency
TargetWIPAmountInCoCodeCrcy null
CrdtPlanCtrlCostInCCCrcy null
DebitPlanCtrlCostInCCCrcy null
PlanCtrlCostInCoCodeCrcy control cost at plan in company code currency
CrdtActlCtrlCostInCCCrcy null
DebitActlCtrlCostInCCCrcy null
ActlCtrlCostInCoCodeCrcy control cost at actual in company code currency
InptPriceVarcAmtInCoCodeCrcy null
InptQtyVarcAmtInCoCodeCrcy null
RsceUsgeVarcAmtInCoCodeCrcy null
InputRmngVarcAmtInCoCodeCrcy null
MixedPrVarcAmtInCoCodeCrcy null
OutpPrVarcAmtInCoCodeCrcy null
LotSizeVarcAmtInCoCodeCrcy null
OutpQtyVarcAmtInCoCodeCrcy null
OutputRmngVarcAmtInCoCodeCrcy null
ScrapVarcAmtInCoCodeCrcy null
CostVarianceInCoCodeCurrency Cost Variance In Company Code Currency
WIPCostInCoCodeCrcy null
UnrlzdCostRsrvAmtInCoCodeCrcy Reserves for Unrealized Costs
TotalWIPAmountInCoCodeCrcy Total WIP
DebitActlPlnDiffCostInCOCrcy null
DebitActlPlnDiffCostInCCCrcy null
ActlPlanDiffCostInCoCodeCrcy Actual Plan Difference Cost In Company Code Currency
DebitActlTgtDiffCostInCOCrcy null
DebitActlTgtDiffCostInCCCrcy null
ActlTgtDiffCostInCoCodeCrcy Actual Target Difference Cost In Company Code Currency
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
ActualQtyInCostSourceUnit Actual Quantity
PlanQtyInCostSourceUnit Plan Quantity
TargetQtyInCostSourceUnit Target Quantity
PlanCtrlQtyInCostSourceUnit Plan Control Quantity In Cost Source Unit
ActlCtrlQtyInCostSourceUnit Actual Control Quantity In Cost Source Unit
ActlPlanDiffQuantity Plan/Actual Quantity Variance
ActlTgtDiffQuantity Target/Actual Quantity Variance
Column Name Description
ValidityDate null
Column Name Description
CtrlgOriginClassification Origin Indicator Show values
MfgOrderBusTransactionType Business Transaction on Manufacturing Orders Show values
OrderCategory Order Category Show values
Column Name Description Domain name
Plant Plant WERKS
Material Material Number MATNR
CostCompIsForCOGM null
DebitActlPlanDiffPercent Plan Debit/Actual Debit Cost Variance(%) KKB_PROZABW
CtrlgAreaCrcyActlPlanDiffPct Plan/Actual Cost Variance(%) KKB_PROZABW
CoCodeCrcyActlPlanDiffPercent Company Code Currency Actual Plan Difference Percent KKB_PROZABW
ActlPlanDiffQtyPct Plan/Actual Quantity Variance(%) KKB_PROZABW
DebitActlTgtDiffPercent Target Debit/Actual Debit Cost Variance(%) KKB_PROZABW
CtrlgAreaCrcyActlTgtDiffPct Target/Actual Variance (%) KKB_PROZABW
CoCodeCrcyActlTgtDiffPercent Company Code Currency Actual Target Difference Percent KKB_PROZABW
ActlTgtDiffQtyPct Target/Actual Quantity Variance (%) KKB_PROZABW
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODE == T001.BUKRS
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == T001.MANDT
Order Currency
  • Client
  • Controlling Area Currency
  • Order Currency
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == TCURC.MANDT
  • I_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == TKA01.MANDT
Controlling Area Currency
  • Client
  • Controlling Area Currency
  • Order Currency
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == TCURC.MANDT
  • I_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • I_COPCCORDERANDITEMCOSTSCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Order Type
  • Order Type
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.ORDERTYPE == T003O.AUART
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == T003O.CLIENT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_COPCCORDERANDITEMCOSTSCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_COPCCORDERANDITEMCOSTSCUBE.PROFITCENTER == CEPC.PRCTR
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == CEPC.MANDT
Responsible Cost Center
  • Controlling Area
  • ?
  • Responsible Cost Center
  • Client
  • I_COPCCORDERANDITEMCOSTSCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_COPCCORDERANDITEMCOSTSCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_COPCCORDERANDITEMCOSTSCUBE.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_COPCCORDERANDITEMCOSTSCUBE.MANDT == CSKS.MANDT