I_MDChgProcConfignMtchgAddr

DDL: I_MDCHGPROCCONFIGNMTCHGADDR SQL: IMDCHGPROCMTCA Type: view BASIC
12 Fields 1 Data Sources

Master Data Change Process Configuration Matching Address

I_MDChgProcConfignMtchgAddr is a Basic CDS View that provides data about "Master Data Change Process Configuration Matching Address" in SAP S/4HANA. It reads from 1 data source (mdc_d_cnfmtcima) and exposes 12 fields with key field MDChgProcMtchgAddrUUID.

Data Sources (1)

SourceAliasJoin Type
mdc_d_cnfmtcima mdc_d_cnfmtcima from

Annotations (9)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcMtchgAddrUUID db_key UUID
MDChgProcConfignUUID parent_key UUID
MDChgProcMtchgConfign conf_id ID
MDChgProcMtchgThld threshold Upper Threshold (%)
MDChgProcIsMtchgMisgSecdryAddr missingsecdata Match Missing Second
MDChgProcIsMtchgMisgTypeAddr missingstrtype Missing Street Type
MDChgProcIsMtchgDiffntTypeAddr diffstrtypes Match Diff Str Type
MDChgProcIsMtchgMisgAddr missingdirctnl Match Missing Dirs
MDChgProcIsMtchgDiffntAddr differentdirctnl Match Diff Dirs
MDChgProcIsMtchgTypeMatching typematching Tye Matching Enabled
MDChgProcMtchgCleanseCntry id_mode Ctry/Rg ID Mode
MDChgProcMtchgConfignCntry id_country Ctry/Rg

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_MDChgProcConfignMtchgAddr.
-- 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: IMDCHGPROCMTCA

CREATE VIEW I_MDChgProcConfignMtchgAddr AS
SELECT
  db_key AS MDChgProcMtchgAddrUUID,
  parent_key AS MDChgProcConfignUUID,
  conf_id AS MDChgProcMtchgConfign,
  threshold AS MDChgProcMtchgThld,
  missingsecdata AS MDChgProcIsMtchgMisgSecdryAddr,
  missingstrtype AS MDChgProcIsMtchgMisgTypeAddr,
  diffstrtypes AS MDChgProcIsMtchgDiffntTypeAddr,
  missingdirctnl AS MDChgProcIsMtchgMisgAddr,
  differentdirctnl AS MDChgProcIsMtchgDiffntAddr,
  typematching AS MDChgProcIsMtchgTypeMatching,
  id_mode AS MDChgProcMtchgCleanseCntry,
  id_country AS MDChgProcMtchgConfignCntry
FROM mdc_d_cnfmtcima
;

Learn More