C_CmbndChmlCmplncWasteCode

DDL: C_CMBNDCHMLCMPLNCWASTECODE SQL: CCMBCHMLCMPWSTCD Type: view CONSUMPTION Package: EHFND_CNS_CCI
18 Fields 2 Data Sources

Manage Material - Waste codes

C_CmbndChmlCmplncWasteCode is a Consumption CDS View that provides data about "Manage Material - Waste codes" in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncWasteCode, I_ChmlCmplncWasteCodeAssgmt) and exposes 18 fields with key fields ChmlCmplncWasteCodeUUID, ChmlCmplncWasteCodeAssgmtUUID, ChmlCmplncInfoUUID. Part of development package EHFND_CNS_CCI.

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncWasteCode _WasteCode from
I_ChmlCmplncWasteCodeAssgmt _WasteCodeAssgmt inner

Annotations (11)

NameValueLevelField
EndUserText.label Manage Material - Waste codes view
AbapCatalog.sqlViewName CCMBCHMLCMPWSTCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncWasteCodeUUID I_ChmlCmplncWasteCodeAssgmt ChmlCmplncWasteCodeUUID Chml Cmplnc Wst Code
KEY ChmlCmplncWasteCodeAssgmtUUID ChmlCmplncWasteCodeAssgmtUUID Chml Cmplnc WC Asmt
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID Chemical Compliance Information PP
EnvrmtWasteCodeUUID EnvrmtWasteCodeUUID Waste Code
EnvrmtWasteCode EnvrmtWasteCode Waste Code
MaterialIsRequiredOnManifest I_ChmlCmplncWasteCodeAssgmt MaterialIsRequiredOnManifest Required On Manifest
MaterialIsRequiredOnLabel I_ChmlCmplncWasteCodeAssgmt MaterialIsRequiredOnLabel Required On Label
EnvrmtWasteCodeDescription
CmplRqVersName
CmplRqVersParagraphName
SubstanceListName Regulatory List
ChmlCmplncWasteCodeSequence I_ChmlCmplncWasteCodeAssgmt ChmlCmplncWasteCodeSequence Print Sequence
EnvrmtHazardCode _CmplRqVersWasteCode EnvrmtHazardCode
ListedSubstanceName _CmplRqVersWasteCode ListedSubstanceName Listed Substance Name
CASNumber _CmplRqVersWasteCode CASNumber CAS Number
_ChmlCmplncInfo _ChmlCmplncInfo
_ChmlCmplncWasteCode _ChmlCmplncWasteCode
_CmplRqVersWasteCode _CmplRqVersWasteCode

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_CmbndChmlCmplncWasteCode.
-- 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: CCMBCHMLCMPWSTCD

CREATE VIEW C_CmbndChmlCmplncWasteCode AS
SELECT
  _WasteCodeAssgmt.ChmlCmplncWasteCodeUUID AS ChmlCmplncWasteCodeUUID,
  ChmlCmplncWasteCodeAssgmtUUID,
  ChmlCmplncInfoUUID,
  EnvrmtWasteCodeUUID,
  EnvrmtWasteCode,
  _WasteCodeAssgmt.MaterialIsRequiredOnManifest AS MaterialIsRequiredOnManifest,
  _WasteCodeAssgmt.MaterialIsRequiredOnLabel AS MaterialIsRequiredOnLabel,
  _CmplRqVersWasteCode._WasteCodeText[1: Language = $session.system_language].EnvrmtWasteCodeDescription AS EnvrmtWasteCodeDescription,
  _CmplRqVersWasteCode._CmplRqVers.CmplRqVersName AS CmplRqVersName,
  _CmplRqVersWasteCode._SubstanceList._CmplRqVersStructure.CmplRqVersParagraphName AS CmplRqVersParagraphName,
  _CmplRqVersWasteCode._SubstanceList._Text[1: Language = $session.system_language].SubstanceListName AS SubstanceListName,
  _WasteCodeAssgmt.ChmlCmplncWasteCodeSequence AS ChmlCmplncWasteCodeSequence,
  _CmplRqVersWasteCode.EnvrmtHazardCode AS EnvrmtHazardCode,
  _CmplRqVersWasteCode.ListedSubstanceName AS ListedSubstanceName,
  _CmplRqVersWasteCode.CASNumber AS CASNumber
FROM I_ChmlCmplncWasteCode AS _WasteCode
INNER JOIN I_ChmlCmplncWasteCodeAssgmt AS _WasteCodeAssgmt ON /* join condition not captured in parsed metadata */
;

Learn More