C_GHSLblSensitizingCompVH

DDL: C_GHSLBLSENSITIZINGCOMPVH SQL: CGHSLBLSCVH Type: view CONSUMPTION Package: EHSDS_CRPAT_GHS_LABEL

Substance indicated as Sensitizing Components

C_GHSLblSensitizingCompVH is a Consumption CDS View that provides data about "Substance indicated as Sensitizing Components" in SAP S/4HANA. It reads from 3 data sources (I_ChmlComponent, I_ChmlComposition, I_CmplRqRsltGHSLblAssmtDrft) and exposes 7 fields with key fields CmplRqRsltUUID, SubstanceUUID. It has 2 associations to related views. Part of development package EHSDS_CRPAT_GHS_LABEL.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_ChmlComponent _ChmlComponent inner
I_ChmlComposition _ChmlComposition inner
I_CmplRqRsltGHSLblAssmtDrft _CmplRqRsltGHSLblAssmtDrft from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SubstanceTP _Substance _ChmlComponent.SubstanceUUID = _Substance.SubstanceUUID --Link to 'Chemcial Compliance Info' as root
[1..1] I_ChmlCmplncInfo _ChmlCmplncInfo $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID

Annotations (14)

NameValueLevelField
EndUserText.label Substance indicated as Sensitizing Components view
AbapCatalog.sqlViewName CGHSLBLSCVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SubstanceUUID view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID I_CmplRqRsltGHSLblAssmtDrft CmplRqRsltUUID
KEY SubstanceUUID I_ChmlComponent SubstanceUUID
SubstanceName _Substance SubstanceName
ResponsibleUnit _Substance ResponsibleUnit
ChmlCmplncInfoUUID I_ChmlComposition ChmlCmplncInfoUUID
_ChmlCmplncInfo _ChmlCmplncInfo
_Substance _Substance 
@EndUserText.label: 'Substance indicated as Sensitizing Components'
@AbapCatalog.sqlViewName: 'CGHSLBLSCVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #L
   }
@ObjectModel.representativeKey: 'SubstanceUUID'
@ObjectModel.semanticKey:  [ 'SubstanceUUID' ]
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.resultSet.sizeCategory: #XS

@Metadata.ignorePropagatedAnnotations: true

define view C_GHSLblSensitizingCompVH

  as select from I_CmplRqRsltGHSLblAssmtDrft as _CmplRqRsltGHSLblAssmtDrft

    inner join   I_ChmlComposition           as _ChmlComposition on  _CmplRqRsltGHSLblAssmtDrft.ChmlCmplncInfoUUID  = _ChmlComposition.ChmlCmplncInfoUUID
                                                                 and _CmplRqRsltGHSLblAssmtDrft.ChmlSuplrMatlUUID   = _ChmlComposition.ChmlSuplrMatlUUID
                                                                 and _CmplRqRsltGHSLblAssmtDrft.SubstanceUUID       = _ChmlComposition.SubstanceUUID
                                                                 and _CmplRqRsltGHSLblAssmtDrft.ChmlCompositionType = _ChmlComposition.ChmlCompositionType
                                                                 and _ChmlComposition.ChmlCompositionStatus         = 'RE'
    inner join   I_ChmlComponent             as _ChmlComponent   on _ChmlComposition.ChmlCompositionUUID = _ChmlComponent.ChmlCompositionUUID


  association [0..1] to I_SubstanceTP    as _Substance      on _ChmlComponent.SubstanceUUID = _Substance.SubstanceUUID

  --Link to 'Chemcial Compliance Info' as root
  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID

{

      @UI.hidden: true
  key _CmplRqRsltGHSLblAssmtDrft.CmplRqRsltUUID as CmplRqRsltUUID,

      @ObjectModel.text.element: ['SubstanceName']
  key _ChmlComponent.SubstanceUUID              as SubstanceUUID,

      @Semantics.text: true
      _Substance.SubstanceName                  as SubstanceName,

      @UI.hidden: true
      _Substance.ResponsibleUnit                as ResponsibleUnit,

      @UI.hidden: true
      _ChmlComposition.ChmlCmplncInfoUUID       as ChmlCmplncInfoUUID,

      @UI.hidden: true
      _ChmlCmplncInfo,

      @UI.hidden: true
      _Substance
}

Learn More