C_CmbndChmlCmplncWasteCode

DDL: C_CMBNDCHMLCMPLNCWASTECODE SQL: CCMBCHMLCMPWSTCD Type: view CONSUMPTION

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.

2 data source(s) 18 fields

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
KEY ChmlCmplncWasteCodeAssgmtUUID ChmlCmplncWasteCodeAssgmtUUID
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
EnvrmtWasteCodeUUID EnvrmtWasteCodeUUID
EnvrmtWasteCode EnvrmtWasteCode
MaterialIsRequiredOnManifest I_ChmlCmplncWasteCodeAssgmt MaterialIsRequiredOnManifest
MaterialIsRequiredOnLabel I_ChmlCmplncWasteCodeAssgmt MaterialIsRequiredOnLabel
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 
@EndUserText.label: 'Manage Material - Waste codes'
@AbapCatalog.sqlViewName: 'CCMBCHMLCMPWSTCD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

@Metadata.allowExtensions: true

@ObjectModel:
{
  semanticKey:  [ 'EnvrmtWasteCode' ],
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  }

}

define view C_CmbndChmlCmplncWasteCode
  as select from I_ChmlCmplncWasteCode       as _WasteCode
    inner join   I_ChmlCmplncWasteCodeAssgmt as _WasteCodeAssgmt on _WasteCode.ChmlCmplncWasteCodeUUID = _WasteCodeAssgmt.ChmlCmplncWasteCodeUUID
{

      //_WasteCode

  key _WasteCodeAssgmt.ChmlCmplncWasteCodeUUID,
  key ChmlCmplncWasteCodeAssgmtUUID,
  key ChmlCmplncInfoUUID,

      EnvrmtWasteCodeUUID,
      
      EnvrmtWasteCode,
      
      @EndUserText.quickInfo: 'Required On Manifest' 
      _WasteCodeAssgmt.MaterialIsRequiredOnManifest as MaterialIsRequiredOnManifest,
      
      @EndUserText.quickInfo: 'Required On Label'
      _WasteCodeAssgmt.MaterialIsRequiredOnLabel    as MaterialIsRequiredOnLabel,

       @EndUserText.quickInfo: 'Waste Code Description' 
      _CmplRqVersWasteCode._WasteCodeText[1: Language = $session.system_language].EnvrmtWasteCodeDescription,

       
      _CmplRqVersWasteCode._CmplRqVers.CmplRqVersName,

      _CmplRqVersWasteCode._SubstanceList._CmplRqVersStructure.CmplRqVersParagraphName,

       @EndUserText.label: 'Regulatory List' 
      _CmplRqVersWasteCode._SubstanceList._Text[1: Language = $session.system_language].SubstanceListName,
      
      @EndUserText.label: 'Print Sequence'
      @EndUserText.quickInfo: 'Print Sequence'
      _WasteCodeAssgmt.ChmlCmplncWasteCodeSequence,

      _CmplRqVersWasteCode.EnvrmtHazardCode,

      @EndUserText.label: 'Listed Substance Name'
      _CmplRqVersWasteCode.ListedSubstanceName,
      
      @EndUserText.label: 'CAS Number'
      _CmplRqVersWasteCode.CASNumber,
      
//      @EndUserText.label: 'Waste Characteristic'

//      @UI.hidden: true

//      _ChmlCmplncInfo.EnvrmtWasteHazardCharcID,


      /* Associations */
      _ChmlCmplncInfo,
      _ChmlCmplncWasteCode,
      _CmplRqVersWasteCode



}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCWASTECODE",
"I_CHMLCMPLNCWASTECODEASSGMT",
"I_CMPLRQVERSENHANCED",
"I_CMPLRQVERSSTRUCTURE",
"I_CMPLRQVERSSUBSTANCELIST",
"I_CMPLRQVERSSUBSTANCELISTTEXT",
"I_CMPLRQVERSWASTECODETEXT",
"I_ENVRMTWASTECODESRELEASED"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCWASTECODE",
"I_ENVRMTWASTECODESRELEASED"
],
"BASE":
[
"I_CHMLCMPLNCWASTECODE",
"I_CHMLCMPLNCWASTECODEASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More