I_MDChgProcHistlModifdTables

DDL: I_MDCHGPROCHISTLMODIFDTABLES SQL: IMDCHGHPROCMTABS Type: view BASIC Package: MDC_ANALYTICS

Master Data Change Process Historical Modified Tables

I_MDChgProcHistlModifdTables is a Basic CDS View that provides data about "Master Data Change Process Historical Modified Tables" in SAP S/4HANA. It reads from 1 data source (mdc_modifd_tab_h) and exposes 4 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessModelTableName. Part of development package MDC_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
mdc_modifd_tab_h mdc_modifd_tab_h from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDCHGHPROCMTABS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey MasterDataChangeProcess view
VDM.viewType #BASIC view
EndUserText.label Master Data Change Process Historical Modified Tables view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess process_id Process Instance ID
KEY MDChgProcessStep process_step_no Step Number
KEY MDChgProcessModelTableName table_name Table Name
MDChangeProcTableModifDateTime modified_at Timestamp

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_MDChgProcHistlModifdTables.
-- 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: IMDCHGHPROCMTABS

CREATE VIEW I_MDChgProcHistlModifdTables AS
SELECT
  process_id AS MasterDataChangeProcess,
  process_step_no AS MDChgProcessStep,
  table_name AS MDChgProcessModelTableName,
  modified_at AS MDChangeProcTableModifDateTime
FROM mdc_modifd_tab_h
;