P_MfgOrderActlPlanTgtCostCube

Private view actual/pln/target cost cube | view: PMFGPATCUBE | 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_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger
OrderID FK Order ID
OrderOperation Operation
WorkCenterInternalID FK Object ID of the resource
GLAccount FK General Ledger Account
PartnerCostCenter FK Partner Cost Center
PartnerCostCtrActivityType FK Partner Cost Center Activity Type
Plant FK Plant
Product FK Material Number
UnitOfMeasure FK Cost Source Unit
Column Name Description
💲 Display Currency (DisplayCurrency):
CreditActlCostInDisplayCrcy null
DebitActlCostInDisplayCrcy null
CrdtActlFixedCostInDspCrcy null
DebitActlFixedCostInDspCrcy null
CreditPlanCostInDisplayCrcy null
DebitPlanCostInDisplayCrcy null
CrdtPlanFixedCostInDspCrcy null
DebitPlanFixedCostInDspCrcy null
CreditTgtCostInDisplayCrcy null
DebitTgtCostInDisplayCrcy null
Column Name Description
📏 Cost Source Unit (UnitOfMeasure):
ActualQtyInCostSourceUnit null
PlanQtyInCostSourceUnit null
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == T001.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == TKA01.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.CONTROLLINGAREA == TKA01.KOKRS
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • P_MFGORDERACTLPLANTGTCOSTCUBE.GLACCOUNT == SKB1.SAKNR
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == SKB1.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.COMPANYCODE == SKB1.BUKRS
Ledger
  • Ledger
  • Client
Order ID
  • Client
  • Order ID
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == AUFK.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.ORDERID == AUFK.AUFNR
Partner Cost Center
  • Client
  • Partner Cost Center
  • Controlling Area
  • ?
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == CSKS.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_MFGORDERACTLPLANTGTCOSTCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • P_MFGORDERACTLPLANTGTCOSTCUBE.[column in domain "DATBI"] == CSKS.DATBI
Partner Cost Center Activity Type
  • Client
  • Controlling Area
  • Partner Cost Center Activity Type
  • ?
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == CSLA.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • P_MFGORDERACTLPLANTGTCOSTCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MFGORDERACTLPLANTGTCOSTCUBE.[column in domain "DATBI"] == CSLA.DATBI
Plant
  • Client
  • Plant
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == T001W.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == MARA.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.PRODUCT == MARA.MATNR
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == T006.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • P_MFGORDERACTLPLANTGTCOSTCUBE.MANDT == CRID.MANDT
  • P_MFGORDERACTLPLANTGTCOSTCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • P_MFGORDERACTLPLANTGTCOSTCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY