I_WorkCenterProductCost

Interface View for Product Cost by Work Center | view: IFIPRODCOSTBYWC | Extraction: Not supported | Component: Cost Object Controlling

Tables used: COSL, AFKO, AFPO, ACDOCA, ACDOCP, T001, TKA02, FINSC_LEDGER, FCOMC_CATEGORY, AUFK, CRHD, CRCO, FINS_MIG_PERIODS, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (9)
💰 Amounts (36)
∑ Quantities (4)
📅 Dates (1)
☰ Categorical (3)
Other (3)
🔗 Relations (17)

Column Name	Description
OrderID FK	Order
OrderOperation	Operation
Ledger FK	Ledger in General Ledger Accounting
WorkCenterInternalID FK	Object ID of the resource
GLAccount FK	General Ledger Account
Material	Material Number
PartnerCostCenter	Partner Cost Center
PartnerCostCtrActivityType	Activity Type
UnitOfMeasure FK	Unit of Measure

Column Name	Description
💲 Global Currency (GlobalCurrency):
DebitPlanCostInCtrlgAreaCrcy	Plan Cost Debit
DebitPlnFxdCostInCtrlgAreaCrcy	Plan Fixed Cost Debit
DebitPlnVarblCostInCOCrcy	Plan Variable Cost Debit
DebitStdCostInGlobalCrcy	order standard cost debit in global currency
DebitStdFxdCostInGlobalCrcy	Order Fixed Standard Cost Debit In Global Currency
DebitStdVarblCostInGlobalCrcy	Order Variable Standard Cost Debit In Global Currency
DebitActlCostInCtrlgAreaCrcy	Actual Cost Debit
DebitActlFxdCostInCOCrcy	Actual Fixed Cost Debit
DebitActlVarblCostInCOCrcy	Actual Variable Cost
DebitTargetCostInCtrlgAreaCrcy	Target Cost Debit
DebitActlPlnDiffCostInCOCrcy	Plan Cost Debit/Actual Cost Debit Variance
DebitActlTgtDiffCostInCOCrcy	Target Cost Debit/Actual Cost Debit Variance
💲 Company Code Currency (CompanyCodeCurrency):
DebitPlanCostInCoCodeCrcy	Debit Plan Cost In Company Code Currency
DebitPlanFixedCostInCoCodeCrcy	Debit Plan Fixed Cost In Company Code Currency
DebitPlanVarblCostInCoCodeCrcy	Debit Plan Variable Cost In Company Code Currency
DebitStdCostInCoCodeCrcy	Order Standard Cost Debit In Company Code Currency
DebitStdFxdCostInCoCodeCrcy	Order Fixed Standard Cost Debit In Company Code Currency
DebitStdVarblCostInCoCodeCrcy	Order Variable Standard Cost Debit In Company Code Currency
DebitActlCostInCoCodeCrcy	Debit Actual Cost In Company Code Currency
DebitActlFixedCostInCoCodeCrcy	Debit Actual Fixed Cost In Company Code Currency
DebitActlVarblCostInCoCodeCrcy	Debit Actual Variable Cost In Company Code Currency
DebitTargetCostInCoCodeCrcy	Debit Target Cost In Company Code Currency
DebitActlPlnDiffCostInCCCrcy	Debit Actual Plan Difference Cost In Company Code Currency
DebitActlTgtDiffCostInCCCrcy	Debit Actual Target Difference Cost In Company Code Currency
💲 Display Currency (DisplayCurrency):
DebitPlanCostInDspCrcy	Plan Cost Debit
DebitPlnFxdCostInDspCrcy	Plan Fixed Cost Debit
DebitPlnVarblCostInDspCrcy	Plan Variable Cost Debit
DebitStdCostInDspCrcy	Order Standard Cost
DebitStdFxdCostInDspCrcy	Order Fixed Standard Cost
DebitStdVarblCostInDspCrcy	Order Variable Standard Cost
DebitActlCostInDspCrcy	Actual Cost Debit
DebitActlFxdCostInDspCrcy	Actual Fixed Cost Debit
DebitActlVarblCostInDspCrcy	Actual Variable Cost Debit
DebitTargetCostInDspCrcy	Target Cost Debit
DebitActlPlnDiffCostInDspCrcy	Plan Cost Debit/Actual Cost Debit Variance
DebitActlTgtDiffCostInDspCrcy	Target Cost Debit/Actual Cost Debit Variance

