C_ProductCostByOrderQuery

DDL: C_PRODUCTCOSTBYORDERQUERY SQL: CFIPRODCSTBOQRY Type: view CONSUMPTION
52 Fields 1 Data Sources

Production Cost By Order

C_ProductCostByOrderQuery is a Consumption CDS View that provides data about "Production Cost By Order" in SAP S/4HANA. It reads from 1 data source (I_ProductCostByOrderCube) and exposes 52 fields with key field OrderID.

Data Sources (1)

SourceAliasJoin Type
I_ProductCostByOrderCube I_ProductCostByOrderCube from

Parameters (7)

NameTypeDefault
P_FromFiscalYearPeriod fins_fyearperiod
P_ToFiscalYearPeriod fins_fyearperiod
P_PlanVersion fis_kkb_plvrs
P_TargetCostVariant fis_awvrs
P_ResultAnalysisVersion versn_abgr
P_Language sylangu
P_CurrencyRole fac_crcyrole

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFIPRODCSTBOQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Production Cost By Order view
VDM.viewType #CONSUMPTION view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
OData.publish true view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID Order ID
OrderType OrderType Order Type
OrderCategory OrderCategory Order Category
ReferenceOrder ReferenceOrder Reference Order
ExternalOrder ExternalOrder Ext. order no.
OrderDescription OrderDescription
OrderTypeName OrderTypeName
OrderCategoryName OrderCategoryName
Plant Plant Valuation Area
PlantName PlantName Plant Name
ProductionUnit ProductionUnit
ControllingArea ControllingArea Controlling Area
ControllingAreaName ControllingAreaName Long Text
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
CreationDate CreationDate Time Stamp
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalWeek FiscalWeek
Material Material Vehicle Model
MaterialName MaterialName Material Description
StorageLocation StorageLocation StorageLocation
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledReleaseDate ScheduledReleaseDate
ActualStartDate ActualStartDate Actual Start
ConfirmedEndDate ConfirmedEndDate
ActualReleasedDate ActualReleasedDate
DisplayCurrency DisplayCurrency Display Currency
ActlCostInDspCrcy ActlCostInDspCrcy
ActlVarblCostInDspCrcy ActlVarblCostInDspCrcy
ActlFixedCostInDspCrcy ActlFixedCostInDspCrcy
PlanCostInDspCrcy PlanCostInDspCrcy
PlanFixedCostInDspCrcy PlanFixedCostInDspCrcy
PlanVarblCostInDspCrcy PlanVarblCostInDspCrcy
InptPrVarcAmtInDspCrcy InptPrVarcAmtInDspCrcy
InptQtyVarcAmtInDspCrcy InptQtyVarcAmtInDspCrcy
RsceUsgeVarcAmtInDspCrcy RsceUsgeVarcAmtInDspCrcy
InptRmngVarcAmtInDspCrcy InptRmngVarcAmtInDspCrcy
MixedPrVarcAmtInDspCrcy MixedPrVarcAmtInDspCrcy
OutpPrVarcAmtInDspCrcy OutpPrVarcAmtInDspCrcy
LotSizeVarcAmtInDspCrcy LotSizeVarcAmtInDspCrcy
OutpQtyVarcAmtInDspCrcy OutpQtyVarcAmtInDspCrcy
OutpRmngVarcAmtInDspCrcy OutpRmngVarcAmtInDspCrcy
ScrapVarcAmtInDspCrcy ScrapVarcAmtInDspCrcy
CostVarianceInDspCrcy CostVarianceInDspCrcy
WIPAmtInDisplayCurrency WIPAmtInDisplayCurrency
RsrvAmountInDisplayCrcy RsrvAmountInDisplayCrcy
PlanOutputQuantity PlanOutputQuantity
ActualOutputQuantity ActualOutputQuantity
DebitActlPlnDiffCostInDspCrcy DebitActlPlnDiffCostInDspCrcy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProductCostByOrderQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFIPRODCSTBOQRY
-- Parameters: P_FromFiscalYearPeriod : fins_fyearperiod, P_ToFiscalYearPeriod : fins_fyearperiod, P_PlanVersion : fis_kkb_plvrs, P_TargetCostVariant : fis_awvrs, P_ResultAnalysisVersion : versn_abgr, P_Language : sylangu, P_CurrencyRole : fac_crcyrole

CREATE VIEW C_ProductCostByOrderQuery AS
SELECT
  OrderID,
  OrderType,
  OrderCategory,
  ReferenceOrder,
  ExternalOrder,
  OrderDescription,
  OrderTypeName,
  OrderCategoryName,
  Plant,
  PlantName,
  ProductionUnit,
  ControllingArea,
  ControllingAreaName,
  CompanyCode,
  CompanyCodeName,
  BusinessArea,
  ProfitCenter,
  CreationDate,
  FiscalYear,
  FiscalPeriod,
  FiscalWeek,
  Material,
  MaterialName,
  StorageLocation,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualReleasedDate,
  DisplayCurrency,
  ActlCostInDspCrcy,
  ActlVarblCostInDspCrcy,
  ActlFixedCostInDspCrcy,
  PlanCostInDspCrcy,
  PlanFixedCostInDspCrcy,
  PlanVarblCostInDspCrcy,
  InptPrVarcAmtInDspCrcy,
  InptQtyVarcAmtInDspCrcy,
  RsceUsgeVarcAmtInDspCrcy,
  InptRmngVarcAmtInDspCrcy,
  MixedPrVarcAmtInDspCrcy,
  OutpPrVarcAmtInDspCrcy,
  LotSizeVarcAmtInDspCrcy,
  OutpQtyVarcAmtInDspCrcy,
  OutpRmngVarcAmtInDspCrcy,
  ScrapVarcAmtInDspCrcy,
  CostVarianceInDspCrcy,
  WIPAmtInDisplayCurrency,
  RsrvAmountInDisplayCrcy,
  PlanOutputQuantity,
  ActualOutputQuantity,
  DebitActlPlnDiffCostInDspCrcy
FROM I_ProductCostByOrderCube
;

Learn More