A_SalesOrderPartnerAddress

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 A_SalesOrderPartnerAddress.
-- 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 A_SalesOrderPartnerAddress AS
SELECT
  HeaderPartner.SDDocument AS SalesOrder,
  HeaderPartner.PartnerFunction AS PartnerFunction,
  Address.AddressRepresentationCode AS AddressRepresentationCode,
  Address.CorrespondenceLanguage AS CorrespondenceLanguage,
  Address.AddresseeFullName AS AddresseeFullName,
  Address.OrganizationName1 AS OrganizationName1,
  Address.OrganizationName2 AS OrganizationName2,
  Address.OrganizationName3 AS OrganizationName3,
  Address.OrganizationName4 AS OrganizationName4,
  Address.CityName AS CityName,
  Address.DistrictName AS DistrictName,
  Address.PostalCode AS PostalCode,
  Address.StreetPrefixName1 AS StreetPrefixName1,
  Address.StreetPrefixName2 AS StreetPrefixName2,
  Address.StreetName AS StreetName,
  Address.StreetSuffixName1 AS StreetSuffixName1,
  Address.StreetSuffixName2 AS StreetSuffixName2,
  Address.HouseNumber AS HouseNumber,
  Address.Country AS Country,
  Address.Region AS Region,
  Address.FormOfAddress AS FormOfAddress,
  Address.TaxJurisdiction AS TaxJurisdiction,
  Address.TransportZone AS TransportZone,
  Address.POBox AS POBox,
  Address.POBoxPostalCode AS POBoxPostalCode,
  Address._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry AS MobilePhoneCountry,
  Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber AS MobileNumber,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry AS PhoneNumberCountry,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber AS PhoneExtensionNumber,
  Address._CurrentDfltFaxNumber.FaxNumberCountry AS FaxNumberCountry,
  Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber AS FaxAreaCodeSubscriberNumber,
  Address._CurrentDfltFaxNumber.FaxExtensionNumber AS FaxExtensionNumber,
  SalesDocument.SalesDocumentType AS SalesOrderType,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel
FROM I_SDDocumentPartner AS HeaderPartner
INNER JOIN I_Address_2 AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentBasic AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderHeaderPartner AS _Partner ON SalesOrder = _Partner.SalesOrder AND PartnerFunction = _Partner.PartnerFunction  -- association [1..1]
;