I_EDCDataSourceFieldDetail

DDL: I_EDCDATASOURCEFIELDDETAIL Type: view_entity BASIC Package: GLO-EDO-EDC

EDC Check Data Source Field Description

I_EDCDataSourceFieldDetail is a Basic CDS View that provides data about "EDC Check Data Source Field Description" in SAP S/4HANA. It reads from 2 data sources (dd03nd, dd04t) and exposes 5 fields with key fields EDCDataSourceName, EDCDataSourceFieldName. Part of development package GLO-EDO-EDC.

Data Sources (2)

SourceAliasJoin Type
dd03nd CDSDataSource from
dd04t DataElementDescription inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EDC Check Data Source Field Description view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EDCDataSourceName dd03nd strucobjn
KEY EDCDataSourceFieldName dd03nd fieldname
EDCDataSourceIsKeyField dd03nd keyflag
EDCDataSourceFieldDescription dd04t scrtext_l
Language dd04t ddlanguage
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EDC Check Data Source Field Description'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType:#BASIC
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #XXL,
  dataClass: #MASTER
}
define view entity I_EDCDataSourceFieldDetail
  as select from dd03nd as CDSDataSource
    inner join   dd04t  as DataElementDescription on CDSDataSource.rollname = DataElementDescription.rollname
{
  key CDSDataSource.strucobjn           as EDCDataSourceName,
  key CDSDataSource.fieldname           as EDCDataSourceFieldName,
      CDSDataSource.keyflag             as EDCDataSourceIsKeyField,
      DataElementDescription.scrtext_l  as EDCDataSourceFieldDescription,
      DataElementDescription.ddlanguage as Language
}
where
      CDSDataSource.nodename            = '.NODE1'
  and CDSDataSource.as4local            = 'A'
  and DataElementDescription.as4local   = 'A'
  and DataElementDescription.ddlanguage = $session.system_language