I_HZDSSUBSTINVENTORY

CDS View

HSI: Interface View

I_HZDSSUBSTINVENTORY is a CDS View in S/4HANA. HSI: Interface View. It contains 4 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 4 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_ChemicalOfHzdsSubstInvtryVH view inner CONSUMPTION Chemical from hazardous substance inventory value help
C_HzdsSubstInventoryFreeLoc view left_outer CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view left_outer CONSUMPTION HSI: Location Value Help
I_BldngForHzdsSubstInvtryActv view from COMPOSITE HSI: Buildings belong to active HSI
I_HzdsSubstInventoryCountry view from BASIC Hazardous Substance Inventory Country
I_HzdsSubstInventoryTP view from TRANSACTIONAL HSI: Transactional View
I_SftyRlvtChgAffcdObjAddlInfo view inner COMPOSITE SRC: Affected Object Additional Info
I_SftyRlvtChgAffcdObjUser view left_outer COMPOSITE SRC: Relevant Affected Objects for Users
I_SftyRlvtChgAffcdObjUser_2 view inner COMPOSITE SRC: Relevant Affected Objects for Users
P_FactoryJargonForSubstance view from COMPOSITE Factory Jargon for Chemicals

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CreatedByUser SafetyRelevantChgNotifProcgUsr 1
KEY EHSLocationUUID EHSLocationUUID 2
HzdsSubstInventoryStatus HzdsSubstInventoryStatus 2
HzdsSubstInventoryUUID HzdsSubstInventoryUUID,SftyRlvtChgAffcdObjRelatedUUID 2 
@EndUserText.label: 'HSI: Interface View'

@AbapCatalog: { sqlViewName: 'IHASSUBINV',
                compiler.compareFilter: true,
                preserveKey: true }
@AccessControl.authorizationCheck: #CHECK


@VDM.viewType: #BASIC

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #B
  }
}

define view I_HzdsSubstInventory
  as select from ehhssv_hsi_root
  association [0..*] to I_HzdsSubstInventoryItem     as _HzdsSubstInventoryItem on  $projection.HzdsSubstInventoryUUID = _HzdsSubstInventoryItem.HzdsSubstInventoryUUID

  association [1..1] to I_EHSLocation                as _EHSLocation            on  $projection.EHSLocationUUID    = _EHSLocation.EHSLocationUUID
                                                                                and _EHSLocation.RevisionStartDate <= $session.system_date
                                                                                and _EHSLocation.RevisionEndDate   > $session.system_date

  association [0..1] to I_CurrentEHSLocationNameText as _EHSLocationName        on  $projection.EHSLocationUUID = _EHSLocationName.EHSLocationUUID
                                                                                and _EHSLocationName.Language   = $session.system_language

{
  key hzdssubstinventoryuuid                                                  as HzdsSubstInventoryUUID,

      ehslocationuuid                                                         as EHSLocationUUID, //ehhssd_hsi_root

      hzdssubstinventorystatus                                                as HzdsSubstInventoryStatus,
      hzdssubstinvtryrelutcdatetime                                           as HzdsSubstInvtryRelUTCDateTime,
      releasedbyuser                                                          as ReleasedByUser,
      hzdssubstinventorynote                                                  as HzdsSubstInventoryNote,

      case
        when hzdssubstinventorymjrrevision = '000' then '0'
        else ltrim(hzdssubstinventorymjrrevision, '0')
      end                                                                     as HzdsSubstInventoryMjrRevision,

      case
        when hzdssubstinventorymnrrevision = '000' then '0'
        else ltrim(hzdssubstinventorymnrrevision, '0')
      end                                                                     as HzdsSubstInventoryMnrRevision,

      hzdssubstinvtrycalcisrunning                                            as HzdsSubstInvtryCalcIsRunning,
      @Semantics.systemDateTime.createdAt: true
      cast(creationutcdatetime as ehfnd_bo_crea_date_time preserving type )   as CreationUTCDateTime,
      @Semantics.user.createdBy: true
      cast(createdbyuser as ehfnd_bo_crea_uname preserving type )             as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      cast(lastchangeutcdatetime as ehfnd_bo_lchg_date_time preserving type ) as LastChangeUTCDateTime,
      @Semantics.user.lastChangedBy: true
      cast(lastchangedbyuser as ehfnd_bo_lchg_uname preserving type )         as LastChangedByUser,

      hzdssubstinvtrymigrationsource                                          as HzdsSubstInvtryMigrationSource,

      /*Association*/
      _HzdsSubstInventoryItem,

      _EHSLocation,
      _EHSLocationName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSV_HSI_ROOT"
],
"ASSOCIATED":
[
"I_CURRENTEHSLOCATIONNAMETEXT",
"I_EHSLOCATION",
"I_HZDSSUBSTINVENTORYITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More