I_MDChangeProcessSourceEnhcd

DDL: I_MDCHANGEPROCESSSOURCEENHCD SQL: IMDCHGPROCSRCEE Type: view COMPOSITE Package: MDC_ANALYTICS

Master Data Change Process Source

I_MDChangeProcessSourceEnhcd is a Composite CDS View (Dimension) that provides data about "Master Data Change Process Source" in SAP S/4HANA. It reads from 1 data source (I_MDChangeProcessSource) and exposes 3 fields with key field MasterDataChangeProcess. It has 1 association to related views. Part of development package MDC_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_MDChangeProcessSource I_MDChangeProcessSource from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCSRCEE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.representativeKey MasterDataChangeProcess view
EndUserText.label Master Data Change Process Source view
Metadata.allowExtensions true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
MDChgProcessNmbrOfSrceRecords
_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd
@AbapCatalog.sqlViewName: 'IMDCHGPROCSRCEE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: { sizeCategory: #L, dataClass: #TRANSACTIONAL, serviceQuality: #D }
@ObjectModel.representativeKey: 'MasterDataChangeProcess'
@EndUserText.label: 'Master Data Change Process Source'
@Metadata.allowExtensions:true
define view I_MDChangeProcessSourceEnhcd
  as select from I_MDChangeProcessSource
  association [1..1] to I_MasterDataChangeProcessEnhcd as _MasterDataChangeProcessEnhcd on _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
{
      // keys

      // I_MDChangeProcessSource

  key MasterDataChangeProcess,
      //  key MDChgProcessSrceSystem,

      //  key MDChgProcessSrceStatus,

      //  key MDChgProcessSrceFilter,


      @DefaultAggregation: #SUM
      sum (MDChgProcessNmbrOfSrceRecords) as MDChgProcessNmbrOfSrceRecords,

      //I_MDChangeProcessSourceEnhcd

      _MasterDataChangeProcessEnhcd

}

group by
  MasterDataChangeProcess