P_EventBasedPCCOrderAndItem

DDL: P_EVENTBASEDPCCORDERANDITEM SQL: PEBPCCORDAITM Type: view COMPOSITE
28 Fields 2 Data Sources

P_EventBasedPCCOrderAndItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProductCostCtrlgOrder, I_ProductCostCtrlgOrderItem) and exposes 28 fields with key fields OrderID, OrderItem, OrderItem.

Data Sources (2)

SourceAliasJoin Type
I_ProductCostCtrlgOrder I_ProductCostCtrlgOrder from
I_ProductCostCtrlgOrderItem I_ProductCostCtrlgOrderItem union

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PEBPCCORDAITM 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 (28)

KeyFieldSource TableSource FieldDescription
KEY OrderID OrderID Order ID
KEY OrderItem
OrderInternalID ObjectInternalID Object number
ObjectInternalID ObjectInternalID Object number
OrderDescription OrderDescription
CompanyCode CompanyCode Receiver Company Code
OrderType OrderType Order Type
OrderCategory OrderCategory Order Category
Plant Plant Valuation Area
ControllingArea ControllingArea Controlling Area
SalesOrder _RepresentativeOrderItem SalesOrder SD Document
SalesOrderItem _RepresentativeOrderItem SalesOrderItem Sales Order Item
Material _RepresentativeOrderItem Material Vehicle Model
WBSElementInternalID _RepresentativeOrderItem WBSElementInternalID WBS Internal ID
KEY OrderItem OrderItem
OrderInternalID _Order ObjectInternalID Object number
ObjectInternalID ObjectInternalID Object number
OrderDescription _Order OrderDescription
CompanyCode _Order CompanyCode Receiver Company Code
OrderType OrderType Order Type
OrderCategory OrderCategory Order Category
Plant _Order Plant Valuation Area
ControllingArea _Order ControllingArea Controlling Area
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
Material Material Vehicle Model
WBSElementInternalID WBSElementInternalID WBS Internal ID
MfgOrderHasMultipleItems _Order MfgOrderHasMultipleItems

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_EventBasedPCCOrderAndItem.
-- 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: PEBPCCORDAITM

CREATE VIEW P_EventBasedPCCOrderAndItem AS
SELECT
  OrderID,
  cast('0000' as pph_posnr) AS OrderItem,
  ObjectInternalID AS OrderInternalID,
  ObjectInternalID,
  OrderDescription,
  CompanyCode,
  OrderType,
  OrderCategory,
  Plant,
  ControllingArea,
  _RepresentativeOrderItem.SalesOrder AS SalesOrder,
  _RepresentativeOrderItem.SalesOrderItem AS SalesOrderItem,
  _RepresentativeOrderItem.Material AS Material,
  _RepresentativeOrderItem.WBSElementInternalID AS WBSElementInternalID,
  _Order.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems
FROM I_ProductCostCtrlgOrder
-- UNION with additional select branch(es): I_ProductCostCtrlgOrderItem
;

Learn More