I_WasteDisposalChannelPermit

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_WasteDisposalChannelPermit.
-- 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 I_WasteDisposalChannelPermit AS
SELECT
  WasteDsplChannelPermitUUID,
  WasteDisposalChannelUUID,
  cast ( wastedsplchannelpermittype as ehewa_wstrm_chnl_prmt_type_nce ) AS WasteDsplChannelPermitType,
  WasteDsplChannelPermitNmbr,
  CmplRqVersUUID,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM ehewad_wa_dclpt
LEFT OUTER JOIN I_WasteDisposalChannel AS _DisposalChannel ON WasteDisposalChannelUUID = _DisposalChannel.WasteDisposalChannelUUID  -- association [1..1]
LEFT OUTER JOIN I_WasteStreamChnlPermitType AS _PermitType ON WasteDsplChannelPermitType = _PermitType.WasteStreamChnlPermitType  -- association [1..1]
LEFT OUTER JOIN I_WasteStreamChnlPermitNmbr AS _PermitNumber ON CmplRqVersUUID = _PermitNumber.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersEnvrnmtlLimit AS _UpperLimit ON CmplRqVersUUID = _UpperLimit.CmplRqVersUUID AND _UpperLimit.CmplRqEnvrnmtlLimitType = '00'  -- association [1..1]
LEFT OUTER JOIN I_EHSCmplRqPermit AS _Permit ON CmplRqVersUUID = _Permit.CmplRqVersUUID  -- association [1..1]
LEFT OUTER JOIN I_EHSCmplRqPmtWasteData AS _WasteData ON CmplRqVersUUID = _WasteData.CmplRqVersUUID  -- association [0..1]
;