I_EnvrmtWasteDngrsGdsCmbnd

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_EnvrmtWasteDngrsGdsCmbnd.
-- 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: IENVWSTDGC

CREATE VIEW I_EnvrmtWasteDngrsGdsCmbnd AS
SELECT
  ChmlCmplncInfoUUID,
  CmplRqVersUUID,
  cast( '' as ehfnd_req_mot ) AS DngrsGoodsModeOfTransport,
  CmplRqRsltUUID,
  cast( '' as val_text ) AS DngrsGoodsModeOfTransportName,
  _CmplRqVers.CmplRqVers AS CmplRqVers,
  _CmplRqVers.CmplRqVersName AS CmplRqVersName,
  cast( ' ' as ehfnd_descofdngrsgdsp_nd ) AS DescriptionOfDngrsGdsPckg,
  cast( ' ' as ehfnd_cci_desc_of_dg_pckg_text ) AS DescOfDngrsGdsPckgName,
  cast( '0' as ehfnd_cci_enclosure_qty ) AS DangerousGoodsEnclosureQty,
  cast( '' as ehfnd_cci_enclosure_unit ) AS DangerousGoodsEnclosureUnit,
  ClassifiedAsDangerousGood,
  _ClassifiedAsDangerousGoodTxt[1: Language = $session.system_language].ClassifiedAsDangerousGoodName AS ClassifiedAsDangerousGoodName,
  CmplRqRsltManualStatus AS TransportPermission,
  _TransportPermissionText[1: Language = $session.system_language].TransportPermissionName AS TransportPermissionName,
  _ChmlCmplncInfo.ChmlCmplncInfoType AS ChmlCmplncInfoType,
  PPDngrsGds.ComplianceRequirement AS ComplianceRequirement
LEFT OUTER JOIN I_DngrsGoodsModeOfTransportTxt AS _DngrsGoodsModeOfTransportTxt ON DngrsGoodsModeOfTransport = _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransport AND _DngrsGoodsModeOfTransportTxt.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_DescOfDngrsGdsPckgText AS _DescOfDngrsGdsPckgText ON EnclosureDets.DescriptionOfDngrsGdsPckg = _DescOfDngrsGdsPckgText.DescriptionOfDngrsGdsPckg AND _DescOfDngrsGdsPckgText.Language = $session.system_language  -- association [0..1]
;