I_MDChangeProcessModelField

DDL: I_MDCHANGEPROCESSMODELFIELD SQL: IMDCHGPROCMDLFLD Type: view COMPOSITE

Process model field

I_MDChangeProcessModelField is a Composite CDS View that provides data about "Process model field" in SAP S/4HANA. It reads from 13 data sources and exposes 17 fields with key fields MDChgProcessSrchQueryAttribute, MDChgProcessSrceObjectTypeCode, MDChgProcessSrceObjectTypeCode, MDChgProcessSrceObjectTypeCode. It is exposed through 1 OData service (C_MASTERDATALOADFILETP_SRV).

13 data source(s) Exposed by 1 service(s) 17 fields

Data Sources (13)

SourceAliasJoin Type
I_MDChgProcModCstmFldPrpty _Custom left_outer
I_MDChgProcModCstmFldPrpty CustomField left_outer
dd03l dd03l left_outer
dd03l dd03l left_outer
dd04t dd04t left_outer
dd04t dd04t left_outer
I_MDChgProcModFieldProperty Field inner
I_MDChgProcModelFieldExtension ModelFieldExtension union
I_MDChangeProcessModelTable ModelTable left_outer
I_MDChangeProcModelSpecialFld SpecialField left_outer
I_MDChangeProcModelSpecialFld SpecialField inner
I_MDChangeProcessModelTable Table from
I_MDChangeProcessModelTable Table union

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMDLFLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Process model field view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
C_MASTERDATALOADFILETP_SRV C_MASTERDATALOADFILETP_V4 V4 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessSrchQueryAttribute Attribute
KEY MDChgProcessSrceObjectTypeCode I_MDChangeProcessModelTable MDChgProcessSrceObjectTypeCode
MDChgProcessModelTableName I_MDChangeProcessModelTable MDChgProcessModelTableName Table
MDChangeProcModelTableDesc I_MDChangeProcessModelTable MDChangeProcModelTableDesc Table Description
MDChangeProcessModelFieldName I_MDChgProcModFieldProperty MDChangeProcessModelFieldName Field
MDChangeProcessModelFieldDesc dd04t ddtext Field Description
KEY MDChgProcessSrceObjectTypeCode I_MDChgProcModelFieldExtension MDChgProcessSrceObjectTypeCode
MDChgProcessModelTableName I_MDChgProcModelFieldExtension MDChgProcessModelTableName Table
MDChangeProcModelTableDesc I_MDChangeProcessModelTable MDChangeProcModelTableDesc Table Description
MDChangeProcessModelFieldName I_MDChgProcModelFieldExtension MDChangeProcessModelFieldName Field
MDChangeProcessModelFieldDesc I_MDChgProcModelFieldExtension MDChangeProcessModelFieldDesc Field Description
KEY MDChgProcessSrceObjectTypeCode I_MDChangeProcModelSpecialFld MDChgProcessSrceObjectTypeCode
MDChgProcessModelTableName I_MDChangeProcModelSpecialFld MDChgProcModelActiveTableName Table
MDChangeProcModelTableDesc I_MDChangeProcessModelTable MDChangeProcModelTableDesc Table Description
MDChangeProcessModelFieldName I_MDChangeProcModelSpecialFld MDChangeProcessModelFieldName Field
MDChangeProcessModelFieldDesc dd04t ddtext Field Description
IsKeyField dd03l keyflag 
@AbapCatalog.sqlViewName: 'IMDCHGPROCMDLFLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Process model field'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true
define view I_MDChangeProcessModelField
  as select from    I_MDChangeProcessModelTable   as Table
    inner join      I_MDChgProcModFieldProperty   as Field        on  Field.MDChgProcessSrceObjectTypeCode = Table.MDChgProcessSrceObjectTypeCode
                                                                  and Field.MDChgProcessModelTableName = Table.MDChgProcessModelTableName
    left outer join I_MDChangeProcModelSpecialFld as SpecialField on  SpecialField.MDChgProcessSrceObjectTypeCode = Field.MDChgProcessSrceObjectTypeCode
                                                                  and SpecialField.MDChgProcessModelTableName     = Field.MDChgProcessModelTableName
                                                                  and SpecialField.MDChangeProcessModelFieldName  = Field.MDChangeProcessModelFieldName
    left outer join dd03l                         as dd03l        on  (
               dd03l.tabname                                                          = Table.MDChgProcessModelTableName
//               or dd03l.tabname                                                       = SpecialField.MDChgProcModelActiveTableName

             )
                                                                  and dd03l.fieldname = Field.MDChangeProcessModelFieldName
                                                                  and dd03l.as4local  = 'A'
                                                                  and dd03l.as4vers   = '0000'
    left outer join I_MDChgProcModCstmFldPrpty    as CustomField  on  CustomField.MDChgProcessSrceObjectTypeCode    = Table.MDChgProcessSrceObjectTypeCode
                                                                  and CustomField.MDChgProcessModelTableName = Table.MDChgProcessModelTableName
                                                                  and CustomField.MDChangeProcessModelFieldName = Field.MDChangeProcessModelFieldName
                                                                  and CustomField.client     = $session.client
    left outer join dd04t                         as dd04t        on  dd04t.rollname   = dd03l.rollname
                                                                  and dd04t.as4local   = dd03l.as4local
                                                                  and dd04t.as4vers    = dd03l.as4vers
                                                                  and dd04t.ddlanguage = $session.system_language
{
      //  key $session.client as mandt,

      @EndUserText.label: 'Attribute'
      @ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
  key cast ( concat(concat(Table.MDChgProcessModelTableName, '-'), Field.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
      @Consumption.filter.hidden: true
  key Table.MDChgProcessSrceObjectTypeCode                                                                           as MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      Table.MDChgProcessModelTableName                                                                               as MDChgProcessModelTableName,
      @EndUserText.label: 'Table Description'
      Table.MDChangeProcModelTableDesc                                                                               as MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      Field.MDChangeProcessModelFieldName                                                                                               as MDChangeProcessModelFieldName,
      @EndUserText.label: 'Field Description'
      @Semantics.text: true
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
      dd04t.ddtext                                                                                                   as MDChangeProcessModelFieldDesc,
      @UI.hidden : true
      dd03l.keyflag                                                                                                  as IsKeyField
}
where
  (
        CustomField.MDChgProcModelFieldIsObscured  is initial
    or  CustomField.MDChgProcModelFieldIsObscured  is null
    and Field.MDChgProcModelFieldIsObscured        is initial
  )
  and(
        CustomField.MDChgProcModelFieldIsTechnical is initial
    or  CustomField.MDChgProcModelFieldIsTechnical is null
    and Field.MDChgProcModelFieldIsTechnical       is initial
  )
//  and   Table.MDChgProcessSrceObjectTypeCode = '147'


union select from I_MDChgProcModelFieldExtension as ModelFieldExtension
  left outer join I_MDChgProcModCstmFldPrpty     as _Custom    on  _Custom.MDChgProcessSrceObjectTypeCode    = ModelFieldExtension.MDChgProcessSrceObjectTypeCode
                                                               and _Custom.MDChgProcessModelTableName = ModelFieldExtension.MDChgProcessModelTableName
                                                               and _Custom.MDChangeProcessModelFieldName = ModelFieldExtension.MDChangeProcessModelFieldName
                                                               and _Custom.client     = $session.client
  left outer join I_MDChangeProcessModelTable    as ModelTable on  ModelFieldExtension.MDChgProcessModelTableName     = ModelTable.MDChgProcessModelTableName
                                                               and ModelFieldExtension.MDChgProcessSrceObjectTypeCode = ModelTable.MDChgProcessSrceObjectTypeCode
{
      @EndUserText.label: 'Attribute'
      @ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
  key cast ( concat(concat(
        ModelFieldExtension.MDChgProcessModelTableName
        , '-'), ModelFieldExtension.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
      @Consumption.filter.hidden: true
  key ModelFieldExtension.MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      ModelFieldExtension.MDChgProcessModelTableName,
      @EndUserText.label: 'Table Description'
      ModelTable.MDChangeProcModelTableDesc                                                        as MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      ModelFieldExtension.MDChangeProcessModelFieldName,
      @EndUserText.label: 'Field Description'
      @Semantics.text: true
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
      ModelFieldExtension.MDChangeProcessModelFieldDesc,
      @UI.hidden : true
      cast( '' as char1 preserving type )                                                          as IsKeyField
}
where
  //      ModelFieldExtension.MDChgProcessSrceObjectTypeCode = '147' and

  _Custom.MDChangeProcessModelFieldName is null

union select from I_MDChangeProcessModelTable   as Table
  inner join      I_MDChangeProcModelSpecialFld as SpecialField on  Table.MDChgProcessSrceObjectTypeCode = SpecialField.MDChgProcessSrceObjectTypeCode
                                                                and Table.MDChgProcessModelTableName     = SpecialField.MDChgProcessModelTableName
  left outer join dd03l                         as dd03l        on  dd03l.tabname   = SpecialField.MDChgProcModelActiveTableName
                                                                and dd03l.fieldname = SpecialField.MDChangeProcessModelFieldName
                                                                and dd03l.as4local  = 'A'
                                                                and dd03l.as4vers   = '0000'
  left outer join dd04t                         as dd04t        on  dd04t.rollname   = dd03l.rollname
                                                                and dd04t.as4local   = dd03l.as4local
                                                                and dd04t.as4vers    = dd03l.as4vers
                                                                and dd04t.ddlanguage = $session.system_language
{
      //  key $session.client as mandt,

      @EndUserText.label: 'Attribute'
      @ObjectModel.text.element: ['MDChangeProcessModelFieldDesc']
  key cast ( concat(concat(SpecialField.MDChgProcModelActiveTableName, '-'), SpecialField.MDChangeProcessModelFieldName) as mdc_search_query_attribute ) as MDChgProcessSrchQueryAttribute,
      @Consumption.filter.hidden: true
  key SpecialField.MDChgProcessSrceObjectTypeCode                                                                                                        as MDChgProcessSrceObjectTypeCode,
      @EndUserText.label: 'Table'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      SpecialField.MDChgProcModelActiveTableName                                                                                                         as MDChgProcessModelTableName,
      @EndUserText.label: 'Table Description'
      Table.MDChangeProcModelTableDesc                                                                                                                   as MDChangeProcModelTableDesc,
      @EndUserText.label: 'Field'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #MEDIUM}
      SpecialField.MDChangeProcessModelFieldName                                                                                                         as MDChangeProcessModelFieldName,
      @EndUserText.label: 'Field Description'
      @Semantics.text: true
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH}
      dd04t.ddtext                                                                                                                                       as MDChangeProcessModelFieldDesc,
      @UI.hidden : true
      dd03l.keyflag                                                                                                                                      as IsKeyField
}

Learn More