P_COActlPlnTgtVarcRAUnion

Private view for CO Costs Union | view: PFIAPTVRAUNION | TRAN | Extraction: Not supported | Component: Cost Object Controlling

Tables used: COSL, AFKO, AFPO, ACDOCP, ACDOCA, COSB, COSP_BAK, COSS_BAK, T001, TKA02, 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

🔑 Keys (22)
💰 Amounts (4)
∑ Quantities (1)
📅 Dates
☰ Categorical (3)
Other
🔗 Relations (13)

Column Name	Description
ControllingObject FK	Object number
FiscalYearPeriod	Fiscal Year + Fiscal Period
ControllingValueType	Value Type	Show values
PlanningCategory	Plan Category
VarianceResultsAnlysCategory	Category for Variance/Results Analysis	Show values
CostElement FK	Account Number
ControllingKeySubNumber FK	CO key subnumber
BusinessTransactionType FK	CO Business Transaction
ControllingDebitCreditCode	Debit/Credit Indicator (Origin)	Show values
AccountAssignmentType FK	Object 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
PartnerBusinessProcess FK	Partner Business Process
PartnerOrder FK	Partner order number
OriginSenderObject FK	Source Object (Cost Center/Activity Type)
CtrlgOriginClassification	null
UnitOfMeasure FK	Unit of Measure for Valuation Quantity
Material FK	Material Number
CostOriginGroup FK	Origin Group as Subdivision of Cost Element

Column Name	Description
AmountInGlobalCurrency	null
FixedAmountInGlobalCrcy	null
AmountInObjectCurrency	null
FixedAmountInObjectCurrency	null

Column Name	Description
TotalQuantity	null

Column Name	Description

Column Name	Description
ControllingValueType	Value Type	Show values
VarianceResultsAnlysCategory	Category for Variance/Results Analysis	Show values
ControllingDebitCreditCode	Debit/Credit Indicator (Origin)	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
CO key subnumber CO key subnumber Client	`P_COACTLPLNTGTVARCRAUNION.CONTROLLINGKEYSUBNUMBER == COKEY.HRKFT` `P_COACTLPLNTGTVARCRAUNION.MANDT == COKEY.MANDT`
Account Number Account Number ? Client	`P_COACTLPLNTGTVARCRAUNION.COSTELEMENT == SKB1.SAKNR` `P_COACTLPLNTGTVARCRAUNION.[column in domain "BUKRS"] == SKB1.BUKRS` `P_COACTLPLNTGTVARCRAUNION.MANDT == SKB1.MANDT`
Origin Group as Subdivision of Cost Element Origin Group as Subdivision of Cost Element ? ? Client	`P_COACTLPLNTGTVARCRAUNION.COSTORIGINGROUP == TKKH1.HRKFT` `P_COACTLPLNTGTVARCRAUNION.[column in domain "KOKRS"] == TKKH1.KOKRS` `P_COACTLPLNTGTVARCRAUNION.[column in domain "HRKTYP"] == TKKH1.KOATY` `P_COACTLPLNTGTVARCRAUNION.MANDT == TKKH1.MANDT`
Material Number Material Number Client	`P_COACTLPLNTGTVARCRAUNION.MATERIAL == MARA.MATNR` `P_COACTLPLNTGTVARCRAUNION.MANDT == MARA.MANDT`
Order Number Order Number Client	`P_COACTLPLNTGTVARCRAUNION.ORDERID == AUFK.AUFNR` `P_COACTLPLNTGTVARCRAUNION.MANDT == AUFK.MANDT`
Partner Business Process Partner Business Process ? ? Client	`P_COACTLPLNTGTVARCRAUNION.PARTNERBUSINESSPROCESS == CBPR.PRZNR` `P_COACTLPLNTGTVARCRAUNION.[column in domain "KOKRS"] == CBPR.KOKRS` `P_COACTLPLNTGTVARCRAUNION.[column in domain "DATBI"] == CBPR.DATBI` `P_COACTLPLNTGTVARCRAUNION.MANDT == CBPR.MANDT`
Sender cost center Sender cost center ? ? Client	`P_COACTLPLNTGTVARCRAUNION.PARTNERCOSTCENTER == CSKS.KOSTL` `P_COACTLPLNTGTVARCRAUNION.[column in domain "KOKRS"] == CSKS.KOKRS` `P_COACTLPLNTGTVARCRAUNION.[column in domain "DATBI"] == CSKS.DATBI` `P_COACTLPLNTGTVARCRAUNION.MANDT == CSKS.MANDT`
Partner activity ? Partner activity ? Client	`P_COACTLPLNTGTVARCRAUNION.[column in domain "KOKRS"] == CSLA.KOKRS` `P_COACTLPLNTGTVARCRAUNION.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `P_COACTLPLNTGTVARCRAUNION.[column in domain "DATBI"] == CSLA.DATBI` `P_COACTLPLNTGTVARCRAUNION.MANDT == CSLA.MANDT`
Partner order number Partner order number Client	`P_COACTLPLNTGTVARCRAUNION.PARTNERORDER == AUFK.AUFNR` `P_COACTLPLNTGTVARCRAUNION.MANDT == AUFK.MANDT`
Unit of Measure for Valuation Quantity Unit of Measure for Valuation Quantity Client	`P_COACTLPLNTGTVARCRAUNION.UNITOFMEASURE == T006.MSEHI` `P_COACTLPLNTGTVARCRAUNION.MANDT == T006.MANDT`