What is P_EBOC_TargetCost in SAP S/4HANA?

P_EBOC_TargetCost is a composite CDS view in SAP S/4HANA. It contains 92 fields.

Which tables does P_EBOC_TargetCost read from?

P_EBOC_TargetCost reads data from: P_EventBasedPCCOrderHdrAndItm, P_AMDP_DET_MAT_COST_EST_ORDER, P_EBOC_ActualCost3, P_EBOC_MaterialCostEstimate, P_EBOC_MaterialCostEstimate and more.

What VDM layer is P_EBOC_TargetCost?

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

P_EBOC_TargetCost

DDL: P_EBOC_TARGETCOST SQL: PEBOCOTGTCST Type: view COMPOSITE

92 Fields 10 Data Sources

P_EBOC_TargetCost is a Composite CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 92 fields with key fields OrderID, OrderItem, CompanyCode, PlanningCategory, CostElement.

Data Sources (10)

Source	Alias	Join Type
P_EventBasedPCCOrderHdrAndItm	_OrderHeaderAndItem	union_all
P_AMDP_DET_MAT_COST_EST_ORDER	P_AMDP_DET_MAT_COST_EST_ORDER	from
P_EBOC_ActualCost3	P_EBOC_ActualCost3	inner
P_EBOC_MaterialCostEstimate	P_EBOC_MaterialCostEstimate	inner
P_EBOC_MaterialCostEstimate	P_EBOC_MaterialCostEstimate	inner
P_EBOC_PlanCostEstimate	P_EBOC_PlanCostEstimate	inner
P_EBOrderActualOutputQty	P_EBOrderActualOutputQty	inner
P_EBOrderHdrAndItemValStrategy	P_EBOrderHdrAndItemValStrategy	union_all
P_EBOrderHdrAndItemValStrategy	P_EBOrderHdrAndItemValStrategy	union_all
P_RTOCD_OrderTargetQty	P_RTOCD_OrderTargetQty	inner

Parameters (5)

Name	Type	Default
P_OrderID	fis_order_number
P_Ledger	fins_ledger
P_FromFiscalYearPeriod	fis_jahrper
P_ToFiscalYearPeriod	fis_jahrper
P_CurrencyRole	fac_crcyrole

Annotations (7)

Name	Value	Level
AbapCatalog.sqlViewName	PEBOCOTGTCST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (92)

Key	Field	Source Table	Source Field	Description
KEY	OrderID	_amdp_mce	OrderID	Order ID
KEY	OrderItem	_amdp_mce	OrderItem
KEY	CompanyCode	_CostEstimate	CompanyCode	Receiver Company Code
KEY	PlanningCategory		PlanningCategory	Plan Category
KEY	CostElement		CostElement	G/L Account
KEY	BusinessTransactionCategory		BusinessTransactionCategory	Business Transaction Category
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
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	UnitOfMeasure		CostSourceUnit	Unit Protected Qty
KEY	Material	_CostEstimate	Material	Vehicle Model
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Plant	_CostEstimate	Plant	Valuation Area
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	IsLotSizeIndependent		IsLotSizeIndependent
KEY	CostOriginGroup	_CostEstimate	CostOriginGroup	Origin Group
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
	OrderID			Order ID
KEY	OrderItem	_TargetCostStrategy	OrderItem
KEY	CompanyCode	_CostEstimate	CompanyCode	Receiver Company Code
KEY	PlanningCategory		PlanningCategory	Plan Category
KEY	CostElement		CostElement	G/L Account
KEY	BusinessTransactionCategory		BusinessTransactionCategory	Business Transaction Category
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
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	UnitOfMeasure		CostSourceUnit	Unit Protected Qty
KEY	Material	_CostEstimate	Material	Vehicle Model
KEY	WorkCenterInternalID		WorkCenterInternalID	Work Center
KEY	OrderOperation		OrderOperation	Operation or Phase
KEY	Plant	_CostEstimate	Plant	Valuation Area
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	IsLotSizeIndependent		IsLotSizeIndependent
KEY	CostOriginGroup	_CostEstimate	CostOriginGroup	Origin Group
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
	OrderID			Order ID
