P_WorkCenterProductCost

Private View for Product Cost By Work Center | view: PFIPRODCOSTBYWC | 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
Ledger FK Ledger in General Ledger Accounting
OrderID FK Order
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
GlobalCurrency FK Global Currency
CompanyCodeCurrency FK Company Code Currency
UnitOfMeasure FK Cost Source Unit
DisplayCurrency Display Currency
Column Name Description
DebitPlanCostInCtrlgAreaCrcy null
DebitPlnFxdCostInCtrlgAreaCrcy null
DebitPlanCostInCoCodeCurrency null
DebitPlnFxdCostInCoCodeCrcy null
DebitPlanCostInDspCrcy null
DebitPlnFxdCostInDspCrcy null
DebitStdCostInGlobalCrcy null
DebitStdFxdCostInGlobalCrcy null
DebitStdCostInCoCodeCrcy null
DebitStdFxdCostInCoCodeCrcy null
DebitStdCostInDspCrcy null
DebitStdFxdCostInDspCrcy null
DebitActlCostInCtrlgAreaCrcy null
DebitActlFxdCostInCOCrcy null
DebitActualCostInCoCodeCrcy null
DebitActlFxdCostInCoCodeCrcy null
DebitActlCostInDspCrcy null
DebitActlFxdCostInDspCrcy null
DebitTargetCostInGlobalCrcy null
DebitTargetCostInCoCodeCrcy null
DebitTargetCostInDspCrcy null
Column Name Description
PlanTotalQuantity null
ActualTotalQuantity null
TargetQuantity null
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_WORKCENTERPRODUCTCOST.COMPANYCODE == T001.BUKRS
  • P_WORKCENTERPRODUCTCOST.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_WORKCENTERPRODUCTCOST.COMPANYCODECURRENCY == TCURC.WAERS
  • P_WORKCENTERPRODUCTCOST.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == TKA01.KOKRS
  • P_WORKCENTERPRODUCTCOST.MANDT == TKA01.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_WORKCENTERPRODUCTCOST.COMPANYCODE == SKB1.BUKRS
  • P_WORKCENTERPRODUCTCOST.GLACCOUNT == SKB1.SAKNR
  • P_WORKCENTERPRODUCTCOST.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_WORKCENTERPRODUCTCOST.GLOBALCURRENCY == TCURC.WAERS
  • P_WORKCENTERPRODUCTCOST.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Material Number
  • Client
  • P_WORKCENTERPRODUCTCOST.MATERIAL == MARA.MATNR
  • P_WORKCENTERPRODUCTCOST.MANDT == MARA.MANDT
Order
  • Order
  • Client
  • P_WORKCENTERPRODUCTCOST.ORDERID == AUFK.AUFNR
  • P_WORKCENTERPRODUCTCOST.MANDT == AUFK.MANDT
Partner Cost Center
  • ?
  • Partner Cost Center
  • Controlling Area
  • Client
  • P_WORKCENTERPRODUCTCOST.[column in domain "DATBI"] == CSKS.DATBI
  • P_WORKCENTERPRODUCTCOST.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == CSKS.KOKRS
  • P_WORKCENTERPRODUCTCOST.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • P_WORKCENTERPRODUCTCOST.[column in domain "DATBI"] == CSLA.DATBI
  • P_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == CSLA.KOKRS
  • P_WORKCENTERPRODUCTCOST.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_WORKCENTERPRODUCTCOST.MANDT == CSLA.MANDT
Plant
  • Plant
  • Client
  • P_WORKCENTERPRODUCTCOST.PLANT == T001W.WERKS
  • P_WORKCENTERPRODUCTCOST.MANDT == T001W.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • P_WORKCENTERPRODUCTCOST.UNITOFMEASURE == T006.MSEHI
  • P_WORKCENTERPRODUCTCOST.MANDT == T006.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • P_WORKCENTERPRODUCTCOST.WORKCENTERINTERNALID == CRID.OBJID
  • P_WORKCENTERPRODUCTCOST.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_WORKCENTERPRODUCTCOST.MANDT == CRID.MANDT