I_WorkCenterProdCostCube

Production Cost By Work Center | view: IFIWCPRODCSTCUB | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Column Name Description
WorkCenterInternalID FK Object ID of the resource
OrderOperation Operation
OrderID FK Order
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
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
ActualQtyInCostSourceUnit Actual Quantity
PlanQtyInCostSourceUnit Plan Quantity
ActlPlanDiffQuantity Plan/Actual Quantity Variance
Column Name Description
Column Name Description
OrderCategory Order Category Show values
MfgOrderHasMultipleItems Joint Production Show values
Column Name Description Domain name
WorkCenter Work Center ARBPL
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
ControllingAreaName Controlling Area Name TEXT25
CompanyCodeName Company Code Name TEXT25
OrderDescription Order Description TEXT40
ControllingObjectStatus null
DebitActlPlanDiffPercent Plan Debit/Actual Debit Cost Variance(%) KKB_PROZABW
WorkCenterText Work Center Text TEXT40
GLAccountName G/L Account Short Text TEXT20
CostCenterName Cost Center Name TEXT20
CostCenterDescription Description of Cost Center TEXT40
CostCtrActivityTypeName General Name TEXT20
CostCtrActivityTypeDesc Long Text TEXT40
OperationDescription Operation Short Text TEXT40
OrderTypeName Name of an Order Type TEXT40
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_WORKCENTERPRODCOSTCUBE.MANDT == TGSB.MANDT
  • I_WORKCENTERPRODCOSTCUBE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_WORKCENTERPRODCOSTCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_WORKCENTERPRODCOSTCUBE.COMPANYCODE == T001.BUKRS
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_WORKCENTERPRODCOSTCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_WORKCENTERPRODCOSTCUBE.MANDT == TKA01.MANDT
General Ledger Account
  • General Ledger Account
  • Company Code
  • Client
  • I_WORKCENTERPRODCOSTCUBE.GLACCOUNT == SKB1.SAKNR
  • I_WORKCENTERPRODCOSTCUBE.COMPANYCODE == SKB1.BUKRS
  • I_WORKCENTERPRODCOSTCUBE.MANDT == SKB1.MANDT
Planning Plant for The Order
  • Client
  • Planning Plant for The Order
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T001W.MANDT
  • I_WORKCENTERPRODCOSTCUBE.MRPPLANT == T001W.WERKS
Order
  • Order
  • Client
  • I_WORKCENTERPRODCOSTCUBE.ORDERID == AUFK.AUFNR
  • I_WORKCENTERPRODCOSTCUBE.MANDT == AUFK.MANDT
Order Type
  • Order Type
  • Client
  • I_WORKCENTERPRODCOSTCUBE.ORDERTYPE == T003O.AUART
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T003O.CLIENT
Plant
  • Plant
  • Client
  • I_WORKCENTERPRODCOSTCUBE.PLANT == T001W.WERKS
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T001W.MANDT
Profit Center
  • ?
  • Client
  • Profit Center
  • Controlling Area
  • I_WORKCENTERPRODCOSTCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_WORKCENTERPRODCOSTCUBE.MANDT == CEPC.MANDT
  • I_WORKCENTERPRODCOSTCUBE.PROFITCENTER == CEPC.PRCTR
  • I_WORKCENTERPRODCOSTCUBE.CONTROLLINGAREA == CEPC.KOKRS
Reference Order Number
  • Client
  • Reference Order Number
  • I_WORKCENTERPRODCOSTCUBE.MANDT == AUFK.MANDT
  • I_WORKCENTERPRODCOSTCUBE.REFERENCEORDER == AUFK.AUFNR
Unit of Measure
  • Client
  • Unit of Measure
  • I_WORKCENTERPRODCOSTCUBE.MANDT == T006.MANDT
  • I_WORKCENTERPRODCOSTCUBE.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_WORKCENTERPRODCOSTCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_WORKCENTERPRODCOSTCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • I_WORKCENTERPRODCOSTCUBE.MANDT == CRID.MANDT