SEPMRA_I_PurOrdDeliveryAddress

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 SEPMRA_I_PurOrdDeliveryAddress.
-- 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 SEPMRA_I_PurOrdDeliveryAddress AS
SELECT
  PO.PurchaseOrder AS PurchaseOrder,
  Address.CityName AS CityName,
  Address.PostalCode AS PostalCode,
  Address.StreetName AS StreetName,
  Address.HouseNumber AS HouseNumber,
  Address.Country AS Country,
  Address.AddressValidityStartDate AS AddressValidityStartDate,
  Address.AddressValidityEndDate AS AddressValidityEndDate,
  Address.Latitude AS Latitude,
  Address.Longitude AS Longitude,
  Address.FormattedAddress AS FormattedAddress,
  Address.AddressType AS AddressType,
  Address._Country AS _Country,
  Address._Type AS _Type
FROM SEPMRA_I_PurchaseOrderWD AS PO
LEFT OUTER JOIN SEPMRA_I_EmployeeOrgAssigment AS EmployeeOrgAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPMRA_I_OrganizationalUnit AS OrganizationalUnit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPMRA_I_Address AS Address ON /* join condition not captured in parsed metadata */
;