C_ChmlCmplncInfoDEX

DDL: C_CHMLCMPLNCINFODEX Type: view_entity CONSUMPTION Package: EHFND_CNS_CCI

Chemical Compliance Info

C_ChmlCmplncInfoDEX is a Consumption CDS View that provides data about "Chemical Compliance Info" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 16 fields with key field ChmlCmplncInfoUUID. Part of development package EHFND_CNS_CCI.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo I_ChmlCmplncInfo from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Chemical Compliance Info view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ChemicalComplianceInfo view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChemicalComplianceInfo
ChmlCmplncInternalName ChmlCmplncInternalName
ChmlCmplncInfoType ChmlCmplncInfoType
ResponsibleUnit ProdStewardshipRespUnit
DngrsGdsRespUnit DngrsGdsRespUnit
ProdStewardshipRespUnit ProdStewardshipRespUnit
MaterialIsSold MaterialIsSold
MaterialIsTransported MaterialIsTransported
MaterialIsSourced MaterialIsSourced
MaterialIsProduced MaterialIsProduced
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched
SftyDataShtIsNotRequired MatlIsNotProdSafetyRlvt Is Not Product Safety-Relevant
MaterialIsDisposed MaterialIsDisposed
MaterialIsEmissionRelevant MaterialIsEmissionRelevant Emission-Relevant
_MaterialAssignment _MaterialAssignment 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Chemical Compliance Info'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@ObjectModel.sapObjectNodeType.name: 'ChemicalComplianceInfo'
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
@VDM.viewType: #CONSUMPTION
@Analytics: {
  dataExtraction: { 
    enabled: true,
    delta.changeDataCapture: {
      mapping: [{
        table: 'EHFNDD_CCI',
        role: #MAIN,
        viewElement: ['ChmlCmplncInfoUUID'],
        tableElement: ['UUID']
      }         
      ]
    }  
  }
}
define view entity C_ChmlCmplncInfoDEX as select from I_ChmlCmplncInfo
{
  key ChmlCmplncInfoUUID,
      // Internal Number

      cast(Specification as ehfnd_internal_nr preserving type) as ChemicalComplianceInfo,
      ChmlCmplncInternalName,
      ChmlCmplncInfoType,
      
      ProdStewardshipRespUnit    as ResponsibleUnit,
      DngrsGdsRespUnit           as DngrsGdsRespUnit,

      ProdStewardshipRespUnit    as ProdStewardshipRespUnit,

      MaterialIsSold,
      MaterialIsTransported,
      MaterialIsSourced,
      MaterialIsProduced,
      ChmlCmplncProdIsResearched,
      @EndUserText.label: 'Is Not Product Safety-Relevant'
      MatlIsNotProdSafetyRlvt                                                              as SftyDataShtIsNotRequired,
      MaterialIsDisposed, 
      @EndUserText.label: 'Emission-Relevant'
      MaterialIsEmissionRelevant ,
  
      _MaterialAssignment 
}

Learn More