I_HZDSSUBSTINVENTORYDEFINITION

CDS View

HSI: Hazardous Sub. Inventory Definition

I_HZDSSUBSTINVENTORYDEFINITION is a CDS View in S/4HANA. HSI: Hazardous Sub. Inventory Definition. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_HzdsSubstInventoryFltrLocVH view inner CONSUMPTION HSI: Location Filter Value Help
C_HzdsSubstInventoryFreeLoc view inner CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view inner CONSUMPTION HSI: Location Value Help 
@AbapCatalog.sqlViewName: 'IHASSUBINVDEF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'HSI: Hazardous Sub. Inventory Definition'

@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog.buffering:{
  status: #ACTIVE,
  type: #SINGLE
}

@ObjectModel:
{
  usageType:
  {
    dataClass: #CUSTOMIZING,
    sizeCategory: #S,
    serviceQuality: #A
  }
}

define view I_HzdsSubstInventoryDefinition
  as select from ehhssc_hsi_def

  association [0..*] to I_HzdsSubstInvtryTonnageBand as _HzdsSubstInvtryTonnageBand on _HzdsSubstInvtryTonnageBand.TonnageBandSet = $projection.TonnageBandSet
{

  key plant                                                                        as Plant,

      cast( hzdssubstinventoryloctype  as ehfnd_loc_type_code_nc preserving type ) as HzdsSubstInventoryLocType,

      tonnagebandset                                                               as TonnageBandSet,

      ehsformname                                                                  as EHSFormName,

      /* Associations */
      _HzdsSubstInvtryTonnageBand

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSC_HSI_DEF"
],
"ASSOCIATED":
[
"I_HZDSSUBSTINVTRYTONNAGEBAND"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More