I_DataCollectionRootBasic

DDL: I_DATACOLLECTIONROOTBASIC SQL: IMDEFROOTB Type: view BASIC

Data Collection Root

I_DataCollectionRootBasic is a Basic CDS View that provides data about "Data Collection Root" in SAP S/4HANA. It reads from 1 data source (ehenvd_mdef_root) and exposes 19 fields with key field DataCollectionUUID. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
ehenvd_mdef_root ehenvd_mdef_root from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EHSLocationRevision _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID and( _EHSLocation.RevisionStartDate <= $session.system_date and _EHSLocation.RevisionEndDate >= $session.system_date )
[0..1] I_EHSDataPeriod _EHSDataPeriod $projection.DataUsagePeriodicity = _EHSDataPeriod.EHSDataPeriod

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDEFROOTB view
EndUserText.label Data Collection Root view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DataCollectionUUID db_key
CreationDateTime
LastChangeDateTime
CreatedByUser user_id_cr
LastChangedByUser user_id_ch
DataCollectionID id
DataCollectionName name
DataCollectionInputMethod input_method
EHSAmountExternalSource tag_id
DataUsagePeriodicity
UnitOfMeasure
EHSAltvUnitOfMeasurement
EHSSubjectType subject_type_code
EHSSubjectUUID subject_root_key_ref
DataCollectionTitle title
DataCollectionMigrationSource migration_src
EHSLocationUUID
_EHSLocation _EHSLocation
_EHSDataPeriod _EHSDataPeriod 
@AbapCatalog.sqlViewName: 'IMDEFROOTB'
@EndUserText.label: 'Data Collection Root'
@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

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

define view I_DataCollectionRootBasic
  as select from ehenvd_mdef_root
  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 DataCollectionUUID,
      cast( datetime_cr as ehfnd_datetime_cr preserving type )            as CreationDateTime,
      cast( datetime_ch as ehfnd_datetime_ch preserving type )            as LastChangeDateTime,
      user_id_cr                                                          as CreatedByUser,
      user_id_ch                                                          as LastChangedByUser,
      id                                                                  as DataCollectionID,
      name                                                                as DataCollectionName,
      input_method                                                        as DataCollectionInputMethod,
      tag_id                                                              as EHSAmountExternalSource,
      cast( mdef_period as ehenv_mdef_period_code_nc preserving type )    as DataUsagePeriodicity,
      cast( unit as ehfnd_unit_code_nce preserving type )                 as UnitOfMeasure,
      cast( unit_alt as ehfnd_unit_code_nce preserving type )             as EHSAltvUnitOfMeasurement,

      subject_type_code                                                   as EHSSubjectType,
      subject_root_key_ref                                                as EHSSubjectUUID,
      title                                                               as DataCollectionTitle,
      migration_src                                                       as DataCollectionMigrationSource,
      cast( loc_root_key_ref as ehfnd_location_uuid_ref preserving type ) as EHSLocationUUID,

      _EHSLocation,
      _EHSDataPeriod
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHENVD_MDEF_ROOT"
],
"ASSOCIATED":
[
"I_EHSDATAPERIOD",
"I_EHSLOCATIONREVISION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More