I_MDChgProcModifdTablesEnhcd

DDL: I_MDCHGPROCMODIFDTABLESENHCD SQL: IMDCHGPROCMTABE Type: view COMPOSITE

MD Change Process Modified Tables

I_MDChgProcModifdTablesEnhcd is a Composite CDS View that provides data about "MD Change Process Modified Tables" in SAP S/4HANA. It reads from 2 data sources (I_MDChangeProcModifdTables, I_MDChgProcHistlModifdTables) and exposes 8 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessModelTableName, MDChgProcessStep, MDChgProcessModelTableName. It has 2 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_MDChangeProcModifdTables I_MDChangeProcModifdTables from
I_MDChgProcHistlModifdTables I_MDChgProcHistlModifdTables union

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
[0..*] I_MDChangeProcModelTableDesc _MDChangeProcModelTableDesc _MDChangeProcModelTableDesc.MDChgProcessModelTableName = $projection.MDChgProcessModelTableName

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMTABE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey MDChgProcessModelTableName view
VDM.viewType #COMPOSITE view
EndUserText.label MD Change Process Modified Tables view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessModelTableName MDChgProcessModelTableName
_MDChangeProcModelTableDesc _MDChangeProcModelTableDesc
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessModelTableName MDChgProcessModelTableName
_MDChangeProcModelTableDesc _MDChangeProcModelTableDesc
_MasterDataChangeProcessEnhcd _MasterDataChangeProcessEnhcd 
@AbapCatalog.sqlViewName: 'IMDCHGPROCMTABE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
//@Analytics.dataCategory: #DIMENSION

@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #S, dataClass: #CUSTOMIZING }
@ObjectModel.representativeKey: 'MDChgProcessModelTableName'
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'MD Change Process Modified Tables'
define view I_MDChgProcModifdTablesEnhcd
  as select from I_MDChangeProcModifdTables
  association [1..1] to I_MasterDataChangeProcessEnhcd as _MasterDataChangeProcessEnhcd on _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
  association [0..*] to I_MDChangeProcModelTableDesc   as _MDChangeProcModelTableDesc   on _MDChangeProcModelTableDesc.MDChgProcessModelTableName = $projection.MDChgProcessModelTableName
{
      //I_MDChangeProcModifdTables

  key MasterDataChangeProcess,

  key MDChgProcessStep,

      @ObjectModel.text.association:'_MDChangeProcModelTableDesc'
  key MDChgProcessModelTableName,


      /* Associations */
      // I_MDChgProcModifdTablesEnhcd

      _MDChangeProcModelTableDesc,
      _MasterDataChangeProcessEnhcd
}

union

select from I_MDChgProcHistlModifdTables
association [1..1] to I_MasterDataChangeProcessEnhcd as _MasterDataChangeProcessEnhcd on _MasterDataChangeProcessEnhcd.MasterDataChangeProcess = $projection.MasterDataChangeProcess
association [0..*] to I_MDChangeProcModelTableDesc   as _MDChangeProcModelTableDesc   on _MDChangeProcModelTableDesc.MDChgProcessModelTableName = $projection.MDChgProcessModelTableName
{
      //I_MDChangeProcModifdTables

  key MasterDataChangeProcess,

  key MDChgProcessStep,

      @ObjectModel.text.association:'_MDChangeProcModelTableDesc'
  key MDChgProcessModelTableName,


      /* Associations */
      // I_MDChgProcModifdTablesEnhcd

      _MDChangeProcModelTableDesc,
      _MasterDataChangeProcessEnhcd
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDCHANGEPROCMODIFDTABLES",
"I_MDCHGPROCHISTLMODIFDTABLES"
],
"ASSOCIATED":
[
"I_MASTERDATACHANGEPROCESSENHCD",
"I_MDCHANGEPROCMODELTABLEDESC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More