I_SAMPLINGDEFINITIONROOT

CDS View

Sampling Definition Root

I_SAMPLINGDEFINITIONROOT is a CDS View in S/4HANA. Sampling Definition Root. It contains 5 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 5 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_SamplingDefinitionRoot view from CONSUMPTION Sampling
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EnvrmtAmountsForActivity view inner COMPOSITE Amounts for Activities

Fields (5)

KeyField CDS FieldsUsed in Views
_EHSDataPeriod _EHSDataPeriod 1
_EHSLocation _EHSLocation 1
DataUsagePeriodicity DataUsagePeriodicity 1
EHSLocationUUID EHSLocationUUID 2
SamplingDefinitionName EHSComplianceScenActivityName 1 
@AbapCatalog.sqlViewName: 'ISDEFROOT'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Sampling Definition Root'

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

define view I_SamplingDefinitionRoot
  as select from ehenvd_sdef_root
  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
  association [1..*] to I_SamplingReference   as _SamplingReference on $projection.SamplingDefinitionUUID = _SamplingReference.SamplingDefinitionUUID
  association [1..*] to I_SamplingHeader      as _SamplingHeader    on $projection.SamplingDefinitionUUID = _SamplingHeader.SamplingDefinitionUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
  association [1..1] to I_EHSLocationRevision as _EHSLocation       on $projection.EHSLocationUUID     = _EHSLocation.EHSLocationUUID
                                                                    and(
                                                                      _EHSLocation.RevisionStartDate   <= $session.system_date
                                                                      and _EHSLocation.RevisionEndDate >= $session.system_date
                                                                    )
  association [0..1] to I_EHSDataPeriod as _EHSDataPeriod           on $projection.DataUsagePeriodicity = _EHSDataPeriod.EHSDataPeriod
{
  key db_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,

      name                                                                as  SamplingDefinitionName,
      cast( '' as abap.char(3) )                                          as  DataUsagePeriodicity,
      
      migration_src                                                       as  SamplingDefMigrationSource,

      subject_type_code                                                   as  EHSSubjectType,
      subject_root_key_ref                                                as  EHSSubjectUUID,

      @ObjectModel.foreignKey.association: '_EHSLocation'
      cast( loc_root_key_ref as ehfnd_location_uuid_ref preserving type ) as  EHSLocationUUID,
      _EHSLocation,
      _SamplingHeader,
      _SamplingReference,
      _EHSDataPeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHENVD_SDEF_ROOT"
],
"ASSOCIATED":
[
"I_EHSDATAPERIOD",
"I_EHSLOCATIONREVISION",
"I_SAMPLINGHEADER",
"I_SAMPLINGREFERENCE",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More