C_EHSDataCollectionDEX

DDL: C_EHSDATACOLLECTIONDEX Type: view_entity CONSUMPTION

Data Collection Data Extraction

C_EHSDataCollectionDEX is a Consumption CDS View (Dimension) that provides data about "Data Collection Data Extraction" in SAP S/4HANA. It reads from 1 data source (I_DataCollectionRootBasic) and exposes 13 fields with key field DataCollectionUUID. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_DataCollectionRootBasic I_DataCollectionRootBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSLocationRevisionBasic _EHSLocationRevisionBasic $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Data Collection Data Extraction view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.internalName #LOCAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DataCollectionUUID DataCollectionUUID
DataCollectionID DataCollectionID
DataCollectionName DataCollectionName
DataCollectionInputMethod DataCollectionInputMethod
EHSAmountExternalSource EHSAmountExternalSource
DataUsagePeriodicity DataUsagePeriodicity
UnitOfMeasure UnitOfMeasure
EHSSubjectType EHSSubjectType
EHSSubjectUUID EHSSubjectUUID
DataCollectionTitle DataCollectionTitle
DataCollectionMigrationSource DataCollectionMigrationSource
EHSLocationUUID EHSLocationUUID
_EHSLocationRevisionBasic _EHSLocationRevisionBasic 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Data Collection Data Extraction'
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
@VDM.viewType: #CONSUMPTION
@Analytics.dataExtraction.enabled:true
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction.delta.changeDataCapture.automatic: true
@Analytics.internalName:#LOCAL
define view entity C_EHSDataCollectionDEX
  as select from I_DataCollectionRootBasic
  association [0..*] to I_EHSLocationRevisionBasic as _EHSLocationRevisionBasic on $projection.EHSLocationUUID = _EHSLocationRevisionBasic.EHSLocationUUID
{
  key DataCollectionUUID,
      DataCollectionID,
      DataCollectionName,
      DataCollectionInputMethod,
      EHSAmountExternalSource,
      DataUsagePeriodicity,
      UnitOfMeasure,
      EHSSubjectType,
      EHSSubjectUUID,
      DataCollectionTitle,
      DataCollectionMigrationSource,
      EHSLocationUUID,

      // Required for DCL

      _EHSLocationRevisionBasic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DATACOLLECTIONROOTBASIC"
],
"ASSOCIATED":
[
"I_EHSLOCATIONREVISIONBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More