I_MDQltyBusRuleChangeDocument

DDL: I_MDQLTYBUSRULECHANGEDOCUMENT SQL: IMDQBSRULECD Type: view BASIC

Master Data Quality Business Rule Change Document

I_MDQltyBusRuleChangeDocument is a Basic CDS View that provides data about "Master Data Quality Business Rule Change Document" in SAP S/4HANA. It reads from 1 data source (cdhdr) and exposes 11 fields with key fields MDQltyBusRuleChangeDocument, MDQltyBusRuleChgDocDtbsTable, MDQltyBusRuleChgDocDtbsTblKey, MDQltyBusRuleChgDocDtbsTblFld, MDQltyBusRuleChgDocItmChgType.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
cdhdr cdhdr from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMDQBSRULECD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey MDQltyBusRuleChangeDocument view
VDM.viewType #BASIC view
EndUserText.label Master Data Quality Business Rule Change Document view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MDQltyBusRuleChangeDocument cdhdr changenr
KEY MDQltyBusRuleChgDocDtbsTable cdpos tabname
KEY MDQltyBusRuleChgDocDtbsTblKey cdpos tabkey
KEY MDQltyBusRuleChgDocDtbsTblFld cdpos fname
KEY MDQltyBusRuleChgDocItmChgType cdpos chngind
KEY MDQltyBusRuleChgDocChgGroup _map chnggrp
KEY MDQltyBusRuleChgDocChgActy _map activity
clientNULLasMDQltyBusRuleChgDocDateTime
UserID cdhdr username
MDQltyBusRuleChgDocPrevFldVal cdpos value_old
MDQltyBusRuleChgDocNewFldVal cdpos value_new 
@AbapCatalog.sqlViewName: 'IMDQBSRULECD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: { dataClass: #MASTER, serviceQuality: #C, sizeCategory: #L }
@ObjectModel.representativeKey: 'MDQltyBusRuleChangeDocument'
@VDM.viewType: #BASIC
@EndUserText.label: 'Master Data Quality Business Rule Change Document'
define view I_MDQltyBusRuleChangeDocument
  as select from            cdhdr
    left outer to many join cdpos                   on  cdhdr.objectclas   = cdpos.objectclas
                                                    and cdhdr.objectid     = cdpos.objectid
                                                    and cdhdr.changenr     = cdpos.changenr
                                                    and (
                                                       cdhdr.objectclas    = 'MDQ_BUS_RULE'
                                                       or cdhdr.objectclas = 'MDQ_DIMN_CAT'
                                                     )
    left outer to many join mdq_rule_cdgroup as _map on  _map.chngind = cdpos.chngind
                                                    and _map.tabname = cdpos.tabname
                                                    and _map.fname   = cdpos.fname
{
      @ObjectModel.readOnly: true
  key cdhdr.changenr                as MDQltyBusRuleChangeDocument,
      @ObjectModel.readOnly: true
  key cdpos.tabname                 as MDQltyBusRuleChgDocDtbsTable,
      @ObjectModel.readOnly: true
  key cdpos.tabkey                  as MDQltyBusRuleChgDocDtbsTblKey,
      @ObjectModel.readOnly: true
  key cdpos.fname                   as MDQltyBusRuleChgDocDtbsTblFld,
      @ObjectModel.readOnly: true
  key cdpos.chngind                 as MDQltyBusRuleChgDocItmChgType,
      @ObjectModel.readOnly: true
  key _map.chnggrp                  as MDQltyBusRuleChgDocChgGroup,
      @ObjectModel.readOnly: true
  key _map.activity                 as MDQltyBusRuleChgDocChgActy,

      @ObjectModel.readOnly: true
      case when cdhdr.objectclas = 'MDQ_BUS_RULE'
            then left( cdhdr.objectid, 32 )
           when cdhdr.objectclas = 'MDQ_DIMN_CAT' 
            and cdpos.tabname = 'MDQ_DIM_R_ASSG'
            then case when cdpos.chngind = 'J'
                      then  left( cdpos.value_new, 32 )
                     when cdpos.chngind = 'E'
                      then  left( cdpos.value_old, 32 )
                 end
      end                           as MDQltyBusinessRuleUUIDString,

      @ObjectModel.readOnly: true
      @Semantics.dateTime: true
      dats_tims_to_tstmp( cdhdr.udate,
                          cdhdr.utime,
                          abap_system_timezone( $session.client,'NULL' ),
                          $session.client,
                          'NULL'  ) as MDQltyBusRuleChgDocDateTime,
      @ObjectModel.readOnly: true
      @Semantics.user.id: true
      cdhdr.username                as UserID,
      @ObjectModel.readOnly: true
      cdpos.value_old               as MDQltyBusRuleChgDocPrevFldVal,
      @ObjectModel.readOnly: true
      cdpos.value_new               as MDQltyBusRuleChgDocNewFldVal

}
where
         cdhdr.objectclas = 'MDQ_BUS_RULE'
  or(
         cdhdr.objectclas = 'MDQ_DIMN_CAT'
    and  cdpos.tabname    = 'MDQ_DIM_R_ASSG'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDHDR",
"CDPOS",
"MDQ_RULE_CDGROUP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More