P_MfgOrdActlPlnTgtUnion

Private view for actual/plan/target union | view: PFIORDACTLPLNUN | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCA, ACDOCD, ACDOCP, T001, TKA02, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger
CompanyCode FK Company Code
Plant FK Plant
ControllingObject FK Controlling Object
OrderID FK Order ID
OrderOperation Operation/Activity Number
WorkCenterInternalID FK Object ID of the resource
Product FK Material Number
GLAccount FK G/L Account
ControllingArea FK Controlling Area
ControllingValueType Value Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
AccountAssignmentType FK Object Type
PartnerCostCenter FK Partner Cost Center
PartnerCostCtrActivityType FK Partner Cost Center Activity Type
UnitOfMeasure FK Cost Source Unit
Column Name Description
💲 Display Currency (DisplayCurrency):
AmountInDisplayCurrency null
Column Name Description
📏 Cost Source Unit (UnitOfMeasure):
TotalQuantity null
Column Name Description
Column Name Description
ControllingValueType Value Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
Column Name Description Domain name
CostRateFixedAmount null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_MFGORDACTLPLNTGTUNION.MANDT == T001.MANDT
  • P_MFGORDACTLPLNTGTUNION.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_MFGORDACTLPLNTGTUNION.CONTROLLINGAREA == TKA01.KOKRS
  • P_MFGORDACTLPLNTGTUNION.MANDT == TKA01.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_MFGORDACTLPLNTGTUNION.GLACCOUNT == SKB1.SAKNR
  • P_MFGORDACTLPLNTGTUNION.MANDT == SKB1.MANDT
  • P_MFGORDACTLPLNTGTUNION.COMPANYCODE == SKB1.BUKRS
Ledger
  • Client
  • Ledger
Order ID
  • Client
  • Order ID
  • P_MFGORDACTLPLNTGTUNION.MANDT == AUFK.MANDT
  • P_MFGORDACTLPLNTGTUNION.ORDERID == AUFK.AUFNR
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • P_MFGORDACTLPLNTGTUNION.CONTROLLINGAREA == CSKS.KOKRS
  • P_MFGORDACTLPLNTGTUNION.MANDT == CSKS.MANDT
  • P_MFGORDACTLPLNTGTUNION.[column in domain "DATBI"] == CSKS.DATBI
  • P_MFGORDACTLPLNTGTUNION.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Cost Center Activity Type
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • ?
  • P_MFGORDACTLPLNTGTUNION.CONTROLLINGAREA == CSLA.KOKRS
  • P_MFGORDACTLPLNTGTUNION.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MFGORDACTLPLNTGTUNION.MANDT == CSLA.MANDT
  • P_MFGORDACTLPLNTGTUNION.[column in domain "DATBI"] == CSLA.DATBI
Plant
  • Plant
  • Client
  • P_MFGORDACTLPLNTGTUNION.PLANT == T001W.WERKS
  • P_MFGORDACTLPLNTGTUNION.MANDT == T001W.MANDT
Material Number
  • Material Number
  • Client
  • P_MFGORDACTLPLNTGTUNION.PRODUCT == MARA.MATNR
  • P_MFGORDACTLPLNTGTUNION.MANDT == MARA.MANDT
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MFGORDACTLPLNTGTUNION.MANDT == T006.MANDT
  • P_MFGORDACTLPLNTGTUNION.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_MFGORDACTLPLNTGTUNION.MANDT == CRID.MANDT
  • P_MFGORDACTLPLNTGTUNION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGORDACTLPLNTGTUNION.WORKCENTERINTERNALID == CRID.OBJID