C_SftyDataShtOutpReqMntr

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_SftyDataShtOutpReqMntr.
-- 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_SftyDataShtOutpReqMntr AS
SELECT
  cast( '' as ehsds_or_item_reason ) AS SftyDataShtOutpReqItemReason,
  cast ( _ShippingRequest.SftyDataShtCntctID as ehsds_sender_contact_id ) AS SftyDataShtCntctID,
  _ShippingRequest._SftyDataShtContact.SftyDataShtCntctUUID AS SftyDataShtCntctNavgnLink,
  _ChmlCmplncInfoUnpackaged.ChmlCmplncInfoUUID AS CmplRqRsltNavgnLink,
  SftyDataShtProductName,
  _ShippingRequest.SftyDataShtOutpReqIsMigrated AS SftyDataShtOutpReqIsMigrated,
  _ShippingRequest.SftyDataShtRcpntAddrID AS SftyDataShtRcpntAddrID,
  _ShippingRequest.ShipToPartyAddressID AS ShipToPartyAddressID
FROM I_SftyDataShtOutpReqItem AS ShippingRequestItem
LEFT OUTER JOIN C_SftyDataShtOutpReqBndl AS _RequestBundle ON SftyDataShtOutpReqUUID = _RequestBundle.SftyDataShtOutpReqUUID  -- association [0..*]
LEFT OUTER JOIN C_SftyDataShtOutpReqBndl AS _RequestBundleItem ON SftyDataShtOutpReqItemUUID = _RequestBundleItem.SftyDataShtOutpReqItemUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoUnpackaged ON ChmlCmplncProdUUID = _ChmlCmplncInfoUnpackaged.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _MaterialDataPrimary ON _MaterialDataPrimary.ChmlCmplncInfoUUID = ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReq AS _ShippingRequest ON SftyDataShtOutpReqUUID = _ShippingRequest.SftyDataShtOutpReqUUID  -- association [1..1]
LEFT OUTER JOIN C_SftyDataShtOutpReqCntct AS _CustomerContactData ON SftyDataShtOutpReqUUID = _CustomerContactData.SftyDataShtOutpReqUUID  -- association [0..1]
LEFT OUTER JOIN C_SftyDataShtOutpReqRcpnt AS _RecipientContactData ON SftyDataShtOutpReqUUID = _RecipientContactData.SftyDataShtOutpReqUUID  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqOrignVH AS _OriginTypeVH ON SftyDataShtOutpReqOriginType = _OriginTypeVH.SftyDataShtOutpReqOriginType  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqItmStsVH AS _ItemStatusVH ON SftyDataShtOutpReqItemStatus = _ItemStatusVH.SftyDataShtOutpReqItemStatus  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReqItmRsnVH AS _ReasonVH ON SftyDataShtOutpReqItemReason = _ReasonVH.SftyDataShtOutpReqItemReason  -- association [0..1]
;