P_COMfgOrdActlPlnUnion

Manufacturing Orders Actual Plan Costs Union for Work Center | view: PFIMFGACTLPLNUN | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: ACDOCA, ACDOCP, T001, TKA02, FINSC_LEDGER, FCOMC_CATEGORY, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
OrderID FK Order ID
PlanningCategory Plan Category
OrderOperation Operation/Activity Number
WorkCenterInternalID FK Object ID of the resource
GLAccount FK G/L Account
Material FK Material Number
PartnerCostCenter FK Partner Cost Center
PartnerCostCtrActivityType FK Partner Cost Center Activity Type
PartnerOrder FK Partner Order
ControllingValueType null
GlobalCurrency FK Global Currency
CompanyCodeCurrency FK Company Code Currency
UnitOfMeasure FK Cost Source Unit
Ledger FK Ledger in General Ledger Accounting
DisplayCurrency Display Currency
Column Name Description
AmountInGlobalCurrency null
FixedAmountInGlobalCurrency null
AmountInCompanyCodeCurrency null
FixedAmountInCoCodeCrcy null
AmountInDisplayCurrency null
Column Name Description
TotalQuantity null
Column Name Description
Column Name Description
Column Name Description Domain name
PlngCatIsForOrdReltdPlnCost null
PlngCatIsForMatlCostEstPlnCost null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_COMFGORDACTLPLNUNION.MANDT == T001.MANDT
  • P_COMFGORDACTLPLNUNION.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_COMFGORDACTLPLNUNION.MANDT == TCURC.MANDT
  • P_COMFGORDACTLPLNUNION.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_COMFGORDACTLPLNUNION.CONTROLLINGAREA == TKA01.KOKRS
  • P_COMFGORDACTLPLNUNION.MANDT == TKA01.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_COMFGORDACTLPLNUNION.MANDT == SKB1.MANDT
  • P_COMFGORDACTLPLNUNION.COMPANYCODE == SKB1.BUKRS
  • P_COMFGORDACTLPLNUNION.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_COMFGORDACTLPLNUNION.MANDT == TCURC.MANDT
  • P_COMFGORDACTLPLNUNION.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Client
  • Material Number
  • P_COMFGORDACTLPLNUNION.MANDT == MARA.MANDT
  • P_COMFGORDACTLPLNUNION.MATERIAL == MARA.MATNR
Order ID
  • Client
  • Order ID
  • P_COMFGORDACTLPLNUNION.MANDT == AUFK.MANDT
  • P_COMFGORDACTLPLNUNION.ORDERID == AUFK.AUFNR
Partner Cost Center
  • Controlling Area
  • Client
  • Partner Cost Center
  • ?
  • P_COMFGORDACTLPLNUNION.CONTROLLINGAREA == CSKS.KOKRS
  • P_COMFGORDACTLPLNUNION.MANDT == CSKS.MANDT
  • P_COMFGORDACTLPLNUNION.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_COMFGORDACTLPLNUNION.[column in domain "DATBI"] == CSKS.DATBI
Partner Cost Center Activity Type
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • ?
  • P_COMFGORDACTLPLNUNION.CONTROLLINGAREA == CSLA.KOKRS
  • P_COMFGORDACTLPLNUNION.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_COMFGORDACTLPLNUNION.MANDT == CSLA.MANDT
  • P_COMFGORDACTLPLNUNION.[column in domain "DATBI"] == CSLA.DATBI
Partner Order
  • Client
  • Partner Order
  • P_COMFGORDACTLPLNUNION.MANDT == AUFK.MANDT
  • P_COMFGORDACTLPLNUNION.PARTNERORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • P_COMFGORDACTLPLNUNION.MANDT == T001W.MANDT
  • P_COMFGORDACTLPLNUNION.PLANT == T001W.WERKS
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_COMFGORDACTLPLNUNION.MANDT == T006.MANDT
  • P_COMFGORDACTLPLNUNION.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • P_COMFGORDACTLPLNUNION.WORKCENTERINTERNALID == CRID.OBJID
  • P_COMFGORDACTLPLNUNION.MANDT == CRID.MANDT
  • P_COMFGORDACTLPLNUNION.[column in domain "CR_OBJTY"] == CRID.OBJTY