C_ChmlCmplncWasteCodeAssgmtTP

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_ChmlCmplncWasteCodeAssgmtTP.
-- 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_ChmlCmplncWasteCodeAssgmtTP AS
SELECT
  ChmlCmplncWasteCodeAssgmtUUID,
  ChmlCmplncWasteCodeUUID,
  EnvrmtWasteCodeUUID,
  EnvrmtWasteCode,
  ChmlCmplncWasteCodeSequence,
  _WasteCodeText.EnvrmtWasteCodeDescription AS EnvrmtWasteCodeDescription,
  MaterialIsRequiredOnManifest,
  MaterialIsRequiredOnLabel,
  cast( '' as ehfnd_req_identifier) AS ComplianceRequirement,
  cast( '' as ehfnd_crv_name) AS CmplRqVersName,
  cast( '' as ehfnd_req_paragraph) AS CmplRqVersParagraphName,
  cast( '' as ehfnd_regl_name) AS SubstanceListName,
  cast( '' as ehfnd_haz_code) AS EnvrmtHazardCode
FROM I_ChmlCmplncWasteCodeAssgmtTP
LEFT OUTER JOIN C_ChmlCmplncWasteCodeTP AS _ChmlCmplncWasteCode ON ChmlCmplncWasteCodeUUID = _ChmlCmplncWasteCode.ChmlCmplncWasteCodeUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRqVersWasteCodeText AS _WasteCodeText ON EnvrmtWasteCodeUUID = _WasteCodeText.EnvrmtWasteCodeUUID AND _WasteCodeText.Language = $session.system_language  -- association [1..*]
;