P_EBOrderTargetCost

DDL: P_EBORDERTARGETCOST SQL: PEBORDTGTCOST Type: view COMPOSITE Package: ODATA_CO_RT_PRODUCTION_COSTS

Event-Based Order Target Cost

P_EBOrderTargetCost is a Composite CDS View that provides data about "Event-Based Order Target Cost" in SAP S/4HANA. It reads from 5 data sources (P_EBPC_MfgPlanOutputQuantity, P_EBOrderActualOutputQty, P_EBOrderActualOutputQty, P_EBOrderHdrAndItemValStrategy, P_EBOrderHdrAndItemValStrategy) and exposes 12 fields with key fields OrderID, OrderItem, ObjectInternalID, OrderItem, ObjectInternalID. Part of development package ODATA_CO_RT_PRODUCTION_COSTS.

Data Sources (5)

SourceAliasJoin Type
P_EBPC_MfgPlanOutputQuantity _PlanOutpQty inner
P_EBOrderActualOutputQty P_EBOrderActualOutputQty inner
P_EBOrderActualOutputQty P_EBOrderActualOutputQty inner
P_EBOrderHdrAndItemValStrategy P_EBOrderHdrAndItemValStrategy from
P_EBOrderHdrAndItemValStrategy P_EBOrderHdrAndItemValStrategy union_all

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_CurrencyRole fac_crcyrole

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PEBORDTGTCOST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OrderID _TargetCostStrategy OrderID Order ID
KEY OrderItem _TargetCostStrategy OrderItem
KEY ObjectInternalID ObjectInternalID Object number
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ValuationStrategy ValuationStrategy
CompanyCode _TargetCostStrategy CompanyCode Receiver Company Code
OrderID Order ID
KEY OrderItem _TargetCostStrategy OrderItem
KEY ObjectInternalID ObjectInternalID Object number
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ValuationStrategy ValuationStrategy
CompanyCode _TargetCostStrategy CompanyCode Receiver Company Code

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_EBOrderTargetCost.
-- 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: PEBORDTGTCOST
-- Parameters: P_Ledger : fins_ledger, P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_CurrencyRole : fac_crcyrole

CREATE VIEW P_EBOrderTargetCost AS
SELECT
  _TargetCostStrategy.OrderID AS OrderID,
  _TargetCostStrategy.OrderItem AS OrderItem,
  ObjectInternalID,
  IsMarkedForDeletion,
  ValuationStrategy,
  _TargetCostStrategy.CompanyCode AS CompanyCode
FROM P_EBOrderHdrAndItemValStrategy
INNER JOIN P_EBOrderActualOutputQty ON /* join condition not captured in parsed metadata */
INNER JOIN P_EBPC_MfgPlanOutputQuantity AS _PlanOutpQty ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_EBOrderHdrAndItemValStrategy
;