I_CHMLCMPLNCINFOVH

CDS View

Value Help for Chemical Compliance Information

I_CHMLCMPLNCINFOVH is a CDS View in S/4HANA. Value Help for Chemical Compliance Information. It contains 14 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 14 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_ChmlCmplncBaseProdVH view from CONSUMPTION Value Help for Bulk Chemical Compliance Information
C_ChmlCmplncInfoVH view from CONSUMPTION Value Help for Chemical Compliance Information
C_ChmlCmplncRawMatVH view from CONSUMPTION Value Help for Components of Material Based Composition
C_ChmlCmplncRnDSampleVH view_entity from CONSUMPTION Chemical Compliance Info for Sample Products
C_EHSChmlUseChmlCmplInfoVH view_entity from CONSUMPTION Chemical Use Chemical Compliance Info
C_EHSRskAssmt2ChmlCmplInfoVH view_entity from CONSUMPTION Chemical compliance info for RAS V2
C_MatlBasedCmpstnCompVH view from CONSUMPTION Value Help for Components of Material Based Composition
C_SftyInstrnChmlCmplncInfoVH view from CONSUMPTION Chemical compliance info for safety instruction
I_ChmlCmplncInfoPckgdProdVH view_entity from COMPOSITE Packaged Product Value Help

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID 9
ChmlCmplncInfoType ChmlCmplncInfoType 5
ChmlCmplncInternalName ChmlCmplncInternalName 4
ChmlCmplncProdIsResearched ChmlCmplncProdIsResearched 1
DngrsGdsRespUnit DngrsGdsRespUnit 5
Material Material 3
MaterialIsDisposed MaterialIsDisposed 5
MaterialIsEmissionRelevant MaterialIsEmissionRelevant 5
MaterialIsProduced MaterialIsProduced 5
MaterialIsSold MaterialIsSold 5
MaterialIsSourced MaterialIsSourced 5
MaterialIsTransported MaterialIsTransported 5
MatlIsMultiComponentProduct MatlIsMultiComponentProduct 1
ProdStewardshipRespUnit ProdStewardshipRespUnit 4 
@EndUserText.label: 'Value Help for Chemical Compliance Information'

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

@AccessControl:{
  authorizationCheck: #CHECK,
  // blocking of personal data not required (no personal data fields exposed for material)

  personalData.blocking: #NOT_REQUIRED
}

@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  dataCategory: #VALUE_HELP,

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

@Metadata.ignorePropagatedAnnotations: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@UI:{
  presentationVariant: [{
    sortOrder: [{ by: 'ChmlCmplncInfoCombinedName', direction: #ASC }]
  }]
}

@Search.searchable: true

define view I_ChmlCmplncInfoVH
  as select from           I_ChmlCmplncInfo       as ChemicalComplianceInfo

  -- Join data from primary material assignment
    left outer to one join I_ChmlCmplncMatlAssgmt as PrimaryMaterial on  ChemicalComplianceInfo.ChmlCmplncInfoUUID = PrimaryMaterial.ChmlCmplncInfoUUID
                                                                     and PrimaryMaterial.MatlAssgmtIsPrimary       = 'X'
  -- Join data from from primary material
    left outer to one join I_Product              as MaterialData    on PrimaryMaterial.Material = MaterialData.Product

{
      @UI.hidden: true
  key ChemicalComplianceInfo.ChmlCmplncInfoUUID,

      PrimaryMaterial.Material,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @Search.ranking: #HIGH
      //      @UI.hidden: true

      MaterialData._Text[1: Language = $session.system_language].ProductName,

      -- Name of Chemical Compliance Information (either material name of primary material or internal name)
      @Consumption.filter.hidden: true
      cast(
        case
          when MaterialData._Text[1: Language = $session.system_language].ProductName is not null
            then MaterialData._Text[1: Language = $session.system_language].ProductName
          when MaterialData._Text[1: Language = $session.system_language].ProductName is null
            then ChemicalComplianceInfo.ChmlCmplncInternalName
        end
      as ehfnd_cci_product_name preserving type)        as ChmlCmplncInfoCombinedName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.7
      @Search.ranking: #HIGH
      ChemicalComplianceInfo.ChmlCmplncInternalName,

      // 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,

      @UI.hidden: true
      ChemicalComplianceInfo.MatlIsMultiComponentProduct as MatlIsMultiComponentProduct,

      @UI.hidden: true
      ChemicalComplianceInfo.ChmlCmplncProdIsResearched as ChmlCmplncProdIsResearched,

      @UI.hidden: true
      ChemicalComplianceInfo.Specification              as Specification
}

Learn More