I_SftyDataShtOutpReqItem

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_SftyDataShtOutpReqItem.
-- 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: ISDSORITM

CREATE VIEW I_SftyDataShtOutpReqItem AS
SELECT
  SftyDataShtOutpReqItemUUID,
  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,
  SftyDataShtOutpReqItemStatus,
  Material,
  DeliveryDocument,
  DeliveryDocumentItem,
  CmplRqRsltUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncProdUUID,
  SftyDataShtCmplncRqmt,
  SftyDataShtOutpReqOriginType,
  SftyDataShtRcpntPty,
  Country,
  ShipToParty,
  GoodsIssueDateTime,
  SftyDataShtOutpReqItemReason,
  SftyDataShtProductName,
  cast(_MultiCompProdMatlAssgmt.ChmlCmplncInfoUUID as ehfnd_mcp_cci_uuid preserving type) AS MultiComponentProductUUID,
  _Request.SftyDataShtOutpReqManReqEmail AS SftyDataShtOutpReqManReqEmail
FROM ehsdsv_or_item
LEFT OUTER JOIN I_SftyDataShtOutpReq AS _Request ON SftyDataShtOutpReqUUID = _Request.SftyDataShtOutpReqUUID  -- association [1..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqItmSts AS _SftyDataShtOutpReqItmSts ON SftyDataShtOutpReqItemStatus = _SftyDataShtOutpReqItmSts.SftyDataShtOutpReqItemStatus  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqItmRsn AS _SftyDataShtOutpReqItmRsn ON SftyDataShtOutpReqItemReason = _SftyDataShtOutpReqItmRsn.SftyDataShtOutpReqItemReason  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqOrignType AS _OriginType ON SftyDataShtOutpReqOriginType = _OriginType.SftyDataShtOutpReqOriginType  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncMatlAssgmt AS _MultiCompProdMatlAssgmt ON MultiComponentProduct = _MultiCompProdMatlAssgmt.Material  -- association [0..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_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_DeliveryDocument AS _Delivery ON DeliveryDocument = _Delivery.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _DeliveryItem ON DeliveryDocument = _DeliveryItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryItem.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _RecipientParty ON SftyDataShtRcpntPty = _RecipientParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON SftyDataShtRcpntPty = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON SftyDataShtRcpntPty = _BusinessPartnerCustomer.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _ShipToPartyCustomer ON ShipToParty = _ShipToPartyCustomer.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_CmplRqRslt AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
;