What is C_ProductCostByOrderQuery in SAP S/4HANA?

C_ProductCostByOrderQuery is a consumption CDS view in SAP S/4HANA. Production Cost By Order It contains 52 fields.

Which tables does C_ProductCostByOrderQuery read from?

C_ProductCostByOrderQuery reads data from: I_ProductCostByOrderCube.

What VDM layer is C_ProductCostByOrderQuery?

C_ProductCostByOrderQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ProductCostByOrderQuery

DDL: C_PRODUCTCOSTBYORDERQUERY SQL: CFIPRODCSTBOQRY Type: view CONSUMPTION Package: FINS_FIS_PCC

52 Fields 1 Data Sources

Production Cost By Order

C_ProductCostByOrderQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

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. Part of development package FINS_FIS_PCC.

SAP API Hub

Category	Consumption
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-PC-OBJ-ORD-2CL
Capabilities	Analytical Query
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description	<p>The production costs in this CDS view include actual costs, plan costs, actual-plan costs difference, actual output quantity, plan output quantity, variance, and WIP. This CDS view also provides order master data information, such as order number, order category, and order description. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>How many costs are scheduled for the order (plan costs), and how many costs are invested in the order (actual costs)? What is the difference between plan costs and actual costs?</p></li> <li><p>How many outputs are scheduled before production process (plan output quantity), and how many outputs are produced in Goods Receipt (actual output quantity)?</p></li> <li><p>What is the order master data information (order number, order category, and order description, for example)? </p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ProductCostByOrderCube	I_ProductCostByOrderCube	from

Parameters (7)

Name	Type	Default
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)

Name	Value	Level
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)

Key	Field	Source Field	Description
KEY	OrderID	OrderID	Order Number
	OrderType	OrderType	Order Type
	OrderCategory	OrderCategory	Order Category
	ReferenceOrder	ReferenceOrder	Reference Order Number
	ExternalOrder	ExternalOrder	External Order Number
	OrderDescription	OrderDescription	Order Description
	OrderTypeName	OrderTypeName	Name of an Order Type
	OrderCategoryName	OrderCategoryName	Order Category Name
	Plant	Plant	Valuation Area
	PlantName	PlantName	Plant Name
	ProductionUnit	ProductionUnit	Output Unit of Measure
	ControllingArea	ControllingArea	Controlling Area
	ControllingAreaName	ControllingAreaName	Controlling Area Name
	CompanyCode	CompanyCode	Receiver Company Code
	CompanyCodeName	CompanyCodeName	Company Code Name
	BusinessArea	BusinessArea	Business Area
	ProfitCenter	ProfitCenter	Profit Center
	CreationDate	CreationDate	Time Stamp
	FiscalYear	FiscalYear	G/L Fiscal Year
	FiscalPeriod	FiscalPeriod	Fiscal Period
	FiscalWeek	FiscalWeek	Fiscal Week
	Material	Material	Vehicle Model
	MaterialName	MaterialName	Material Description
	StorageLocation	StorageLocation	Storage Location
	ScheduledBasicEndDate	ScheduledBasicEndDate	Scheduled Finish Date
	ScheduledReleaseDate	ScheduledReleaseDate	Scheduled Release Date
	ActualStartDate	ActualStartDate	Actual Start Date
	ConfirmedEndDate	ConfirmedEndDate	Manufacturing Order Confirmed End Date
	ActualReleasedDate	ActualReleasedDate	Actual Release Date
	DisplayCurrency	DisplayCurrency	Display Currency
	ActlCostInDspCrcy	ActlCostInDspCrcy	Total Actual Cost
	ActlVarblCostInDspCrcy	ActlVarblCostInDspCrcy	Actual Variable Cost
	ActlFixedCostInDspCrcy	ActlFixedCostInDspCrcy	Actual Fixed Cost
	PlanCostInDspCrcy	PlanCostInDspCrcy	Total Plan Cost
	PlanFixedCostInDspCrcy	PlanFixedCostInDspCrcy	Plan Fixed Cost
	PlanVarblCostInDspCrcy	PlanVarblCostInDspCrcy	Plan Variable Cost
	InptPrVarcAmtInDspCrcy	InptPrVarcAmtInDspCrcy	Input Price Variance in Display Currency
	InptQtyVarcAmtInDspCrcy	InptQtyVarcAmtInDspCrcy	Input Quantity Variance
	RsceUsgeVarcAmtInDspCrcy	RsceUsgeVarcAmtInDspCrcy	Resource Usage Variance
	InptRmngVarcAmtInDspCrcy	InptRmngVarcAmtInDspCrcy	Remaining Input Variance
	MixedPrVarcAmtInDspCrcy	MixedPrVarcAmtInDspCrcy	Mixed-Price Variance
	OutpPrVarcAmtInDspCrcy	OutpPrVarcAmtInDspCrcy	Output Price Variance
	LotSizeVarcAmtInDspCrcy	LotSizeVarcAmtInDspCrcy	Lot Size Variance
	OutpQtyVarcAmtInDspCrcy	OutpQtyVarcAmtInDspCrcy	Output Quantity Variance
	OutpRmngVarcAmtInDspCrcy	OutpRmngVarcAmtInDspCrcy	Remaining Variance
	ScrapVarcAmtInDspCrcy	ScrapVarcAmtInDspCrcy	Scrap Variance
	CostVarianceInDspCrcy	CostVarianceInDspCrcy	Cost Variance
	WIPAmtInDisplayCurrency	WIPAmtInDisplayCurrency	Work In Process
	RsrvAmountInDisplayCrcy	RsrvAmountInDisplayCrcy	Reserves for Unrealized Costs
	PlanOutputQuantity	PlanOutputQuantity	Plan Output Quantity
	ActualOutputQuantity	ActualOutputQuantity	Actual Output Quantity
	DebitActlPlnDiffCostInDspCrcy	DebitActlPlnDiffCostInDspCrcy	Plan Cost Debit/Actual Cost Debit Variance

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
;

Depth:

C_ProductCostByOrderQuery view

I_ProductCostByOrderCube view