P_MstrProjChklstReferenceDoc

DDL: P_MSTRPROJCHKLSTREFERENCEDOC SQL: PMPCHKLSTREFDOC Type: view COMPOSITE
9 Fields 5 Data Sources

P_MstrProjChklstReferenceDoc is a Composite CDS View in SAP S/4HANA. It reads from 5 data sources (I_OdOp, I_Project, I_WBSElement, I_OrderHeader, I_OrdMstrData) and exposes 9 fields with key field ControllingObject.

Data Sources (5)

SourceAliasJoin Type
I_OdOp _OdOp union
I_Project _Project union
I_WBSElement _WBSElement from
I_OrderHeader OrderHeader left_outer
I_OrdMstrData OrdMstrData union

Annotations (5)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject I_WBSElement WBSElementObject Object number
ObjectName I_WBSElement WBSDescription Short Text
ControllingObjectasControllingObject
ObjectName I_OrdMstrData OrderDescription Short Text
ProjectObjectasControllingObject
ObjectName I_Project ProjectDescription Short Text
NetworkActivityObjectasControllingObject
ObjectName I_OdOp NetworkActivityDescription Short Text
ControllingObjectExternalID

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_MstrProjChklstReferenceDoc.
-- 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: PMPCHKLSTREFDOC

CREATE VIEW P_MstrProjChklstReferenceDoc AS
SELECT
  _WBSElement.WBSElementObject AS ControllingObject,
  _WBSElement.WBSDescription AS ObjectName,
  _WBSElement.WBSElement as ControllingObjectExternalID AS ControllingObjectasControllingObject,
  OrdMstrData.OrderID as ControllingObjectExternalID AS ProjectObjectasControllingObject,
  _Project.Project as ControllingObjectExternalID AS NetworkActivityObjectasControllingObject,
  concat(OrderHeader.OrderID, concat('-', _OdOp.NetworkActivity)) AS ControllingObjectExternalID
FROM I_WBSElement AS _WBSElement
LEFT OUTER JOIN I_OrderHeader AS OrderHeader ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_OrdMstrData, I_Project, I_OdOp
;

Learn More