KEY	OrderItem	_TargetCostStrategy	OrderItem
KEY	CompanyCode	_PlanCost	CompanyCode	Receiver Company Code
KEY	PlanningCategory		PlanningCategory	Plan Category
KEY	CostElement		CostElement	G/L Account
KEY	BusinessTransactionCategory		BusinessTransactionCategory	Business Transaction Category
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
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	UnitOfMeasure		CostSourceUnit	Unit Protected Qty
KEY	Material	_PlanCost	Material	Vehicle Model
KEY	WorkCenterInternalID			Work Center
KEY	OrderOperation			Operation or Phase
KEY	Plant	_PlanCost	Plant	Valuation Area
KEY	ControllingArea		ControllingArea	Controlling Area
KEY	IsLotSizeIndependent		IsLotSizeIndependent
KEY	CostOriginGroup	_PlanCost	CostOriginGroup	Origin Group
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
	OrderID			Order ID
KEY	OrderItem	P_EventBasedPCCOrderHdrAndItm	OrderItem
KEY	CompanyCode	P_EventBasedPCCOrderHdrAndItm	CompanyCode	Receiver Company Code
KEY	PlanningCategory			Plan Category
KEY	CostElement		CostElement	G/L Account
KEY	BusinessTransactionCategory		BusinessTransactionCategory	Business Transaction Category
KEY	ControllingDebitCreditCode		ControllingDebitCreditCode	Dr/Cr ind. CO
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	UnitOfMeasure		UnitOfMeasure	Unit Protected Qty
KEY	Material	_ActualCost	Material	Vehicle Model
KEY	WorkCenterInternalID			Work Center
KEY	OrderOperation			Operation or Phase
KEY	Plant	_ActualCost	Plant	Valuation Area
KEY	ControllingArea	P_EventBasedPCCOrderHdrAndItm	ControllingArea	Controlling Area
KEY	IsLotSizeIndependent
KEY	CostOriginGroup	_ActualCost	CostOriginGroup	Origin Group
KEY	OriginCostCenter		OriginCostCenter
KEY	OriginCostCtrActivityType		OriginCostCtrActivityType
KEY	CtrlgOriginClassification
	AmountInDisplayCurrency		AmountInDisplayCurrency
	FixedAmountInDisplayCurrency		FixedAmountInDisplayCurrency
	TotalQuantity		Quantity	Value

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_EBOC_TargetCost.
-- 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: PEBOCOTGTCST
-- Parameters: P_OrderID : fis_order_number, P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBOC_TargetCost AS
SELECT
  _amdp_mce.OrderID AS OrderID,
  _amdp_mce.OrderItem AS OrderItem,
  _CostEstimate.CompanyCode AS CompanyCode,
  PlanningCategory,
  CostElement,
  BusinessTransactionCategory,
  ControllingDebitCreditCode,
  AccountAssignmentType,
  PartnerAccountAssignmentType,
  PartnerCostCenter,
  PartnerCostCtrActivityType,
  PartnerOrder,
  CostSourceUnit AS UnitOfMeasure,
  _CostEstimate.Material AS Material,
  WorkCenterInternalID,
  OrderOperation,
  _CostEstimate.Plant AS Plant,
  ControllingArea,
  IsLotSizeIndependent,
  _CostEstimate.CostOriginGroup AS CostOriginGroup,
  OriginCostCenter,
  OriginCostCtrActivityType,
  'A' AS CtrlgOriginClassification,
  AmountInDisplayCurrency,
  FixedAmountInDisplayCurrency,
  Quantity AS TotalQuantity
FROM P_AMDP_DET_MAT_COST_EST_ORDER
INNER JOIN P_EBOC_MaterialCostEstimate ON /* join condition not captured in parsed metadata */
INNER JOIN P_EBOrderActualOutputQty ON /* join condition not captured in parsed metadata */
INNER JOIN P_RTOCD_OrderTargetQty ON /* join condition not captured in parsed metadata */
INNER JOIN P_EBOC_PlanCostEstimate ON /* join condition not captured in parsed metadata */
INNER JOIN P_EBOC_ActualCost3 ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_EBOrderHdrAndItemValStrategy, P_EventBasedPCCOrderHdrAndItm
;

Depth:

P_EBOC_TargetCost view

P_EBOC_COGM_CostUnion view
P_EBOC_CostUnion view