I_EHSCmplncScenDataColl

DDL: I_EHSCMPLNCSCENDATACOLL SQL: IEHSCMPLSCENCOLL Type: view BASIC

EHS Compliance Scenario Data Collection

I_EHSCmplncScenDataColl is a Basic CDS View that provides data about "EHS Compliance Scenario Data Collection" in SAP S/4HANA. It reads from 1 data source (ehenvd_scen_meas) and exposes 8 fields with key fields EHSCmplncScenDataCollUUID, EHSComplianceScenarioRootUUID.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
ehenvd_scen_meas ehenvd_scen_meas from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEHSCMPLSCENCOLL view
EndUserText.label EHS Compliance Scenario Data Collection view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter 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 (8)

KeyFieldSource TableSource FieldDescription
KEY EHSCmplncScenDataCollUUID db_key
KEY EHSComplianceScenarioRootUUID parent_key
CreationDateTime datetime_cr
LastChangeDateTime datetime_ch
CreatedByUser user_id_cr
LastChangedByUser user_id_ch
DataCollectionUUID mdef_root_key_ref
ActyIsOwndByEHSCmplncScen is_owned_indicator 
@AbapCatalog.sqlViewName: 'IEHSCMPLSCENCOLL'
@EndUserText.label: 'EHS Compliance Scenario Data Collection'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true

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


define view I_EHSCmplncScenDataColl
  as select from ehenvd_scen_meas   
 {
       
  key db_key                                as  EHSCmplncScenDataCollUUID,
  key parent_key                            as  EHSComplianceScenarioRootUUID,

  //admin fields

    @Semantics.systemDate.createdAt: true
    datetime_cr                             as  CreationDateTime,
    @Semantics.systemDate.lastChangedAt: true
    datetime_ch                             as  LastChangeDateTime,
    @Semantics.user.createdBy: true
    user_id_cr                              as  CreatedByUser,
    @Semantics.user.lastChangedBy: true
    user_id_ch                              as  LastChangedByUser,
    // association

  //  _LastChangedByUser,

    
    mdef_root_key_ref                       as DataCollectionUUID,
    
    is_owned_indicator                      as ActyIsOwndByEHSCmplncScen
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHENVD_SCEN_MEAS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More