C_SftyDataShtOutpReqBndl

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_SftyDataShtOutpReqBndl.
-- 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_SftyDataShtOutpReqBndl AS
SELECT
  ShippingRequestItem.MultiComponentProductUUID AS MultiComponentProductUUID,
  _MultiCompProdMatlAssgmt._Product._Text[1: Language = $session.system_language].ProductName AS MultiComponentProductName,
  cast('' as ehsds_or_item_reason) AS SftyDataShtOutpReqItemReason
FROM I_SftyDataShtOutpReqItem AS ShippingRequestItem
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoUP ON ChmlCmplncProdUUID = _ChmlCmplncInfoUP.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfoBP ON BrnddChmlCmplncInfoUUID = _ChmlCmplncInfoBP.ChmlCmplncInfoUUID  -- association [0..1]
LEFT OUTER JOIN I_SftyDataShtOutpReq AS _ShippingRequest ON SftyDataShtOutpReqUUID = _ShippingRequest.SftyDataShtOutpReqUUID  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncReq AS _ComplianceRequest ON DeliveryDocument = _ComplianceRequest.SalesDocument AND DeliveryDocumentItem = _ComplianceRequest.SalesDocumentItem AND Material = _ComplianceRequest.Material AND _ComplianceRequest.ChmlCmplncReqCmplncProc = 'SDS' AND _ComplianceRequest.ChmlCmplncRequestOriginType = 'LF' AND ( _ComplianceRequest.ChmlCmplncRequestPrgrsStatus = 'NEW' OR _ComplianceRequest.ChmlCmplncRequestPrgrsStatus = 'INPROG' )  -- 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]
;