I_MDChgProcConfignMtchgAddrTP

DDL: I_MDCHGPROCCONFIGNMTCHGADDRTP SQL: IMDCHGPROCMTCATP Type: view TRANSACTIONAL Package: MDC_PROCESS_OBJECT
13 Fields 1 Data Sources 1 Associations

Master Data Change Process Configuration Matching Address

I_MDChgProcConfignMtchgAddrTP is a Transactional 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 13 fields with key field MDChgProcMtchgAddrUUID. It has 1 association to related views. Part of development package MDC_PROCESS_OBJECT.

Data Sources (1)

SourceAliasJoin Type
mdc_d_cnfmtcima mdc_d_cnfmtcima from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MDChangeProcessConfignTP _Root _Root.MDChgProcConfignUUID = $projection.MDChgProcConfignUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGPROCMTCATP 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 #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.writeActivePersistence TMDCHGPROCMTCA_W view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view

Fields (13)

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
_Root _Root

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_MDChgProcConfignMtchgAddrTP.
-- 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: IMDCHGPROCMTCATP

CREATE VIEW I_MDChgProcConfignMtchgAddrTP 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
LEFT OUTER JOIN I_MDChangeProcessConfignTP AS _Root ON _Root.MDChgProcConfignUUID = MDChgProcConfignUUID  -- association [1..1]
;

Learn More