C_ProductCostByOrderQuery

Production Cost By Order | view: CFIPRODCSTBOQRY | Extraction: Not supported | Component: Cost Object Controlling
Column Name Description
OrderID Order Number
Column Name Description
💲 Currency (DisplayCurrency):
ActlCostInDspCrcy Total Actual Cost
ActlVarblCostInDspCrcy Actual Variable Cost
ActlFixedCostInDspCrcy Actual Fixed Cost
PlanCostInDspCrcy Total Plan Cost
PlanFixedCostInDspCrcy Plan Fixed Cost
PlanVarblCostInDspCrcy Plan Variable Cost
InptPrVarcAmtInDspCrcy Input Price Variance
InptQtyVarcAmtInDspCrcy Input Quantity Variance
RsceUsgeVarcAmtInDspCrcy Resource Usage Variance
InptRmngVarcAmtInDspCrcy Remaining Input Variance
MixedPrVarcAmtInDspCrcy Mixed-Price Variance
OutpPrVarcAmtInDspCrcy Output Price Variance
LotSizeVarcAmtInDspCrcy Lot Size Variance
OutpQtyVarcAmtInDspCrcy Output Quantity Variance
OutpRmngVarcAmtInDspCrcy Remaining Variance
ScrapVarcAmtInDspCrcy Scrap Variance
CostVarianceInDspCrcy Cost Variance
WIPAmtInDisplayCurrency Work In Process
RsrvAmountInDisplayCrcy Reserves for Unrealized Costs
DebitActlPlnDiffCostInDspCrcy Plan Cost Debit/Actual Cost Debit Variance
Column Name Description
📏 Output Unit of Measure (ProductionUnit):
PlanOutputQuantity Plan Output Quantity
ActualOutputQuantity Actual Output Quantity
Column Name Description
CreationDate Created On
ScheduledBasicEndDate Scheduled Finish Date
ScheduledReleaseDate Scheduled Release Date
ActualStartDate Actual Start Date
ConfirmedEndDate Actual Finish Date
ActualReleasedDate Actual Release Date
Column Name Description
OrderCategory Order Category Show values
Column Name Description Domain name
ExternalOrder External Order Number AUFEX
OrderDescription Order Description TEXT40
OrderTypeName Name of an Order Type TEXT40
OrderCategoryName Order Category Name DDTEXT
PlantName Plant Name TEXT30
ControllingAreaName Controlling Area Name TEXT25
CompanyCodeName Company Code Name TEXT25
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
FiscalWeek Fiscal Week FINS_FISCALWEEK
MaterialName Material Description TEXT40
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == TGSB.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • C_PRODUCTCOSTBYORDERQUERY.COMPANYCODE == T001.BUKRS
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == TKA01.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.CONTROLLINGAREA == TKA01.KOKRS
Material
  • Client
  • Material
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == MARA.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.MATERIAL == MARA.MATNR
Order Type
  • Client
  • Order Type
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == T003O.CLIENT
  • C_PRODUCTCOSTBYORDERQUERY.ORDERTYPE == T003O.AUART
Plant
  • Client
  • Plant
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == T001W.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.PLANT == T001W.WERKS
Activity unit
  • Client
  • Output Unit of Measure
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == T006.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.PRODUCTIONUNIT == T006.MSEHI
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == CEPC.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.PROFITCENTER == CEPC.PRCTR
  • C_PRODUCTCOSTBYORDERQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_PRODUCTCOSTBYORDERQUERY.CONTROLLINGAREA == CEPC.KOKRS
Reference Order Number
  • Client
  • Reference Order Number
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == AUFK.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.REFERENCEORDER == AUFK.AUFNR
Storage Location
  • Client
  • Storage Location
  • ?
  • C_PRODUCTCOSTBYORDERQUERY.MANDT == T001L.MANDT
  • C_PRODUCTCOSTBYORDERQUERY.STORAGELOCATION == T001L.LGORT
  • C_PRODUCTCOSTBYORDERQUERY.[column in domain "WERKS_D"] == T001L.WERKS