I_MDEffctvConfignValidation

DDL: I_MDEFFCTVCONFIGNVALIDATION SQL: IMDEFCCONFVAL Type: view BASIC

Core View: MD Effctv Confign Validation

I_MDEffctvConfignValidation is a Basic CDS View that provides data about "Core View: MD Effctv Confign Validation" in SAP S/4HANA. It reads from 2 data sources (I_MDChgProcConfignValdtn, mdc_config_val) and exposes 16 fields with key field MDChgProcessStepUUID.

Data Sources (2)

SourceAliasJoin Type
I_MDChgProcConfignValdtn I_MDChgProcConfignValdtn from
mdc_config_val mdc_config_val union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDEFCCONFVAL 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 Validation view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID ProcessStep MDChgProcessStepUUID
MDChgProcessStepAdapterConfign Configuration ID
MDChgProcValdtnConfign MDChgProcValdtnConfign ID
MDChgProcessStpOwnConfignIsRqd
MDChgProcValdtnIsMDGovChkRqd MDChgProcValdtnIsMDGovChkRqd MDG Checks
MDChgProcValdtnIsBRFplusChkRqd MDChgProcValdtnIsBRFplusChkRqd BRF+ Checks
MDChgProcQltyRuleChkIsRqd MDChgProcQltyRuleChkIsRqd Apply Valid. Rules
MDChgProcValdtnThld MDChgProcValdtnThld Upper Threshold (%)
MDChgProcessStepAdapterConfign adapter_config Configuration ID
MDChgProcValdtnConfign ID
MDChgProcessStpOwnConfignIsRqd
MDChgProcValdtnIsMDGovChkRqd mdg_validations MDG Checks
MDChgProcValdtnIsBRFplusChkRqd brfplus_validations BRF+ Checks
MDChgProcQltyRuleChkIsRqd dq_rule_validations Apply Valid. Rules
MDChgProcValdtnThld threshold Upper Threshold (%)
MDChgProcValdtnIsRemoveRecdRqd remove_unchanged_records Remove Unchanged Rec

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_MDEffctvConfignValidation.
-- 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: IMDEFCCONFVAL

CREATE VIEW I_MDEffctvConfignValidation AS
SELECT
  ProcessStep.MDChgProcessStepUUID AS MDChgProcessStepUUID,
  '123456789A' AS MDChgProcessStepAdapterConfign,
  MDChgProcValdtnConfign,
  'X' AS MDChgProcessStpOwnConfignIsRqd,
  MDChgProcValdtnIsMDGovChkRqd,
  MDChgProcValdtnIsBRFplusChkRqd,
  MDChgProcQltyRuleChkIsRqd,
  MDChgProcValdtnThld,
  remove_unchanged_records AS MDChgProcValdtnIsRemoveRecdRqd
FROM I_MDChgProcConfignValdtn
-- UNION with additional select branch(es): mdc_config_val
;