I_SAFETYINSTRUCTIONDEFINITION

CDS View

FSI: Safety Instruction Definition

I_SAFETYINSTRUCTIONDEFINITION is a CDS View in S/4HANA. FSI: Safety Instruction Definition. It contains 3 fields. 17 CDS views read from this table.

Used by 17 CDS view(s) 3 fields

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_EquipSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Area for Safety Instruction for Equipment
C_EquipSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Equipment
C_GnrcSftyInstrnAreaFltrVH view inner CONSUMPTION Factory location areas for generic safety instruction
C_GnrcSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Generic Safety Instruction
C_GnrcSftyInstrnFactoryFltrVH view inner CONSUMPTION Factory locations for generic safety instruction
C_SafetyInstrnEquipmentFltrVH view inner CONSUMPTION SI: Equipment Value Help for Filter Bar
C_SafetyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction
C_SafetyInstrnFactoryByPlantVH view inner CONSUMPTION Value Help for Factories by SI Structure
C_SafetyInstructionEquipmentVH view inner CONSUMPTION SI: Equipment Value Help
C_SafetyInstructionFactoryVH view inner CONSUMPTION HSI: Location Value Help
C_SftyInstrnFactoryAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction
C_SubstSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction for Substance
C_SubstSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Substance
I_ReldSftyInstrnFactoryVH view_entity inner COMPOSITE Factories for Safety Instruction
I_ReldSftyInstrnFctryAreaVH view_entity inner COMPOSITE Factory Areas for Safety Instruction
I_SafetyInstrnStructureByPlant view inner BASIC Interface View to get SI Structure by Plant
P_SftyInstrnTextBlockFactory view inner CONSUMPTION

Fields (3)

KeyField CDS FieldsUsed in Views
KEY SafetyInstructionSubType SafetyInstructionSubType 13
KEY SafetyInstructionType SafetyInstructionType 13
SafetyInstructionStructure SafetyInstructionStructure 2 
@EndUserText.label: 'FSI: Safety Instruction Definition'

@AbapCatalog.sqlViewName: 'IHSSFSIDEF'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

define view I_SafetyInstructionDefinition
  as select from ehhssc_fsi_def
{

  key plant                                                                       as Plant,
  key cast( 'SUBST' as ehhss_fsi_type preserving type )                           as SafetyInstructionType,
  key cast( '   ' as ehhss_fsi_subtype preserving type )                          as SafetyInstructionSubType,
      cast( safetyinstructionloctype  as ehfnd_loc_type_code_nc preserving type ) as SafetyInstructionLocType,
      safetyinstructionstructure                                                  as SafetyInstructionStructure,
      ehsformname                                                                 as EHSFormName,
      ehsoutpmgmtformname                                                         as EHSOutpMgmtFormName

}

union all select from ehhssc_fsi_ds02
{

  key plant                                                                       as Plant,
  key cast( 'SUBST' as ehhss_fsi_type preserving type )                           as SafetyInstructionType,
  key cast( 'S02' as ehhss_fsi_subtype preserving type )                          as SafetyInstructionSubType,
      cast( safetyinstructionloctype  as ehfnd_loc_type_code_nc preserving type ) as SafetyInstructionLocType,
      safetyinstructionstructure                                                  as SafetyInstructionStructure,
      ''                                                                          as EHSFormName,
      ehsoutpmgmtformname                                                         as EHSOutpMgmtFormName

}

union all select from ehhssc_fsi_deqp
{

  key plant                                                                       as Plant,
  key cast( 'EQUIP' as ehhss_fsi_type preserving type )                           as SafetyInstructionType,
  key cast( '   ' as ehhss_fsi_subtype preserving type )                          as SafetyInstructionSubType,
      cast( safetyinstructionloctype  as ehfnd_loc_type_code_nc preserving type ) as SafetyInstructionLocType,
      safetyinstructionstructure                                                  as SafetyInstructionStructure,
      ehsformname                                                                 as EHSFormName,
      ehsoutpmgmtformname                                                         as EHSOutpMgmtFormName

}

union all select from ehhssc_fsi_dgen
{

  key plant                                                                       as Plant,
  key cast( 'GENRC' as ehhss_fsi_type preserving type )                           as SafetyInstructionType,
  key safetyinstructionsubtype                                                    as SafetyInstructionSubType,
      cast( safetyinstructionloctype  as ehfnd_loc_type_code_nc preserving type ) as SafetyInstructionLocType,
      safetyinstructionstructure                                                  as SafetyInstructionStructure,
      ehsformname                                                                 as EHSFormName,
      ehsoutpmgmtformname                                                         as EHSOutpMgmtFormName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSC_FSI_DEF",
"EHHSSC_FSI_DEQP",
"EHHSSC_FSI_DGEN",
"EHHSSC_FSI_DS02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More