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

CREATE VIEW C_SftyDataShtOutpReqMntr AS
SELECT
  MultiComponentProduct,
  cast(_MCPChmlCmplncInfo.Specification as ehfnd_mcp_int_nr preserving type) AS MultiCompProdIntNmbr,
  cast(_CmplRqRslt._CmplRqVers.CmplRqVersName as ehpma_crr_crv_mkt_name preserving type) AS CmplRqVersName,
  cast('' as ehsds_or_item_reason) AS SftyDataShtOutpReqItemReason,
  _ShippingRequest.SftyDataShtShipmentDateTime AS SftyDataShtShipmentDateTime,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  _ChmlCmplncInfoUnpackaged.ChmlCmplncInfoUUID AS CmplRqRsltNavgnLink,
  _ShippingRequest._SftyDataShtContact.SftyDataShtCntctUUID AS SftyDataShtCntctNavgnLink,
  _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 C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickVw ON _ChmlCmplncInfo.Specification = _ChmlCmplncInfoQuickVw.Specification  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoUnpackaged ON ChmlCmplncProdUUID = _ChmlCmplncInfoUnpackaged.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _UnpckgdChmlCmplncInfoQuickVw ON _ChmlCmplncInfoUnpackaged.Specification = _UnpckgdChmlCmplncInfoQuickVw.Specification  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _MCPChmlCmplncInfo ON MultiComponentProductUUID = _MCPChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _ChmlCmplncInfoQuickView ON MultiCompProdIntNmbr = _ChmlCmplncInfoQuickView.Specification  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoBranded ON BrnddChmlCmplncInfoUUID = _ChmlCmplncInfoBranded.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN C_ChmlCmplncInfoQuickView AS _BrnddChmlCmplncInfoQuickVw ON _ChmlCmplncInfoBranded.Specification = _BrnddChmlCmplncInfoQuickVw.Specification  -- 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]
;