P_MfgOrdActlPlnStdTgtUnion

Manufacturing Orders Actual/Plan/Standard/Target Costs Union | view: PFIACTLPLNSTDTGT | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCA, ACDOCP, T001, TKA02, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
OrderID FK Order ID
Ledger FK Ledger in General Ledger Accounting
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
ControllingValueType null
GlobalCurrency FK Global Currency
CompanyCodeCurrency FK Company Code Currency
UnitOfMeasure FK Cost Source Unit
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
  • Company Code
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.COMPANYCODE == T001.BUKRS
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.CONTROLLINGAREA == TKA01.KOKRS
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == TKA01.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.COMPANYCODE == SKB1.BUKRS
  • P_MFGORDACTLPLNSTDTGTUNION.GLACCOUNT == SKB1.SAKNR
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == TCURC.MANDT
  • P_MFGORDACTLPLNSTDTGTUNION.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Material Number
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.MATERIAL == MARA.MATNR
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == MARA.MANDT
Order ID
  • Order ID
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.ORDERID == AUFK.AUFNR
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == AUFK.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Partner Cost Center
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.CONTROLLINGAREA == CSKS.KOKRS
  • P_MFGORDACTLPLNSTDTGTUNION.[column in domain "DATBI"] == CSKS.DATBI
  • P_MFGORDACTLPLNSTDTGTUNION.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • Controlling Area
  • Partner Cost Center Activity Type
  • ?
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.CONTROLLINGAREA == CSLA.KOKRS
  • P_MFGORDACTLPLNSTDTGTUNION.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MFGORDACTLPLNSTDTGTUNION.[column in domain "DATBI"] == CSLA.DATBI
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == CSLA.MANDT
Plant
  • Client
  • Plant
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == T001W.MANDT
  • P_MFGORDACTLPLNSTDTGTUNION.PLANT == T001W.WERKS
Cost Source Unit
  • Cost Source Unit
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.UNITOFMEASURE == T006.MSEHI
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == T006.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • P_MFGORDACTLPLNSTDTGTUNION.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGORDACTLPLNSTDTGTUNION.WORKCENTERINTERNALID == CRID.OBJID
  • P_MFGORDACTLPLNSTDTGTUNION.MANDT == CRID.MANDT