I_DATACOLLECTIONROOTBASIC

CDS View

Data Collection Root

I_DATACOLLECTIONROOTBASIC is a CDS View in S/4HANA. Data Collection Root. It contains 7 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 7 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_EHSDataCollectionDEX view_entity from CONSUMPTION Data Collection Data Extraction
I_DataCollectionRoot view from COMPOSITE Data Collection Root
I_EHSAmountExternalSource view from BASIC External Source
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EHSDataSet view from COMPOSITE Data Sets

Fields (7)

KeyField CDS FieldsUsed in Views
KEY DataCollectionUUID EHSComplianceScenActivityUUID 2
_EHSDataPeriod _EHSDataPeriod 1
_EHSLocation _EHSLocation 1
DataCollectionID EHSComplianceScenActivityID 1
DataCollectionName EHSClassifiedDataName,EHSComplianceScenActivityName 2
DataCollectionTitle EHSClassifiedDataTitle,EHSComplianceScenActivityTitle 2
EHSLocationUUID EHSLocationUUID 2 
@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