P_MfgOrderActlPlanTgtCostDet

Private view for actual/plan/target cost details | view: PMFGAPTCOSTDET | 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
PartnerCostCenter FK Partner Cost Center
PartnerCostCtrActivityType FK Partner Cost Center Activity Type
UnitOfMeasure FK Cost Source Unit
Column Name Description
💲 Display Currency (DisplayCurrency):
CreditActlCostInDisplayCrcy Actual Cost Credit
DebitActlCostInDisplayCrcy Actual Cost Debit
CrdtActlFixedCostInDspCrcy Actual Fixed Cost Credit
DebitActlFixedCostInDspCrcy Actual Fixed Cost Debit
CreditPlanCostInDisplayCrcy Plan Cost Credit
DebitPlanCostInDisplayCrcy Plan Cost Debit
CrdtPlanFixedCostInDspCrcy Plan Fixed Cost Credit
DebitPlanFixedCostInDspCrcy Plan Fixed Cost Debit
CreditTgtCostInDisplayCrcy Target Cost Credit
DebitTgtCostInDisplayCrcy Target Cost Debit
Column Name Description
📏 Cost Source Unit (UnitOfMeasure):
ActualQtyInCostSourceUnit null
PlanQtyInCostSourceUnit null
Column Name Description
Column Name Description
ControllingValueType Value Type Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == T001.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_MFGORDERACTLPLANTGTCOSTDET.CONTROLLINGAREA == TKA01.KOKRS
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == TKA01.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == SKB1.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.COMPANYCODE == SKB1.BUKRS
  • P_MFGORDERACTLPLANTGTCOSTDET.GLACCOUNT == SKB1.SAKNR
Ledger
  • Client
  • Ledger
Order ID
  • Client
  • Order ID
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == AUFK.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.ORDERID == AUFK.AUFNR
Partner Cost Center
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center
  • P_MFGORDERACTLPLANTGTCOSTDET.CONTROLLINGAREA == CSKS.KOKRS
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == CSKS.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.[column in domain "DATBI"] == CSKS.DATBI
  • P_MFGORDERACTLPLANTGTCOSTDET.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • Partner Cost Center Activity Type
  • P_MFGORDERACTLPLANTGTCOSTDET.CONTROLLINGAREA == CSLA.KOKRS
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == CSLA.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.[column in domain "DATBI"] == CSLA.DATBI
  • P_MFGORDERACTLPLANTGTCOSTDET.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Plant
  • Client
  • Plant
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == T001W.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == MARA.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.PRODUCT == MARA.MATNR
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == T006.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_MFGORDERACTLPLANTGTCOSTDET.MANDT == CRID.MANDT
  • P_MFGORDERACTLPLANTGTCOSTDET.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGORDERACTLPLANTGTCOSTDET.WORKCENTERINTERNALID == CRID.OBJID