Column Name	Description
📏 Unit of Measure (UnitOfMeasure):
ActualQtyInCostSourceUnit	Actual Quantity
PlanQtyInCostSourceUnit	Plan Quantity
TargetQtyInCostSourceUnit	Target Quantity
ActlPlanDiffQuantity	Plan/Actual Quantity Variance

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
WorkCenter	Work Center	ARBPL
OrderDescription	Order Description	TEXT40
StockSegment	Stock Segment	SGT_SRCA

Master Data Relations	Join Conditions
Business Area Business Area Client	`I_WORKCENTERPRODUCTCOST.BUSINESSAREA == TGSB.GSBER` `I_WORKCENTERPRODUCTCOST.MANDT == TGSB.MANDT`
Company Code Company Code Client	`I_WORKCENTERPRODUCTCOST.COMPANYCODE == T001.BUKRS` `I_WORKCENTERPRODUCTCOST.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`I_WORKCENTERPRODUCTCOST.COMPANYCODECURRENCY == TCURC.WAERS` `I_WORKCENTERPRODUCTCOST.MANDT == TCURC.MANDT`
Controlling Area Controlling Area Client	`I_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == TKA01.KOKRS` `I_WORKCENTERPRODUCTCOST.MANDT == TKA01.MANDT`
General Ledger Account Company Code General Ledger Account Client	`I_WORKCENTERPRODUCTCOST.COMPANYCODE == SKB1.BUKRS` `I_WORKCENTERPRODUCTCOST.GLACCOUNT == SKB1.SAKNR` `I_WORKCENTERPRODUCTCOST.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`I_WORKCENTERPRODUCTCOST.GLOBALCURRENCY == TCURC.WAERS` `I_WORKCENTERPRODUCTCOST.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`I_WORKCENTERPRODUCTCOST.MANDT == FINSC_LEDGER.MANDT` `I_WORKCENTERPRODUCTCOST.LEDGER == FINSC_LEDGER.RLDNR`
Planning Plant for an Order Client Planning Plant for an Order	`I_WORKCENTERPRODUCTCOST.MANDT == T001W.MANDT` `I_WORKCENTERPRODUCTCOST.MRPPLANT == T001W.WERKS`
Order Order Client	`I_WORKCENTERPRODUCTCOST.ORDERID == AUFK.AUFNR` `I_WORKCENTERPRODUCTCOST.MANDT == AUFK.MANDT`
Order Type Client Order Type	`I_WORKCENTERPRODUCTCOST.MANDT == T003O.CLIENT` `I_WORKCENTERPRODUCTCOST.ORDERTYPE == T003O.AUART`
Plant Client Plant	`I_WORKCENTERPRODUCTCOST.MANDT == T001W.MANDT` `I_WORKCENTERPRODUCTCOST.PLANT == T001W.WERKS`
Profit Center ? Controlling Area Client Profit Center	`I_WORKCENTERPRODUCTCOST.[column in domain "DATBI"] == CEPC.DATBI` `I_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == CEPC.KOKRS` `I_WORKCENTERPRODUCTCOST.MANDT == CEPC.MANDT` `I_WORKCENTERPRODUCTCOST.PROFITCENTER == CEPC.PRCTR`
Reference Order Number Client Reference Order Number	`I_WORKCENTERPRODUCTCOST.MANDT == AUFK.MANDT` `I_WORKCENTERPRODUCTCOST.REFERENCEORDER == AUFK.AUFNR`
Responsible Cost Center ? Responsible Cost Center Controlling Area Client	`I_WORKCENTERPRODUCTCOST.[column in domain "DATBI"] == CSKS.DATBI` `I_WORKCENTERPRODUCTCOST.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `I_WORKCENTERPRODUCTCOST.CONTROLLINGAREA == CSKS.KOKRS` `I_WORKCENTERPRODUCTCOST.MANDT == CSKS.MANDT`
Unit of Measure Unit of Measure Client	`I_WORKCENTERPRODUCTCOST.UNITOFMEASURE == T006.MSEHI` `I_WORKCENTERPRODUCTCOST.MANDT == T006.MANDT`
Object ID of the resource ? Object ID of the resource Client	`I_WORKCENTERPRODUCTCOST.[column in domain "CR_OBJTY"] == CRID.OBJTY` `I_WORKCENTERPRODUCTCOST.WORKCENTERINTERNALID == CRID.OBJID` `I_WORKCENTERPRODUCTCOST.MANDT == CRID.MANDT`