P_ReturnsReferenceDocument

DDL: P_RETURNSREFERENCEDOCUMENT Type: view_entity COMPOSITE
11 Fields 3 Data Sources

P_ReturnsReferenceDocument is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_BillingDocumentItemBasic, I_DeliveryDocument, I_DeliveryDocumentItem) and exposes 11 fields with key fields SDDocument, SalesDocumentItem, DeliveryDocument, DeliveryDocumentItem, SalesDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_BillingDocumentItemBasic BillingDocumentItem union_all
I_DeliveryDocument DeliveryDocument inner
I_DeliveryDocumentItem DeliveryDocumentItem from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SDDocument I_DeliveryDocumentItem ReferenceSDDocument Reference Doc.
KEY SalesDocumentItem I_DeliveryDocumentItem ReferenceSDDocumentItem Item
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument Reference Doc.
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem Reference Item
SDDocumentCategory I_DeliveryDocumentItem ReferenceSDDocumentCategory Document Cat.
BillingDocumentasSDDocument
KEY SalesDocumentItem I_BillingDocumentItemBasic BillingDocumentItem Item
KEY DeliveryDocument I_BillingDocumentItemBasic ReferenceSDDocument Reference Doc.
KEY DeliveryDocumentItem I_BillingDocumentItemBasic ReferenceSDDocumentItem Reference Item
SDDocumentCategory I_BillingDocumentItemBasic SDDocumentCategory Document Cat.
ShippingPoint I_BillingDocumentItemBasic ShippingPoint Shipping Point

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_ReturnsReferenceDocument.
-- 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.

CREATE VIEW P_ReturnsReferenceDocument AS
SELECT
  DeliveryDocumentItem.ReferenceSDDocument AS SDDocument,
  DeliveryDocumentItem.ReferenceSDDocumentItem AS SalesDocumentItem,
  DeliveryDocumentItem.DeliveryDocument AS DeliveryDocument,
  DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  DeliveryDocumentItem.ReferenceSDDocumentCategory AS SDDocumentCategory,
  DeliveryDocument.ShippingPoint as ShippingPoint AS BillingDocumentasSDDocument,
  BillingDocumentItem.ShippingPoint AS ShippingPoint
FROM I_DeliveryDocumentItem AS DeliveryDocumentItem
INNER JOIN I_DeliveryDocument AS DeliveryDocument ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_BillingDocumentItemBasic
;

Learn More