What is P_COMFGOrderTargetCube in SAP S/4HANA?

P_COMFGOrderTargetCube is a composite CDS view in SAP S/4HANA. Target Costs Cube for Manufacturing Orders It contains 89 fields.

Which tables does P_COMFGOrderTargetCube read from?

P_COMFGOrderTargetCube reads data from: P_PCCCostEstimateItem, I_Ledger, I_MfgOrdPlngCat, P_COMFGOrderPlanStdCube, P_PCCOrderSpclStockValStrategy and more.

What VDM layer is P_COMFGOrderTargetCube?

P_COMFGOrderTargetCube is classified as a Composite view that combines data from multiple basic views.

P_COMFGOrderTargetCube

DDL: P_COMFGORDERTARGETCUBE SQL: PFIMFGORDTGTCUBE Type: view COMPOSITE Package: ODATA_PRODUCTION_COST_ANALYSIS

89 Fields 8 Data Sources

Target Costs Cube for Manufacturing Orders

P_COMFGOrderTargetCube is a Composite CDS View that provides data about "Target Costs Cube for Manufacturing Orders" in SAP S/4HANA. It reads from 8 data sources and exposes 89 fields with key fields OrderID, OrderItem, ControllingObject, ControllingArea, FiscalYear. Part of development package ODATA_PRODUCTION_COST_ANALYSIS.

Data Sources (8)

Source	Alias	Join Type
P_PCCCostEstimateItem	_CostEstimate	inner
I_Ledger	_ledger	inner
I_MfgOrdPlngCat	_MfgOrdPlngCat	inner
P_COMFGOrderPlanStdCube	_PlanCost	inner
P_PCCOrderSpclStockValStrategy	_TargetCostStrategy	from
P_PCCOrderSpclStockValStrategy	_TargetCostStrategy	union_all
P_COMFGOrderOutputQuantities	P_COMFGOrderOutputQuantities	inner
P_PCCOrderActualOutputQuantity	P_PCCOrderActualOutputQuantity	inner

Parameters (3)

Name	Type	Default
P_FromFiscalYearPeriod	fis_jahrper
P_ToFiscalYearPeriod	fis_jahrper
P_PlanningCategory	fcom_category

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PFIMFGORDTGTCUBE	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.private	true	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (89)

Key	Field	Source Table	Source Field	Description
KEY	OrderID	P_PCCOrderSpclStockValStrategy	OrderID	Order ID
KEY	OrderItem	P_PCCOrderSpclStockValStrategy	OrderItem
KEY	ControllingObject		ControllingObject	Object number
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	FiscalYearPeriod		FiscalYearPeriod	Period/Year
KEY	ControllingValueType
KEY	GLAccount		GLAccount	General Ledger
KEY	ControllingKeySubNumber
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PlanningCategory		PlanningCategory	Plan Category
KEY	BusinessTransactionType		BusinessTransactionType	Bus.transaction
KEY	AccountAssignmentType			Sndr AcctAssgmt Type
KEY	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
KEY	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
KEY	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Partner Cost Center Activity Type
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
KEY	PartnerOrder
KEY	PartnerCostObject
KEY	OriginSenderObject
KEY	CtrlgOriginClassification
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Material	P_PCCCostEstimateItem	Material	Vehicle Model
KEY	ProducedProduct	P_PCCCostEstimateItem	ProducedProduct
KEY	CostOriginGroup		CostOriginGroup	Origin Group
KEY	Plant	P_PCCOrderSpclStockValStrategy	Plant	Valuation Area
KEY	OrderCategory	P_PCCOrderSpclStockValStrategy	OrderCategory	Order Category
KEY	OrderType	P_PCCOrderSpclStockValStrategy	OrderType	Order Type
KEY	CostSourceUnit		CostSourceUnit
KEY	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
KEY	CompanyCode	P_PCCCostEstimateItem	CompanyCode	Receiver Company Code
KEY	Ledger	I_Ledger	Ledger	Ledger
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	OrderID			Order ID
KEY	OrderItem	P_PCCOrderSpclStockValStrategy	OrderItem
KEY	ControllingObject	_ActualQuantity	ControllingObject	Object number
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	FiscalYearPeriod		FiscalYearPeriod	Period/Year
KEY	ControllingValueType
KEY	GLAccount		GLAccount	General Ledger
KEY	ControllingKeySubNumber
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PlanningCategory	P_COMFGOrderPlanStdCube	PlanningCategory	Plan Category
KEY	BusinessTransactionType		BusinessTransactionType	Bus.transaction
KEY	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
KEY	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
KEY	PartnerCostCenter		PartnerCostCenter	Sender Cost Ctr
KEY	PartnerCostCtrActivityType		PartnerCostCtrActivityType	Partner Cost Center Activity Type
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
KEY	PartnerOrder
KEY	PartnerCostObject
KEY	OriginSenderObject
KEY	CtrlgOriginClassification
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Material	P_COMFGOrderPlanStdCube	Material	Vehicle Model
KEY	ProducedProduct	P_COMFGOrderPlanStdCube	ProducedProduct
KEY	CostOriginGroup		CostOriginGroup	Origin Group
KEY	Plant	P_PCCOrderSpclStockValStrategy	Plant	Valuation Area
KEY	OrderCategory	P_PCCOrderSpclStockValStrategy	OrderCategory	Order Category
KEY	OrderType	P_PCCOrderSpclStockValStrategy	OrderType	Order Type
KEY	CostSourceUnit		CostSourceUnit
KEY	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
KEY	CompanyCode	P_COMFGOrderPlanStdCube	CompanyCode	Receiver Company Code
KEY	Ledger	P_COMFGOrderPlanStdCube	Ledger	Ledger
	FreeDefinedCurrency1		FreeDefinedCurrency1	Freely Defined Currency 1
	FreeDefinedCurrency2		FreeDefinedCurrency2	Freely Defined Currency 2
	FreeDefinedCurrency3		FreeDefinedCurrency3	Freely Defined Currency 3
	FreeDefinedCurrency4		FreeDefinedCurrency4	Freely Defined Currency 4
	FreeDefinedCurrency5		FreeDefinedCurrency5	Freely Defined Currency 5
	FreeDefinedCurrency6		FreeDefinedCurrency6	Freely Defined Currency 6
	FreeDefinedCurrency7		FreeDefinedCurrency7	Freely Defined Currency 7
	FreeDefinedCurrency8		FreeDefinedCurrency8	Freely Defined Currency 8
	quan233else0endendasTotalQuantity

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 P_COMFGOrderTargetCube.
-- 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: PFIMFGORDTGTCUBE
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_PlanningCategory : fcom_category

