C_SftyDataShtOutpReqEmlTmpl

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 C_SftyDataShtOutpReqEmlTmpl.
-- 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 C_SftyDataShtOutpReqEmlTmpl AS
SELECT
  I_SftyDataShtOutpReq.SftyDataShtOutpReqUUID AS SftyDataShtOutpReqUUID,
  I_SftyDataShtOutpReq.SftyDataShtRcpntPty AS SftyDataShtRcpntPty,
  I_SftyDataShtOutpReq.SftyDataShtOutpDateTime AS SftyDataShtOutpDateTime,
  I_SftyDataShtOutpReq.SftyDataShtOutpReqNoteText AS SftyDataShtOutpReqNoteText,
  I_SftyDataShtOutpReq.ShipToPartyAddressID AS ShipToPartyAddressID,
  I_SftyDataShtOutpReq.Customer AS Customer,
  _Customer.BPCustomerName AS CustomerName,
  coalesce ( _Customer.BPCustomerFullName, _Customer.CustomerFullName ) AS CustomerFullName,
  coalesce ( _CustomerAddress.Country, _Customer.Country ) AS Country,
  coalesce ( _CustomerAddress.Region, _Customer.Region ) AS Region,
  coalesce ( concat_with_space( _CustomerAddress.StreetName, _CustomerAddress.HouseNumber, 1 ), _Customer.BPAddrStreetName ) AS StreetName,
  coalesce ( _CustomerAddress.CityName, _Customer.BPAddrCityName ) AS CityName,
  coalesce ( _CustomerAddress.PostalCode, _Customer.PostalCode ) AS PostalCode
FROM I_SftyDataShtOutpReq
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _CustomerAddress ON ShipToPartyAddressID = _CustomerAddress.AddressID AND _CustomerAddress.AddressPersonID is initial AND _CustomerAddress.AddressRepresentationCode is initial  -- association [0..1]
;