P_MfgOrderActlPlanTgtCost

Private view for actual/plan/target cost | view: PMFGAPTCST | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFPO, ACDOCA, ACDOCD, ACDOCP, T001, TKA02, TKA01, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, T000, CRHD, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Ledger FK Ledger
OrderID Order Number
OrderOperation Operation
WorkCenterInternalID FK Object ID of the resource
WorkCenter Work Center
GLAccount FK General Ledger Account
PartnerCostCenter FK Partner Cost Center
PartnerCostCtrActivityType FK Partner Cost Center Activity Type
Product FK Material Number
Plant FK Plant
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 Actual Quantity
PlanQtyInCostSourceUnit Plan Quantity
Column Name Description
Column Name Description
OrderCategory Order Category Show values
Column Name Description Domain name
MfgOrderInternalID Order Internal ID AUFPL
SalesOrder Sales Order Number VBELN
SalesOrderItem Item number in Sales Order NUM06
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T004.MANDT
  • P_MFGORDERACTLPLANTGTCOST.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_MFGORDERACTLPLANTGTCOST.COMPANYCODE == T001.BUKRS
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_MFGORDERACTLPLANTGTCOST.MANDT == TKA01.MANDT
  • P_MFGORDERACTLPLANTGTCOST.CONTROLLINGAREA == TKA01.KOKRS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T009.MANDT
  • P_MFGORDERACTLPLANTGTCOST.FISCALYEARVARIANT == T009.PERIV
General Ledger Account
  • Client
  • General Ledger Account
  • ?
  • P_MFGORDERACTLPLANTGTCOST.MANDT == SKB1.MANDT
  • P_MFGORDERACTLPLANTGTCOST.GLACCOUNT == SKB1.SAKNR
  • P_MFGORDERACTLPLANTGTCOST.[column in domain "BUKRS"] == SKB1.BUKRS
Ledger
  • Client
  • Ledger
Order Type
  • Order Type
  • Client
  • P_MFGORDERACTLPLANTGTCOST.ORDERTYPE == T003O.AUART
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T003O.CLIENT
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • P_MFGORDERACTLPLANTGTCOST.MANDT == CSKS.MANDT
  • P_MFGORDERACTLPLANTGTCOST.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_MFGORDERACTLPLANTGTCOST.[column in domain "DATBI"] == CSKS.DATBI
  • P_MFGORDERACTLPLANTGTCOST.CONTROLLINGAREA == CSKS.KOKRS
Partner Cost Center Activity Type
  • Partner Cost Center Activity Type
  • Client
  • ?
  • Controlling Area
  • P_MFGORDERACTLPLANTGTCOST.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MFGORDERACTLPLANTGTCOST.MANDT == CSLA.MANDT
  • P_MFGORDERACTLPLANTGTCOST.[column in domain "DATBI"] == CSLA.DATBI
  • P_MFGORDERACTLPLANTGTCOST.CONTROLLINGAREA == CSLA.KOKRS
Plant
  • Client
  • Plant
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T001W.MANDT
  • P_MFGORDERACTLPLANTGTCOST.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • Material Number
  • P_MFGORDERACTLPLANTGTCOST.MANDT == MARA.MANDT
  • P_MFGORDERACTLPLANTGTCOST.PRODUCEDPRODUCT == MARA.MATNR
  • P_MFGORDERACTLPLANTGTCOST.PRODUCT == MARA.MATNR
Material Number
  • Client
  • Product Number
  • Material Number
  • P_MFGORDERACTLPLANTGTCOST.MANDT == MARA.MANDT
  • P_MFGORDERACTLPLANTGTCOST.PRODUCEDPRODUCT == MARA.MATNR
  • P_MFGORDERACTLPLANTGTCOST.PRODUCT == MARA.MATNR
Cost Source Unit
  • Client
  • Cost Source Unit
  • P_MFGORDERACTLPLANTGTCOST.MANDT == T006.MANDT
  • P_MFGORDERACTLPLANTGTCOST.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • Client
  • ?
  • Object ID of the resource
  • P_MFGORDERACTLPLANTGTCOST.MANDT == CRID.MANDT
  • P_MFGORDERACTLPLANTGTCOST.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_MFGORDERACTLPLANTGTCOST.WORKCENTERINTERNALID == CRID.OBJID