I_EDCResultCurrentDeviation

DDL: I_EDCRESULTCURRENTDEVIATION Type: view_entity COMPOSITE
13 Fields 3 Data Sources

EDC current deviation results

I_EDCResultCurrentDeviation is a Composite CDS View that provides data about "EDC current deviation results" in SAP S/4HANA. It reads from 3 data sources (I_EDCResultDeviation, R_EDCFormulaText, I_EDCResult) and exposes 13 fields with key fields EDCResultUUID, EDCContentCheckFieldGroupName, EDCFormulaId, EDCParameterType.

Data Sources (3)

SourceAliasJoin Type
I_EDCResultDeviation EDCDvtnRslt inner
R_EDCFormulaText EDCFormulaText inner
I_EDCResult EDCResult from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label EDC current deviation results view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY EDCResultUUID I_EDCResult EDCResultUUID Result GUID
KEY EDCContentCheckFieldGroupName I_EDCResultDeviation EDCContentCheckFieldGroupName Mismatch Group
KEY EDCFormulaId I_EDCResultDeviation EDCFormulaId Check Formula
KEY EDCParameterType I_EDCResultDeviation EDCParameterType Parameter Type
EDCResultSqncNmbr I_EDCResult EDCResultSqncNmbr Result Seq No
EDCParameterValue I_EDCResultDeviation EDCParameterValue Value
EDCFormulaDesc R_EDCFormulaText EDCFormulaDesc
EDCType I_EDCResult EDCType Consistency Scen.
EDCCheckID I_EDCResult EDCCheckID Question Check ID
EDCValidationType I_EDCResult EDCValidationType Comparison Type
EDCCompany I_EDCResult EDCCompany Value
EDCOrganizationalUnit I_EDCResult EDCOrganizationalUnit Org. Unit ID
EDCOrganizationalUnitValue I_EDCResult EDCOrganizationalUnitValue

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_EDCResultCurrentDeviation.
-- 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.

CREATE VIEW I_EDCResultCurrentDeviation AS
SELECT
  EDCResult.EDCResultUUID AS EDCResultUUID,
  EDCDvtnRslt.EDCContentCheckFieldGroupName AS EDCContentCheckFieldGroupName,
  EDCDvtnRslt.EDCFormulaId AS EDCFormulaId,
  EDCDvtnRslt.EDCParameterType AS EDCParameterType,
  EDCResult.EDCResultSqncNmbr AS EDCResultSqncNmbr,
  EDCDvtnRslt.EDCParameterValue AS EDCParameterValue,
  EDCFormulaText.EDCFormulaDesc AS EDCFormulaDesc,
  EDCResult.EDCType AS EDCType,
  EDCResult.EDCCheckID AS EDCCheckID,
  EDCResult.EDCValidationType AS EDCValidationType,
  EDCResult.EDCCompany AS EDCCompany,
  EDCResult.EDCOrganizationalUnit AS EDCOrganizationalUnit,
  EDCResult.EDCOrganizationalUnitValue AS EDCOrganizationalUnitValue
FROM I_EDCResult AS EDCResult
INNER JOIN I_EDCResultDeviation AS EDCDvtnRslt ON /* join condition not captured in parsed metadata */
INNER JOIN R_EDCFormulaText AS EDCFormulaText ON /* join condition not captured in parsed metadata */
;

Learn More