A_SalesOrderItemPartnerAddress

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_SalesOrderItemPartnerAddress.
-- 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_SalesOrderItemPartnerAddress AS
SELECT
  ItemPartner.SDDocument AS SalesOrder,
  ItemPartner.SDDocumentItem AS SalesOrderItem,
  ItemPartner.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.StreetName AS StreetName,
  Address.StreetPrefixName1 AS StreetPrefixName1,
  Address.StreetPrefixName2 AS StreetPrefixName2,
  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,
  SalesDocumentItem.SalesDocumentType AS SalesOrderType,
  SalesDocumentItem.OrganizationDivision AS OrganizationDivision,
  SalesDocumentItem.SalesOrganization AS SalesOrganization,
  SalesDocumentItem.DistributionChannel AS DistributionChannel
FROM I_SDDocumentItemPartner AS ItemPartner
INNER JOIN I_Address_2 AS Address ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocumentItemBasic AS SalesDocumentItem 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_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderItemPartner AS _Partner ON SalesOrder = _Partner.SalesOrder AND SalesOrderItem = _Partner.SalesOrderItem AND PartnerFunction = _Partner.PartnerFunction  -- association [1..1]
;