I_DeliveryPartnerAddress

DDL: I_DELIVERYPARTNERADDRESS Type: view COMPOSITE
52 Fields 1 Data Sources 1 Associations

Delivery Partner Address

I_DeliveryPartnerAddress is a Composite CDS View that provides data about "Delivery Partner Address" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentCompletePartners) and exposes 52 fields with key fields DeliveryDocument, PartnerFunction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCompletePartners I_SDDocumentCompletePartners from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DeliveryDocument _DeliveryDocument _DeliveryDocument.DeliveryDocument = I_SDDocumentCompletePartners.SDDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDLVPARTNERADDR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Delivery Partner Address view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_SDDocumentCompletePartners SDDocument SD Document
KEY PartnerFunction I_SDDocumentCompletePartners PartnerFunction Partner Functn
AddressID AddressID Ship-to address
FormOfAddress _DfltAddrRprstn FormOfAddress Title Key
BusinessPartnerName1 _DfltAddrRprstn OrganizationName1 Name
BusinessPartnerName2 _DfltAddrRprstn OrganizationName2 Name 2
BusinessPartnerName3 _DfltAddrRprstn OrganizationName3 Name 3
BusinessPartnerName4 _DfltAddrRprstn OrganizationName4 Name 4
PersonFamilyName _DfltAddrRprstn PersonFamilyName
PersonGivenName _DfltAddrRprstn PersonGivenName
Building _DfltAddrRprstn Building Building code
Floor _DfltAddrRprstn Floor Floor
RoomNumber _DfltAddrRprstn RoomNumber Room Number
CareOfName _DfltAddrRprstn CareOfName c/o
StreetPrefixName _DfltAddrRprstn StreetPrefixName1 Street 2
AdditionalStreetPrefixName _DfltAddrRprstn StreetPrefixName2 Street 3
StreetName _DfltAddrRprstn StreetName Text
HouseNumber _DfltAddrRprstn HouseNumber House Number
HouseNumberSupplementText _DfltAddrRprstn HouseNumberSupplementText Supplement
StreetSuffixName _DfltAddrRprstn StreetSuffixName1 Street 4
AdditionalStreetSuffixName _DfltAddrRprstn StreetSuffixName2 Street 5
District _DfltAddrRprstn DistrictName District
HomeCityName _DfltAddrRprstn VillageName Different City
PostalCode _DfltAddrRprstn PostalCode Postal Code
CityName _DfltAddrRprstn CityName Name
County _DfltAddrRprstn SecondaryRegionName County
Country _DfltAddrRprstn Country Venue: Ctry/Reg
Region _DfltAddrRprstn Region Venue Region
AddressTimeZone _DfltAddrRprstn AddressTimeZone Time Zone
TaxJurisdiction _DfltAddrRprstn TaxJurisdiction Tax Jurisdiction
TransportZone _DfltAddrRprstn TransportZone Transport Zone
POBox _DfltAddrRprstn POBox PO Box
POBoxIsWithoutNumber _DfltAddrRprstn POBoxIsWithoutNumber PO Box w/o No.
DeliveryServiceTypeCode _DfltAddrRprstn DeliveryServiceTypeCode Delvry Serv Type
DeliveryServiceNumber _DfltAddrRprstn DeliveryServiceNumber Delivery Service No.
POBoxLobbyName _DfltAddrRprstn POBoxLobbyName PO Box Lobby
POBoxPostalCode _DfltAddrRprstn POBoxPostalCode PO Box Postal Code
POBoxDeviatingCityName _DfltAddrRprstn POBoxDeviatingCityName PO Box City
POBoxDeviatingCountry _DfltAddrRprstn POBoxDeviatingCountry PO Box C/R
POBoxDeviatingRegion _DfltAddrRprstn POBoxDeviatingRegion PO Region
CompanyPostalCode _DfltAddrRprstn CompanyPostalCode Company Post Cd
AddressPostBoxUnusable _DfltAddrRprstn POBoxAddrNonDeliverableReason Undeliverable
CorrespondenceLanguage _DfltAddrRprstn CorrespondenceLanguage Language
PhoneNumber
PhoneNumberExtension
MobilePhoneNumber
FaxNumber
FaxNumberExtension
EmailAddress
PrfrdCommMediumType _DfltAddrRprstn PrfrdCommMediumType Comm. Method
_PartnerFunction _PartnerFunction
_DeliveryDocument _DeliveryDocument

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_DeliveryPartnerAddress.
-- 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_DeliveryPartnerAddress AS
SELECT
  I_SDDocumentCompletePartners.SDDocument AS DeliveryDocument,
  I_SDDocumentCompletePartners.PartnerFunction AS PartnerFunction,
  AddressID,
  _DfltAddrRprstn.FormOfAddress AS FormOfAddress,
  _DfltAddrRprstn.OrganizationName1 AS BusinessPartnerName1,
  _DfltAddrRprstn.OrganizationName2 AS BusinessPartnerName2,
  _DfltAddrRprstn.OrganizationName3 AS BusinessPartnerName3,
  _DfltAddrRprstn.OrganizationName4 AS BusinessPartnerName4,
  _DfltAddrRprstn.PersonFamilyName AS PersonFamilyName,
  _DfltAddrRprstn.PersonGivenName AS PersonGivenName,
  _DfltAddrRprstn.Building AS Building,
  _DfltAddrRprstn.Floor AS Floor,
  _DfltAddrRprstn.RoomNumber AS RoomNumber,
  _DfltAddrRprstn.CareOfName AS CareOfName,
  _DfltAddrRprstn.StreetPrefixName1 AS StreetPrefixName,
  _DfltAddrRprstn.StreetPrefixName2 AS AdditionalStreetPrefixName,
  _DfltAddrRprstn.StreetName AS StreetName,
  _DfltAddrRprstn.HouseNumber AS HouseNumber,
  _DfltAddrRprstn.HouseNumberSupplementText AS HouseNumberSupplementText,
  _DfltAddrRprstn.StreetSuffixName1 AS StreetSuffixName,
  _DfltAddrRprstn.StreetSuffixName2 AS AdditionalStreetSuffixName,
  _DfltAddrRprstn.DistrictName AS District,
  _DfltAddrRprstn.VillageName AS HomeCityName,
  _DfltAddrRprstn.PostalCode AS PostalCode,
  _DfltAddrRprstn.CityName AS CityName,
  _DfltAddrRprstn.SecondaryRegionName AS County,
  _DfltAddrRprstn.Country AS Country,
  _DfltAddrRprstn.Region AS Region,
  _DfltAddrRprstn.AddressTimeZone AS AddressTimeZone,
  _DfltAddrRprstn.TaxJurisdiction AS TaxJurisdiction,
  _DfltAddrRprstn.TransportZone AS TransportZone,
  _DfltAddrRprstn.POBox AS POBox,
  _DfltAddrRprstn.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  _DfltAddrRprstn.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  _DfltAddrRprstn.DeliveryServiceNumber AS DeliveryServiceNumber,
  _DfltAddrRprstn.POBoxLobbyName AS POBoxLobbyName,
  _DfltAddrRprstn.POBoxPostalCode AS POBoxPostalCode,
  _DfltAddrRprstn.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  _DfltAddrRprstn.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  _DfltAddrRprstn.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  _DfltAddrRprstn.CompanyPostalCode AS CompanyPostalCode,
  _DfltAddrRprstn.POBoxAddrNonDeliverableReason AS AddressPostBoxUnusable,
  _DfltAddrRprstn.CorrespondenceLanguage AS CorrespondenceLanguage,
  _DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  _DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneNumberExtension,
  _DfltAddrRprstn._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobilePhoneNumber,
  _DfltAddrRprstn._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxNumber,
  _DfltAddrRprstn._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxNumberExtension,
  _DfltAddrRprstn._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  _DfltAddrRprstn.PrfrdCommMediumType AS PrfrdCommMediumType
FROM I_SDDocumentCompletePartners
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON _DeliveryDocument.DeliveryDocument = I_SDDocumentCompletePartners.SDDocument  -- association [0..1]
;

Learn More