I_MDChgProcKPIFilterUpdateTbl

DDL: I_MDCHGPROCKPIFILTERUPDATETBL SQL: IMDFILTERUPDTBL Type: view COMPOSITE

MD KPI Filter Key Update Table

I_MDChgProcKPIFilterUpdateTbl is a Composite CDS View that provides data about "MD KPI Filter Key Update Table" in SAP S/4HANA. It reads from 8 data sources and exposes 25 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChangeProcKPIFilter, MDChangeProcKPIValueKey, MDChgProcessStep.

Data Sources (8)

SourceAliasJoin Type
I_MDChgProcStepDataProviderKPI _dpiKPI left_outer
I_MDChgProcStepEditKPI _editKPI left_outer
I_MDChgProcStepEnrichmentKPI _enrichmentKPI left_outer
I_MDChgProcStepUpdateKPI _updateKPI left_outer
I_MDChgProcKPIFilterKeyTexts filterKey from
I_MDChgProcKPIFilterKeyTexts filterKey union
I_MDChgProcKPIFilterKeyTexts filterKey union
I_MDChgProcKPIFilterKeyTexts filterKey union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDFILTERUPDTBL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label MD KPI Filter Key Update Table view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDChgProcStepEditKPI MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDChgProcStepEditKPI MDChgProcessStep Step Number
KEY MDChangeProcKPIFilter I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilter KPI Filter
KEY MDChangeProcKPIValueKey I_MDChgProcStepEditKPI MDChangeProcessStepTable Table Name
MDChangeProcKPIFilterDesc I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterDesc KPI Filter Descr
MDChangeProcKPIFilterLevel I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterLevel KPI Filter Level
MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDChgProcStepEnrichmentKPI MDChgProcessStep Step Number
KEY MDChangeProcKPIFilter I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilter KPI Filter
KEY MDChangeProcKPIValueKey I_MDChgProcStepEnrichmentKPI MDChangeProcessStepTable Table Name
MDChangeProcKPIFilterDesc I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterDesc KPI Filter Descr
MDChangeProcKPIFilterLevel I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterLevel KPI Filter Level
MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDChgProcStepUpdateKPI MDChgProcessStep Step Number
KEY MDChangeProcKPIFilter I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilter KPI Filter
KEY MDChangeProcKPIValueKey I_MDChgProcStepUpdateKPI MDChangeProcessStepTable Table Name
MDChangeProcKPIFilterDesc I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterDesc KPI Filter Descr
MDChangeProcKPIFilterLevel I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterLevel KPI Filter Level
MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDChgProcStepDataProviderKPI MDChgProcessStep Step Number
KEY MDChangeProcKPIFilter I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilter KPI Filter
KEY MDChangeProcKPIValueKey I_MDChgProcStepDataProviderKPI MDChangeProcessStepTable Table Name
MDChangeProcKPIFilterDesc I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterDesc KPI Filter Descr
MDChangeProcKPIFilterLevel I_MDChgProcKPIFilterKeyTexts MDChangeProcKPIFilterLevel KPI Filter Level
MDChangeProcKPIValueKeyDesc I_MDChgProcStepDataProviderKPI MDChangeProcessStepTable Table Name

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_MDChgProcKPIFilterUpdateTbl.
-- 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: IMDFILTERUPDTBL

CREATE VIEW I_MDChgProcKPIFilterUpdateTbl AS
SELECT
  _editKPI.MasterDataChangeProcess AS MasterDataChangeProcess,
  _editKPI.MDChgProcessStep AS MDChgProcessStep,
  filterKey.MDChangeProcKPIFilter AS MDChangeProcKPIFilter,
  _editKPI.MDChangeProcessStepTable AS MDChangeProcKPIValueKey,
  filterKey.MDChangeProcKPIFilterDesc AS MDChangeProcKPIFilterDesc,
  filterKey.MDChangeProcKPIFilterLevel AS MDChangeProcKPIFilterLevel,
  _dpiKPI.MDChangeProcessStepTable AS MDChangeProcKPIValueKeyDesc
FROM I_MDChgProcKPIFilterKeyTexts AS filterKey
LEFT OUTER JOIN I_MDChgProcStepEditKPI AS _editKPI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDChgProcStepEnrichmentKPI AS _enrichmentKPI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDChgProcStepUpdateKPI AS _updateKPI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MDChgProcStepDataProviderKPI AS _dpiKPI ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_MDChgProcKPIFilterKeyTexts
;