I_SAMPLINGREFERENCE

CDS View

Sampling Definition - SamplingRef

I_SAMPLINGREFERENCE is a CDS View in S/4HANA. Sampling Definition - SamplingRef. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_SamplingDefinitionRoot view inner CONSUMPTION Sampling
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity

Fields (1)

KeyField CDS FieldsUsed in Views
KEY SamplingUUID SamplingUUID 1 
@AbapCatalog.sqlViewName: 'ISDEFSAMP'
@VDM.viewType: #BASIC
@EndUserText.label: 'Sampling Definition - SamplingRef'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view I_SamplingReference
as select from ehenvd_sdef_samp
 association [0..1] to I_User        as _CreatedByUser     on $projection.CreatedByUser = _CreatedByUser.UserID
 association [0..1] to I_User        as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID
{
  
  key db_key                                                              as  SamplingReferenceUUID,
  key parent_key                                                          as  SamplingDefinitionUUID,
      //admin fields

      datetime_cr                                                         as  CreationDateTime,
      user_id_cr                                                          as  CreatedByUser,
      _CreatedByUser,
      datetime_ch                                                         as  LastChangeDateTime,
      user_id_ch                                                          as  LastChangedByUser,
      _LastChangedByUser,
      
      sampling_key_ref                                                    as  SamplingUUID

}

Learn More