C_WorkCenterPlanActlTgtCost

Production Cost By Work Center/Operation. | view: CFIWCCOST | Extraction: Not supported | Component: Cost Object Controlling
Tables used: COSL, AFKO, AFVC, AFPO, ACDOCA, ACDOCP, T004, T001, TKA02, CSKS, CSLA, CSLT, CSKT, SKA1, SKB1, FINSC_LEDGER, MARA, MAKT, FCOMC_CATEGORY, AUFK, CRTX, CRHD, CRCO, SKAT, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
WorkCenterInternalID FK Object ID of the resource
WorkCenter Work Center
OrderOperation Operation
OrderID FK Order
Ledger FK Ledger in General Ledger Accounting
GLAccount FK General Ledger Account
Material Material Number
Plant FK Plant
PartnerCostCenter Partner Cost Center
PartnerCostCtrActivityType Activity Type
Column Name Description
💲 Display Currency (DisplayCurrency):
DebitPlanCostInDspCrcy Plan Cost Debit
DebitPlnFxdCostInDspCrcy Plan Fixed Cost Debit
DebitPlnVarblCostInDspCrcy Plan Variable Cost Debit
DebitActlCostInDspCrcy Actual Cost Debit
DebitActlFxdCostInDspCrcy Actual Fixed Cost Debit
DebitActlVarblCostInDspCrcy Actual Variable Cost Debit
DebitActlPlnDiffCostInDspCrcy Plan Cost Debit/Actual Cost Debit Variance
DebitStdCostInDspCrcy Order Standard Cost
DebitStdFxdCostInDspCrcy Order Fixed Standard Cost
DebitStdVarblCostInDspCrcy Order Variable Standard Cost
DebitTargetCostInDspCrcy Target Cost Debit
DebitActlTgtDiffCostInDspCrcy Target Cost Debit/Actual Cost Debit Variance
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
ActualQtyInCostSourceUnit Actual Quantity
PlanQtyInCostSourceUnit Plan Quantity
ActlPlanDiffQuantity Plan/Actual Quantity Variance
TargetQtyInCostSourceUnit Target Quantity
Column Name Description
ValidityDate null
Column Name Description
OrderCategory Order Category Show values
MfgOrderHasMultipleItems Joint Production Show values
OrderIsEventBasedPosting Event-Based Posting Show values
Column Name Description Domain name
OrderDescription Order Description TEXT40
WorkCenterText Work center description TEXT40
GLAccountName GL Account Description TEXT20
MaterialName Material Description EHFND_DESCRIPTION_XS
CostCenterDescription Description of Cost Center TEXT40
CostCtrActivityTypeDesc Activity Type Description TEXT40
OperationDescription Operation Description TEXT40
StockSegment Stock Segment
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.BUSINESSAREA == TGSB.GSBER
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.CHARTOFACCOUNTS == T004.KTOPL
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.COMPANYCODE == T001.BUKRS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.CONTROLLINGAREA == TKA01.KOKRS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == TKA01.MANDT
General Ledger Account
  • General Ledger Account
  • Company Code
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.GLACCOUNT == SKB1.SAKNR
  • C_WORKCENTERPLANACTLTGTCOST.COMPANYCODE == SKB1.BUKRS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Planning Plant for The Order
  • Planning Plant for The Order
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.MRPPLANT == T001W.WERKS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T001W.MANDT
Order
  • Order
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.ORDERID == AUFK.AUFNR
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.ORDERTYPE == T003O.AUART
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T003O.CLIENT
Plant
  • Plant
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.PLANT == T001W.WERKS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T001W.MANDT
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • C_WORKCENTERPLANACTLTGTCOST.[column in domain "DATBI"] == CEPC.DATBI
  • C_WORKCENTERPLANACTLTGTCOST.CONTROLLINGAREA == CEPC.KOKRS
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == CEPC.MANDT
  • C_WORKCENTERPLANACTLTGTCOST.PROFITCENTER == CEPC.PRCTR
Reference Order Number
  • Reference Order Number
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.REFERENCEORDER == AUFK.AUFNR
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == AUFK.MANDT
Unit of Measure
  • Unit of Measure
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.UNITOFMEASURE == T006.MSEHI
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == T006.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • C_WORKCENTERPLANACTLTGTCOST.WORKCENTERINTERNALID == CRID.OBJID
  • C_WORKCENTERPLANACTLTGTCOST.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • C_WORKCENTERPLANACTLTGTCOST.MANDT == CRID.MANDT