What is P_COOrderPlanTargetCube in SAP S/4HANA?

P_COOrderPlanTargetCube is a composite CDS view in SAP S/4HANA. It contains 100 fields.

Which tables does P_COOrderPlanTargetCube read from?

P_COOrderPlanTargetCube reads data from: I_MfgOrdPlngCat, I_ProductCostCtrlgOrder, P_COMFGOrderPlanStdCube, I_TargetCostVariant, P_COMFGOrderTargetCube and more.

What VDM layer is P_COOrderPlanTargetCube?

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

P_COOrderPlanTargetCube

DDL: P_COORDERPLANTARGETCUBE SQL: PFIORDPLNTGTCUB Type: view COMPOSITE

100 Fields 6 Data Sources

P_COOrderPlanTargetCube is a Composite CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 100 fields with key fields ControllingObject, ControllingArea, FiscalYear, FiscalPeriod, FiscalYearPeriod.

Data Sources (6)

Source	Alias	Join Type
I_MfgOrdPlngCat	_MfgOrdPlngCat	inner
I_ProductCostCtrlgOrder	_order	union
P_COMFGOrderPlanStdCube	_PlanStdCube	from
I_TargetCostVariant	_TargetCostVariant	left_outer
P_COMFGOrderTargetCube	P_COMFGOrderTargetCube	union
P_COPlanTargetCube	P_COPlanTargetCube	inner

Parameters (4)

Name	Type	Default
P_FromFiscalYearPeriod	fis_jahrper
P_ToFiscalYearPeriod	fis_jahrper
P_PlanningCategory	fcom_category
P_ControllingObject	j_objnr

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PFIORDPLNTGTCUB	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 (100)

Key	Field	Source Table	Source Field	Description
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		ControllingValueType
KEY	GLAccount		GLAccount	G/L Account
KEY	ControllingKeySubNumber		ControllingKeySubNumber
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PlanningCategory	P_COMFGOrderPlanStdCube	PlanningCategory	Plan Category
KEY	OrderID		OrderID	Order ID
KEY	OrderItem		OrderItem
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	PartnerOrder		PartnerOrder	Partner Order
KEY	PartnerCostObject		PartnerCostObject	Partner Cost Object
KEY	OriginSenderObject		OriginSenderObject
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
KEY	CtrlgOriginClassification		CtrlgOriginClassification
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Material		Material	Vehicle Model
KEY	CostOriginGroup		CostOriginGroup	Origin Group
KEY	CostSourceUnit		CostSourceUnit	Unit Protected Qty
KEY	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInGlobalCurrency			Amount in Global Currency
	FixedAmountInGlobalCurrency
	AmountInCompanyCodeCurrency			Amount in Obj Crcy
	FixedAmountInCoCodeCurrency
	P_FromFiscalYearPeriod
	P_ToFiscalYearPeriod
	P_PlanningCategorykeyControllingObject
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	FiscalYearPeriod		FiscalYearPeriod	Period/Year
KEY	ControllingValueType		ControllingValueType
KEY	GLAccount		GLAccount	G/L Account
KEY	ControllingKeySubNumber		ControllingKeySubNumber
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PlanningCategory		PlanningCategory	Plan Category
KEY	OrderID		OrderID	Order ID
KEY	OrderItem		OrderItem
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	PartnerOrder		PartnerOrder	Partner Order
KEY	PartnerCostObject		PartnerCostObject	Partner Cost Object
KEY	OriginSenderObject		OriginSenderObject
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
KEY	CtrlgOriginClassification		CtrlgOriginClassification
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Material		Material	Vehicle Model
KEY	CostOriginGroup		CostOriginGroup	Origin Group
KEY	CostSourceUnit		CostSourceUnit	Unit Protected Qty
KEY	GlobalCurrency		GlobalCurrency	GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInGlobalCurrency		AmountInGlobalCurrency	Amount in Global Currency
	FixedAmountInGlobalCurrency		FixedAmountInGlobalCurrency
	AmountInCompanyCodeCurrency		AmountInCompanyCodeCurrency	Amount in Obj Crcy
	FixedAmountInCoCodeCurrency		FixedAmountInCoCodeCurrency
	ObjectInternalIDasControllingObject
