I_DeliveryDocumentPartner

DDL: I_DELIVERYDOCUMENTPARTNER Type: view_entity COMPOSITE
11 Fields 1 Data Sources 3 Associations

Delivery Document Partner

I_DeliveryDocumentPartner is a Composite CDS View that provides data about "Delivery Document Partner" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentPartner) and exposes 11 fields with key fields DeliveryDocument, PartnerFunction. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentPartner DeliveryDocumentPartner from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_DeliveryDocument _DeliveryDocument _DeliveryDocument.DeliveryDocument = DeliveryDocumentPartner.SDDocument
[0..1] I_Supplier _AuthSupplier $projection.Supplier = _AuthSupplier.Supplier
[0..1] I_Customer _AuthCustomer $projection.Customer = _AuthCustomer.Customer

Annotations (8)

NameValueLevelField
EndUserText.label Delivery Document Partner view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument SDDocument SD Document
KEY PartnerFunction Partner Functn
Customer Customer Sold-to Party
Supplier Supplier Supplier
Personnel Personnel Personnel No.
ContactPerson ContactPerson Contact Person Key
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
ShippingPoint _DeliveryDocument ShippingPoint Shipping Point
_AuthSupplier _AuthSupplier
_AuthCustomer _AuthCustomer

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 I_DeliveryDocumentPartner.
-- 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 I_DeliveryDocumentPartner AS
SELECT
  SDDocument AS DeliveryDocument,
  cast(PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  AddressID,
  AddressPersonID,
  _DeliveryDocument.ShippingPoint AS ShippingPoint
FROM I_SDDocumentPartner AS DeliveryDocumentPartner
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON _DeliveryDocument.DeliveryDocument = DeliveryDocumentPartner.SDDocument  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _AuthSupplier ON Supplier = _AuthSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _AuthCustomer ON Customer = _AuthCustomer.Customer  -- association [0..1]
;

Learn More