C_SftyInstrnChmlCmplncInfoVH

DDL: C_SFTYINSTRNCHMLCMPLNCINFOVH Type: view CONSUMPTION

Chemical compliance info for safety instruction

C_SftyInstrnChmlCmplncInfoVH is a Consumption CDS View that provides data about "Chemical compliance info for safety instruction" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfoVH) and exposes 13 fields with key field ChmlCmplncInfoUUID.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfoVH ChemicalComplianceInfo from

Annotations (17)

NameValueLevelField
EndUserText.label Chemical compliance info for safety instruction view
AbapCatalog.sqlViewName CFSICCIVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view
Consumption.ranked true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfoVH ChmlCmplncInfoUUID
ChmlCmplncInternalName I_ChmlCmplncInfoVH ChmlCmplncInternalName
ChmlCmplncInfoCombinedName ChmlCmplncInfoCombinedName
Material I_ChmlCmplncInfoVH Material
ProdStewardshipRespUnit I_ChmlCmplncInfoVH ProdStewardshipRespUnit
DngrsGdsRespUnit I_ChmlCmplncInfoVH DngrsGdsRespUnit
ChmlCmplncInfoType I_ChmlCmplncInfoVH ChmlCmplncInfoType
MaterialIsSold I_ChmlCmplncInfoVH MaterialIsSold
MaterialIsTransported I_ChmlCmplncInfoVH MaterialIsTransported
MaterialIsSourced I_ChmlCmplncInfoVH MaterialIsSourced
MaterialIsProduced I_ChmlCmplncInfoVH MaterialIsProduced
MaterialIsDisposed I_ChmlCmplncInfoVH MaterialIsDisposed
MaterialIsEmissionRelevant I_ChmlCmplncInfoVH MaterialIsEmissionRelevant 
@EndUserText.label: 'Chemical compliance info for safety instruction'

@AbapCatalog: { sqlViewName: 'CFSICCIVH',
                compiler.compareFilter: true,
                preserveKey: true }

@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData.blocking: #NOT_REQUIRED }


@VDM.viewType: #CONSUMPTION

@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'ChmlCmplncInfoUUID',
                semanticKey: ['ChmlCmplncInfoCombinedName'],
                usageType: { serviceQuality: #C,
                             sizeCategory: #L,
                             dataClass: #MASTER }
               }

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true

@Search.searchable: true
@Consumption.ranked:true


define view C_SftyInstrnChmlCmplncInfoVH
    as select from I_ChmlCmplncInfoVH as ChemicalComplianceInfo

{
      @UI.hidden: true  
      @ObjectModel.text.element: [ 'ChmlCmplncInternalName' ]  
  key ChemicalComplianceInfo.ChmlCmplncInfoUUID,

      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold:   0.8,
        ranking: #HIGH
      }
      ChemicalComplianceInfo.ChmlCmplncInternalName,


      @Semantics.text: true
      ChmlCmplncInfoCombinedName,


      @Search: {
        defaultSearchElement: true,
        fuzzinessThreshold:   0.8,
        ranking: #LOW
      }
      ChemicalComplianceInfo.Material,


      // needed for DCL

      @UI.hidden: true
      ChemicalComplianceInfo.ProdStewardshipRespUnit    as ProdStewardshipRespUnit,
      @UI.hidden: true
      ChemicalComplianceInfo.DngrsGdsRespUnit           as DngrsGdsRespUnit,
      @UI.hidden: true
      ChemicalComplianceInfo.ChmlCmplncInfoType         as ChmlCmplncInfoType,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsSold             as MaterialIsSold,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsTransported      as MaterialIsTransported,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsSourced          as MaterialIsSourced,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsProduced         as MaterialIsProduced,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsDisposed         as MaterialIsDisposed,
      @UI.hidden: true
      ChemicalComplianceInfo.MaterialIsEmissionRelevant as MaterialIsEmissionRelevant
} 
where
    ChemicalComplianceInfo.ChmlCmplncInfoType = 'BU'
  and(
    ChemicalComplianceInfo.MaterialIsSourced     = 'X'
    or ChemicalComplianceInfo.MaterialIsSold     = 'X'
    or ChemicalComplianceInfo.MaterialIsProduced = 'X'    
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFOVH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More