I_SftyDataShtOutpReq

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_SftyDataShtOutpReq.
-- 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.
-- SQL view name: ISDSOR

CREATE VIEW I_SftyDataShtOutpReq AS
SELECT
  SftyDataShtOutpReqUUID,
  cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type) AS CreationUTCDateTime,
  cast(createdbyuser as ehfnd_bo_crea_uname preserving type) AS CreatedByUser,
  cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type) AS LastChangeUTCDateTime,
  cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type) AS LastChangedByUser,
  SftyDataShtRcpntPty,
  ehsdsv_or.shiptoparty AS ShipToParty,
  ehsdsv_or.shiptopartycountry AS ShipToPartyCountry,
  ehsdsv_or.shiptopartyregion AS ShipToPartyRegion,
  ehsdsv_or.sftydatashtrcpntaddrid AS SftyDataShtRcpntAddrID,
  ehsdsv_or.shiptopartyaddressid AS ShipToPartyAddressID,
  ehsdsv_or.customer AS Customer,
  SftyDataShtOutpDateTime,
  SftyDataShtOutpReqStatus,
  SftyDataShtShipmentDateTime,
  ehsdsv_or.salesorganization AS SalesOrganization,
  ehsdsv_or.sftydatashtcntctid AS SftyDataShtCntctID,
  cast(ehsdsv_or.sftydatashtoutpreqmanreqemail as ehsds_sds_recipient_email_nc preserving type) AS SftyDataShtOutpReqManReqEmail,
  ehsdsv_or.sftydatashtoutpreqnotetext AS SftyDataShtOutpReqNoteText,
  ehsdsv_or.sftydatashtoutpreqismigrated AS SftyDataShtOutpReqIsMigrated,
  ehsdsv_or.sftydtashtrcpntptydetntype AS SftyDtaShtRcpntPtyDetnType,
  ehsdsv_or.pclgsdcmnllyovrwrtnaddruuid AS PCLgsDcMnllyOvrwrtnAddrUUID
FROM ehsdsv_or
LEFT OUTER JOIN I_SftyDataShtOutpReqItem AS _OutputItem ON SftyDataShtOutpReqUUID = _OutputItem.SftyDataShtOutpReqUUID  -- association [0..*]
LEFT OUTER JOIN I_SftyDataShtOutpReqSts AS _Status ON SftyDataShtOutpReqStatus = _Status.SftyDataShtOutpReqStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ShipToPartyCountry ON ShipToPartyCountry = _ShipToPartyCountry.Country  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _RecipientParty ON Customer = _RecipientParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON SftyDataShtRcpntPty = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON Customer = _BusinessPartnerCustomer.Customer  -- association [0..*]
LEFT OUTER JOIN I_Address_2 AS _RecipientAddress ON SftyDataShtRcpntAddrID = _RecipientAddress.AddressID AND _RecipientAddress.AddressPersonID is initial AND _RecipientAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _ShipToPartyAddress ON ShipToPartyAddressID = _ShipToPartyAddress.AddressID AND _ShipToPartyAddress.AddressPersonID is initial AND _ShipToPartyAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrg ON SalesOrganization = _SalesOrg.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_SftyDataShtCntct AS _SftyDataShtContact ON SftyDataShtCntctID = _SftyDataShtContact.SftyDataShtCntctID  -- association [0..*]
;