KEY	ControllingArea	I_ProductCostCtrlgOrder	ControllingArea	Controlling Area
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	FiscalPeriod		FiscalPeriod	Tax period
KEY	FiscalYearPeriod		FiscalYearPeriod	Period/Year
KEY	ControllingValueType		ControllingValueType
KEY	GLAccount		CostElement	G/L Account
KEY	ControllingKeySubNumber		ControllingKeySubNumber
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
KEY	PlanningCategory	_plantarget	PlanningCategory	Plan Category
KEY	OrderID	I_ProductCostCtrlgOrder	OrderID	Order ID
KEY	OrderItem	_plantarget	OrderItem
KEY	BusinessTransactionType		BusinessTransactionType	Bus.transaction
KEY	AccountAssignmentType		AccountAssignmentType	Sndr AcctAssgmt Type
KEY	PartnerAccountAssignmentType		PartnerAccountAssignmentType	Partner Account Assignment Type
KEY	PartnerCostObject		PartnerCostObject	Partner Cost Object
KEY	OriginSenderObject		OriginSenderObject
KEY	CtrlgOriginClassification		CtrlgOriginClassification
KEY	WorkCenterInternalID			Work Center
KEY	OrderOperation			Operation or Phase
KEY	Material			Vehicle Model
KEY	CostOriginGroup			Origin Group
KEY	CostSourceUnit		UnitOfMeasure	Unit Protected Qty
KEY	GlobalCurrency			GM Billing Element: Global Currency
KEY	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	AmountInGlobalCurrency		AmountInCtrlgAreaCrcy	Amount in Global Currency
	FixedAmountInGlobalCurrency		FixedAmountInCtrlgAreaCrcy
	AmountInCompanyCodeCurrency		AmountInObjectCurrency	Amount in Obj Crcy
	FixedAmountInCoCodeCurrency		FixedAmountInObjectCurrency
	TotalQuantity		TotalQuantity	Activity Quantity

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_COOrderPlanTargetCube.
-- 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: PFIORDPLNTGTCUB
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_PlanningCategory : fcom_category, P_ControllingObject : j_objnr

CREATE VIEW P_COOrderPlanTargetCube AS
SELECT
  ControllingObject,
  ControllingArea,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ControllingValueType,
  GLAccount,
  ControllingKeySubNumber,
  ControllingDebitCreditCode,
  _PlanStdCube.PlanningCategory AS PlanningCategory,
  OrderID,
  OrderItem,
  BusinessTransactionType,
  AccountAssignmentType,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder,
  PartnerCostObject,
  OriginSenderObject,
  OriginCostCenter,
  OriginCostCtrActivityType,
  CtrlgOriginClassification,
  WorkCenterInternalID,
  OrderOperation,
  Material,
  CostOriginGroup,
  CostSourceUnit,
  GlobalCurrency,
  CompanyCodeCurrency,
  sum(AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(FixedAmountInGlobalCurrency) AS FixedAmountInGlobalCurrency,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(FixedAmountInCoCodeCurrency) AS FixedAmountInCoCodeCurrency,
  sum(TotalQuantity) as TotalQuantity AS P_FromFiscalYearPeriod,
  P_ToFiscalYearPeriod : $parameters.P_ToFiscalYearPeriod AS P_ToFiscalYearPeriod,
  TotalQuantity AS ObjectInternalIDasControllingObject,
  TotalQuantity
FROM P_COMFGOrderPlanStdCube AS _PlanStdCube
INNER JOIN I_MfgOrdPlngCat AS _MfgOrdPlngCat ON /* join condition not captured in parsed metadata */
INNER JOIN P_COPlanTargetCube ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TargetCostVariant AS _TargetCostVariant ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_COMFGOrderTargetCube, I_ProductCostCtrlgOrder
;

Depth:

P_COOrderPlanTargetCube view

P_COActlPlnTgtVarcRAUnion view
P_COOrderPlanTargetByObject view