I_MDEffctvConfignFilter

DDL: I_MDEFFCTVCONFIGNFILTER SQL: IMDEFCCONFFLT Type: view BASIC Package: MDC_PROCESS_OBJECT

Core View: MD Effctv Confign Filter

I_MDEffctvConfignFilter is a Basic CDS View that provides data about "Core View: MD Effctv Confign Filter" in SAP S/4HANA. It reads from 2 data sources (I_Mdchgprocconfignfilter, mdc_config_far) and exposes 28 fields with key field MDChgProcessStepUUID. Part of development package MDC_PROCESS_OBJECT.

Data Sources (2)

SourceAliasJoin Type
I_Mdchgprocconfignfilter I_Mdchgprocconfignfilter union
mdc_config_far mdc_config_far from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDEFCCONFFLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Core View: MD Effctv Confign Filter view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID ProcessStep MDChgProcessStepUUID
MDChgProcessStepAdapterConfign adapter_config Configuration ID
MDChgProcFilterConfign ID
MDChgProcessStpOwnConfignIsRqd
MDChgProcFilterStepType step_type VSS Sol. Step Type
MDChgProcFilterIsMtchgOpenGrp split_open_groups Split Open Group
MDChgProcFilterIsCalcSpltSgl split_single Split Single
MDChgProcFilterIsCalcSpltGrp split_new_group Split Group
MDChgProcFilterIsCalcSpltUpdt split_update Split Update
MDChgProcFilterIsSpltSgl split_single_w Split Single
MDChgProcFilterIsSpltGrp split_new_group_w Split Group
MDChgProcFilterIsSpltUpdt split_update_w Split Update
MDChgProcFilterValdtnActnSgl single_e Single
MDChgProcFilterValdtnActnGrp new_group_e Group
MDChgProcessStepAdapterConfign Configuration ID
MDChgProcFilterConfign MDChgProcFilterConfign ID
MDChgProcessStpOwnConfignIsRqd
MDChgProcFilterStepType MDChgProcFilterStepType VSS Sol. Step Type
MDChgProcFilterIsMtchgOpenGrp MDChgProcFilterIsMtchgOpenGrp Split Open Group
MDChgProcFilterIsCalcSpltSgl MDChgProcFilterIsCalcSpltSgl Split Single
MDChgProcFilterIsCalcSpltGrp MDChgProcFilterIsCalcSpltGrp Split Group
MDChgProcFilterIsCalcSpltUpdt MDChgProcFilterIsCalcSpltUpdt Split Update
MDChgProcFilterIsSpltSgl MDChgProcFilterIsSpltSgl Split Single
MDChgProcFilterIsSpltGrp MDChgProcFilterIsSpltGrp Split Group
MDChgProcFilterIsSpltUpdt MDChgProcFilterIsSpltUpdt Split Update
MDChgProcFilterValdtnActnSgl MDChgProcFilterValdtnActnSgl Single
MDChgProcFilterValdtnActnGrp MDChgProcFilterValdtnActnGrp Group
MDChgProcFilterValdtnActnUpdt MDChgProcFilterValdtnActnUpdt Update

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_MDEffctvConfignFilter.
-- 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: IMDEFCCONFFLT

CREATE VIEW I_MDEffctvConfignFilter AS
SELECT
  ProcessStep.MDChgProcessStepUUID AS MDChgProcessStepUUID,
  adapter_config AS MDChgProcessStepAdapterConfign,
  HEXTOBIN( '00000000000000000000000000000000' ) AS MDChgProcFilterConfign,
  ' ' AS MDChgProcessStpOwnConfignIsRqd,
  step_type AS MDChgProcFilterStepType,
  split_open_groups AS MDChgProcFilterIsMtchgOpenGrp,
  split_single AS MDChgProcFilterIsCalcSpltSgl,
  split_new_group AS MDChgProcFilterIsCalcSpltGrp,
  split_update AS MDChgProcFilterIsCalcSpltUpdt,
  split_single_w AS MDChgProcFilterIsSpltSgl,
  split_new_group_w AS MDChgProcFilterIsSpltGrp,
  split_update_w AS MDChgProcFilterIsSpltUpdt,
  single_e AS MDChgProcFilterValdtnActnSgl,
  new_group_e AS MDChgProcFilterValdtnActnGrp,
  MDChgProcFilterValdtnActnUpdt
FROM mdc_config_far
-- UNION with additional select branch(es): I_Mdchgprocconfignfilter
;