I_MDChgProcConfignMtchgPers

DDL: I_MDCHGPROCCONFIGNMTCHGPERS SQL: IMDCHGPROCMTCP Type: view BASIC
13 Fields 1 Data Sources

Master Data Change Process Configuration Matching Person

I_MDChgProcConfignMtchgPers is a Basic CDS View that provides data about "Master Data Change Process Configuration Matching Person" in SAP S/4HANA. It reads from 1 data source (mdc_d_cnfmtcimp) and exposes 13 fields with key field MDChgProcMtchgPersUUID.

Data Sources (1)

SourceAliasJoin Type
mdc_d_cnfmtcimp mdc_d_cnfmtcimp from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMTCP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Master Data Change Process Configuration Matching Person view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcMtchgPersUUID db_key UUID
MDChgProcConfignUUID parent_key UUID
MDChgProcMtchgConfign conf_id ID
MDChgProcMtchgThld threshold Upper Threshold (%)
MDChgProcIsMtchgFirstNameInit firstnameinitial First Name Initials
MDChgProcIsMtchgCompnd1stName cmpndfirstnames Match Compound First
MDChgProcIsMtchgMiddleName firsttomidnames Match First Middle
MDChgProcIsMtchgNameVarn namevariations Match Name Variation
MDChgProcIsMtchgLastNameInit lastnameinitial Match Last Initials
MDChgProcIsMtchgCompndLastName cmpndlastnames Match Compound Last
MDChgProcIsMtchgMisgPostName missingpostname Match Missing Post
MDChgProcIsMtchgTypeMatching typematching Tye Matching Enabled
MDChgProcMtchgDomainCleanse domain_cleanse Domain

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_MDChgProcConfignMtchgPers.
-- 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: IMDCHGPROCMTCP

CREATE VIEW I_MDChgProcConfignMtchgPers AS
SELECT
  db_key AS MDChgProcMtchgPersUUID,
  parent_key AS MDChgProcConfignUUID,
  conf_id AS MDChgProcMtchgConfign,
  threshold AS MDChgProcMtchgThld,
  firstnameinitial AS MDChgProcIsMtchgFirstNameInit,
  cmpndfirstnames AS MDChgProcIsMtchgCompnd1stName,
  firsttomidnames AS MDChgProcIsMtchgMiddleName,
  namevariations AS MDChgProcIsMtchgNameVarn,
  lastnameinitial AS MDChgProcIsMtchgLastNameInit,
  cmpndlastnames AS MDChgProcIsMtchgCompndLastName,
  missingpostname AS MDChgProcIsMtchgMisgPostName,
  typematching AS MDChgProcIsMtchgTypeMatching,
  domain_cleanse AS MDChgProcMtchgDomainCleanse
FROM mdc_d_cnfmtcimp
;

Learn More