CREATE VIEW P_COMFGOrderTargetCube AS
SELECT
  _TargetCostStrategy.OrderID AS OrderID,
  _TargetCostStrategy.OrderItem AS OrderItem,
  ControllingObject,
  ControllingArea,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  '05' AS ControllingValueType,
  GLAccount,
  cast('' as co_subkey) AS ControllingKeySubNumber,
  ControllingDebitCreditCode,
  PlanningCategory,
  BusinessTransactionType,
  cast ( substring(ControllingObject, 1,2 ) as j_obart ) AS AccountAssignmentType,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  OriginCostCenter,
  OriginCostCtrActivityType,
  '' AS PartnerOrder,
  '' AS PartnerCostObject,
  '' AS OriginSenderObject,
  (case when BusinessTransactionType = 'KPPP' then 'P' else 'S' end) AS CtrlgOriginClassification,
  WorkCenterInternalID,
  OrderOperation,
  _CostEstimate.Material AS Material,
  _CostEstimate.ProducedProduct AS ProducedProduct,
  CostOriginGroup,
  _TargetCostStrategy.Plant AS Plant,
  _TargetCostStrategy.OrderCategory AS OrderCategory,
  _TargetCostStrategy.OrderType AS OrderType,
  CostSourceUnit,
  GlobalCurrency,
  CompanyCodeCurrency,
  _CostEstimate.CompanyCode AS CompanyCode,
  _ledger.Ledger AS Ledger,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  sum( case when IsLotSizeIndependent = 'X' then TotalQuantity else case when PlanOutputQuantity <> 0 then cast( round(cast(division(ActualOutputQuantity, PlanOutputQuantity, 6) as abap.dec(14, 6)) * TotalQuantity, 3) as abap.quan(23, 3) ) else 0 end end ) as TotalQuantity AS quan233else0endendasTotalQuantity
FROM P_PCCOrderSpclStockValStrategy AS _TargetCostStrategy
INNER JOIN P_PCCOrderActualOutputQuantity ON /* join condition not captured in parsed metadata */
INNER JOIN P_PCCCostEstimateItem AS _CostEstimate ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS _ledger ON /* join condition not captured in parsed metadata */
INNER JOIN P_COMFGOrderOutputQuantities ON /* join condition not captured in parsed metadata */
INNER JOIN P_COMFGOrderPlanStdCube AS _PlanCost ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrdPlngCat AS _MfgOrdPlngCat ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_PCCOrderSpclStockValStrategy
;

Depth:

P_COMFGOrderTargetCube view