I_MDQltyBusRuleChangeDocument

DDL: I_MDQLTYBUSRULECHANGEDOCUMENT SQL: IMDQBSRULECD Type: view BASIC
11 Fields 1 Data Sources

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.

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 Document Number
KEY MDQltyBusRuleChgDocDtbsTable cdpos tabname Table/Constant Value
KEY MDQltyBusRuleChgDocDtbsTblKey cdpos tabkey Table Keys
KEY MDQltyBusRuleChgDocDtbsTblFld cdpos fname User
KEY MDQltyBusRuleChgDocItmChgType cdpos chngind Change Indicator
KEY MDQltyBusRuleChgDocChgGroup _map chnggrp
KEY MDQltyBusRuleChgDocChgActy _map activity VAT Activity
clientNULLasMDQltyBusRuleChgDocDateTime
UserID cdhdr username User who owns item
MDQltyBusRuleChgDocPrevFldVal cdpos value_old Old Value
MDQltyBusRuleChgDocNewFldVal cdpos value_new New Value

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MDQltyBusRuleChangeDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMDQBSRULECD

CREATE VIEW I_MDQltyBusRuleChangeDocument AS
SELECT
  cdhdr.changenr AS MDQltyBusRuleChangeDocument,
  cdpos.tabname AS MDQltyBusRuleChgDocDtbsTable,
  cdpos.tabkey AS MDQltyBusRuleChgDocDtbsTblKey,
  cdpos.fname AS MDQltyBusRuleChgDocDtbsTblFld,
  cdpos.chngind AS MDQltyBusRuleChgDocItmChgType,
  _map.chnggrp AS MDQltyBusRuleChgDocChgGroup,
  _map.activity AS MDQltyBusRuleChgDocChgActy,
  dats_tims_to_tstmp( cdhdr.udate, cdhdr.utime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as MDQltyBusRuleChgDocDateTime AS clientNULLasMDQltyBusRuleChgDocDateTime,
  cdhdr.username AS UserID,
  cdpos.value_old AS MDQltyBusRuleChgDocPrevFldVal,
  cdpos.value_new AS MDQltyBusRuleChgDocNewFldVal
FROM cdhdr
;

Learn More