P_COActualCube

Private view for CO Actual Cube | view: PFICOACTULECUBE | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: ACDOCA
Column Name Description
ControllingObject FK Object number
ControllingKeySubNumber FK CO key subnumber
FiscalYearPeriod Fiscal Year + Fiscal Period
ControllingValueType Value Type Show values
ChartOfAccounts FK Chart of Accounts
CostElement FK Account Number
Version CO Version
BusinessTransactionType FK CO Business Transaction
CostOriginGroup FK Origin Group as Subdivision of Cost Element
OriginSenderObject FK Source Object (Cost Center/Activity Type)
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
AccountAssignmentType FK Object Type
AccountAssignment Account Assignment
CostCenter FK Cost Center
ActivityType FK Activity Type
OrderID FK Order Number
PartnerAccountAssignmentType FK Partner Object Type
PartnerCostObject FK Partner object (always filled)
PartnerCostCenter FK Sender cost center
PartnerCostCtrActivityType FK Partner activity
PartnerOrder FK Partner order number
PartnerBusinessProcess FK Partner Business Process
CtrlgOriginClassification Type of a General Ledger Account Show values
WorkCenterInternalID FK Object ID of the resource
OrderOperation Operation/Activity Number
Material FK Material Number
Plant FK Plant
UnitOfMeasure FK Unit of Measure for Valuation Quantity
GlobalCurrency FK Global Currency
CompanyCodeCurrency FK Company Code Currency
Column Name Description
AmountInGlobalCurrency null
FixedAmountInGlobalCrcy null
AmountInCompanyCodeCurrency null
FixedAmountInCoCodeCrcy null
AmountInObjectCurrency null
FixedAmountInObjectCurrency null
Column Name Description
TotalQuantity null
FixedQuantity null
Column Name Description
Column Name Description
ControllingValueType Value Type Show values
ControllingDebitCreditCode Debit/Credit Indicator (Origin) Show values
CtrlgOriginClassification Type of a General Ledger Account Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Activity Type
  • ?
  • Activity Type
  • Client
  • ?
  • P_COACTUALCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • P_COACTUALCUBE.ACTIVITYTYPE == CSLA.LSTAR
  • P_COACTUALCUBE.MANDT == CSLA.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == CSLA.KOKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_COACTUALCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • P_COACTUALCUBE.MANDT == T004.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_COACTUALCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • P_COACTUALCUBE.MANDT == TCURC.MANDT
CO key subnumber
  • Client
  • CO key subnumber
  • P_COACTUALCUBE.MANDT == COKEY.MANDT
  • P_COACTUALCUBE.CONTROLLINGKEYSUBNUMBER == COKEY.HRKFT
Cost Center
  • ?
  • Cost Center
  • Client
  • ?
  • P_COACTUALCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • P_COACTUALCUBE.COSTCENTER == CSKS.KOSTL
  • P_COACTUALCUBE.MANDT == CSKS.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
Account Number
  • Account Number
  • ?
  • Client
  • P_COACTUALCUBE.COSTELEMENT == SKB1.SAKNR
  • P_COACTUALCUBE.[column in domain "BUKRS"] == SKB1.BUKRS
  • P_COACTUALCUBE.MANDT == SKB1.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Origin Group as Subdivision of Cost Element
  • Client
  • ?
  • P_COACTUALCUBE.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_COACTUALCUBE.COSTORIGINGROUP == TKKH1.HRKFT
  • P_COACTUALCUBE.MANDT == TKKH1.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == TKKH1.KOKRS
Global Currency
  • Global Currency
  • Client
  • P_COACTUALCUBE.GLOBALCURRENCY == TCURC.WAERS
  • P_COACTUALCUBE.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_COACTUALCUBE.MATERIAL == MARA.MATNR
  • P_COACTUALCUBE.MANDT == MARA.MANDT
Order Number
  • Client
  • Order Number
  • P_COACTUALCUBE.MANDT == AUFK.MANDT
  • P_COACTUALCUBE.ORDERID == AUFK.AUFNR
Partner Business Process
  • ?
  • Client
  • ?
  • Partner Business Process
  • P_COACTUALCUBE.[column in domain "DATBI"] == CBPR.DATBI
  • P_COACTUALCUBE.MANDT == CBPR.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == CBPR.KOKRS
  • P_COACTUALCUBE.PARTNERBUSINESSPROCESS == CBPR.PRZNR
Sender cost center
  • ?
  • Sender cost center
  • Client
  • ?
  • P_COACTUALCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • P_COACTUALCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_COACTUALCUBE.MANDT == CSKS.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == CSKS.KOKRS
Partner activity
  • ?
  • Partner activity
  • Client
  • ?
  • P_COACTUALCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • P_COACTUALCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_COACTUALCUBE.MANDT == CSLA.MANDT
  • P_COACTUALCUBE.[column in domain "KOKRS"] == CSLA.KOKRS
Partner order number
  • Partner order number
  • Client
  • P_COACTUALCUBE.PARTNERORDER == AUFK.AUFNR
  • P_COACTUALCUBE.MANDT == AUFK.MANDT
Plant
  • Plant
  • Client
  • P_COACTUALCUBE.PLANT == T001W.WERKS
  • P_COACTUALCUBE.MANDT == T001W.MANDT
Unit of Measure for Valuation Quantity
  • Client
  • Unit of Measure for Valuation Quantity
  • P_COACTUALCUBE.MANDT == T006.MANDT
  • P_COACTUALCUBE.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • P_COACTUALCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_COACTUALCUBE.MANDT == CRID.MANDT
  • P_COACTUALCUBE.WORKCENTERINTERNALID == CRID.OBJID