C_HzdsSubstInvtryChmlRstrcdVH

DDL: C_HZDSSUBSTINVTRYCHMLRSTRCDVH Type: view CONSUMPTION Package: EHHSS_CNS_HSI

HSI: Chemicals Restricted Value Help

C_HzdsSubstInvtryChmlRstrcdVH is a Consumption CDS View that provides data about "HSI: Chemicals Restricted Value Help" in SAP S/4HANA. It reads from 2 data sources (I_HzdsSubstInventoryItemDraft, I_HzdsSubstInventoryDraft) and exposes 9 fields with key fields ChemicalUUID, HzdsSubstInventoryUUID. Part of development package EHHSS_CNS_HSI.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_HzdsSubstInventoryItemDraft _Helper left_outer
I_HzdsSubstInventoryDraft _HzdsSubstInventory cross

Annotations (14)

NameValueLevelField
EndUserText.label HSI: Chemicals Restricted Value Help view
AbapCatalog.sqlViewName CHASSUBINVCHRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ChemicalUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChemicalUUID I_Chemical ChemicalUUID
KEY HzdsSubstInventoryUUID I_HzdsSubstInventoryDraft HzdsSubstInventoryUUID
ChemicalBasicInfoUUID I_Chemical ChemicalBasicInfoUUID
NameOfChemical
ChemicalID _ChemicalRoot ChemicalID
CASNumber _ChemicalBasicInfo CASNumber
ChemicalRevisionUUID I_Chemical ChemicalRevisionUUID
_ChemicalName _ChemicalName
Associations_ChemicalMaterial 
@EndUserText.label: 'HSI: Chemicals Restricted Value Help'

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

@AccessControl: { authorizationCheck: #CHECK }

@VDM.viewType: #CONSUMPTION

@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'ChemicalUUID',
                usageType: { serviceQuality: #C,
                             sizeCategory: #M,
                             dataClass: #MIXED }
               }

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.allowExtensions:true

@Search.searchable: true

define view C_HzdsSubstInvtryChmlRstrcdVH
  as select distinct from I_Chemical
    cross join            I_HzdsSubstInventoryDraft as _HzdsSubstInventory
    left outer join       I_HzdsSubstInventoryItemDraft as _Helper on  I_Chemical.ChemicalUUID                        = _Helper.ChemicalUUID
                                                                   and _HzdsSubstInventory.HzdsSubstInventoryUUID = _Helper.HzdsSubstInventoryUUID
{

      @ObjectModel: { text: { association: '_ChemicalName',
                              control: #ASSOCIATED_TEXT_UI_HIDDEN },
                      filter.enabled: false }
      @UI.hidden: true
  key I_Chemical.ChemicalUUID,

      @Consumption.filter.hidden: true
  key _HzdsSubstInventory.HzdsSubstInventoryUUID,
  
      @UI.hidden: true
      @ObjectModel.filter.enabled: false
      I_Chemical.ChemicalBasicInfoUUID,

      @Search: { defaultSearchElement: true,
                 ranking: #HIGH,
                 fuzzinessThreshold: 0.8 }
      @ObjectModel.readOnly: true
      _ChemicalBasicInfo._ChemicalName[1: Language = $session.system_language].NameOfChemical,

      @Search: { defaultSearchElement: true,
                ranking: #MEDIUM,
                fuzzinessThreshold: 0.8 }
      _ChemicalRoot.ChemicalID,

      @Search: { defaultSearchElement: true,
                ranking: #MEDIUM,
                fuzzinessThreshold: 0.8 }
      _ChemicalBasicInfo.CASNumber,

      @ObjectModel: { readOnly: true,
                     filter: { transformedBy: 'ABAP:CL_EHHSS_HSI_ITM_SADL_EXIT' },
                     virtualElement: true,
                     virtualElementCalculatedBy: 'ABAP:CL_EHHSS_HSI_ITM_SADL_EXIT' }
      @EndUserText.label: 'Material Number'
      cast( '' as abap.char( 1333 ) )                                                                              as ChemicalMatlsConcatenated,

      @ObjectModel: { readOnly: true,
                      filter: { transformedBy: 'ABAP:CL_EHHSS_HSI_ITM_SADL_EXIT' },
                      virtualElement: true,
                      virtualElementCalculatedBy: 'ABAP:CL_EHHSS_HSI_ITM_SADL_EXIT' }
      @EndUserText.label: 'Material Name'
      cast( '' as abap.char( 1333 ) )                                                                              as ChemicalMatlNamesConcatenated,


      @UI.hidden: true
      I_Chemical.ChemicalRevisionUUID,

      @Consumption.filter.hidden: true
      @UI.hidden: true
      _ChemicalName,

      -- Associations
      @UI.hidden: true
      _ChemicalMaterial

}
where
      I_Chemical.RevisionStartDate                  <= $session.system_date
  and I_Chemical.RevisionEndDate                    >= $session.system_date
  and _Helper.HzdsSubstInventoryItemUUID is null

Learn More