I_EHSLOCATIONSTORAGELOCATION

CDS View

EHS Location Storage Location

I_EHSLOCATIONSTORAGELOCATION is a CDS View in S/4HANA. EHS Location Storage Location. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_HzdsSubstInvtryProdQty view inner COMPOSITE HSI: Product Quantitiy
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION Private view for proposed substances for the HSI 
@EndUserText.label: 'EHS Location Storage Location'
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'EHSLocationStorageLocationUUID'
@AccessControl.authorizationCheck: #CHECK

@AbapCatalog.sqlViewName: 'ILOCSL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

// support for read access logging

@Metadata.allowExtensions:true

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE


// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #B,        // < 15 msec

                         sizeCategory:  #M,         // < 100.000

                         dataClass: #MASTER }

define view I_EHSLocationStorageLocation
  as select from ehfndd_loc_sl
  
  association [0..1] to I_Plant                    as _Plant               on  $projection.Plant = _Plant.Plant
  association [0..1] to I_StorageLocation          as _StorageLocation     on  $projection.StorageLocation = _StorageLocation.StorageLocation
                                                                           and $projection.Plant           = _StorageLocation.Plant
  
  association [0..1] to I_EHSLocationRevision      as _EHSLocationRevision on  $projection.EHSLocationRevisionUUID = _EHSLocationRevision.EHSLocationRevisionUUID
  association [0..1] to I_EHSLocationRoot          as _EHSLocationRoot     on  $projection.EHSLocationUUID = _EHSLocationRoot.EHSLocationUUID
  
  
{
  key  cast( db_key  as ehfnd_location_uuid_ref  preserving type )      as EHSLocationStorageLocationUUID,

       root_key                                                         as EHSLocationUUID,
       parent_key                                                       as EHSLocationRevisionUUID,
       
       @ObjectModel.foreignKey.association: '_Plant'
       plant_id                                                                                        as Plant,
       _Plant,
       @ObjectModel.foreignKey.association: '_StorageLocation'
       storage_loc                                                                                     as StorageLocation,
       _StorageLocation,
       
       _EHSLocationRevision,
       _EHSLocationRoot

}

Learn More