C_EDCResultUIGroup

DDL: C_EDCRESULTUIGROUP Type: view_entity CONSUMPTION
3 Fields 5 Associations 1 OData Services

Electronic Document Consistency Result UI Group

C_EDCResultUIGroup is a Consumption CDS View that provides data about "Electronic Document Consistency Result UI Group" in SAP S/4HANA. It has 5 associations to related views. It is exposed through 1 OData service (EDC_PROCESS).

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_EDCResultUIGroup _EDCResultUIGroup _EDCResultUIGroup.EDCType = _EDCRsltUIGrpRprstnTypeRltn.EDCType and _EDCResultUIGroup.EDCResultUIGroup = _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup
[1..1] R_EDCResultUIGroupText _EDCResultUIGroupText _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _EDCResultUIGroupText.EDCResultUIGroup and _EDCRsltUIGrpRprstnTypeRltn.EDCType = _EDCResultUIGroupText.EDCType and _EDCResultUIGroupText.Language = $session.system_language
[1..*] R_EDCRsltUIGrpRsltProcAssgmt _ResultUIGroupResulProcAssgmt _EDCRsltUIGrpRprstnTypeRltn.EDCType = _ResultUIGroupResulProcAssgmt.EDCType and _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _ResultUIGroupResulProcAssgmt.EDCResultUIGroup
[1..1] I_EDCResultProcess _EDCResultProcessGrouping _EDCRsltUIGrpRprstnTypeRltn.EDCType = _EDCResultProcessGrouping.EDCType and _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _EDCResultProcessGrouping.EDCResultProcess
[1..1] I_ElectronicDocProcessText _ElectronicDocProcessText _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _ElectronicDocProcessText.ElectronicDocProcess and _ElectronicDocProcessText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Electronic Document Consistency Result UI Group view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
EDC_PROCESS UI_EDC_PROCESS_O2 V2 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY EDCType _EDCRsltUIGrpRprstnTypeRltn EDCType
KEY EDCResultUIGroupendasEDCResultUIGroup
KEY EDCResultProcessendasEDCResultProcess

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 C_EDCResultUIGroup.
-- 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 C_EDCResultUIGroup AS
SELECT
  _EDCRsltUIGrpRprstnTypeRltn.EDCType AS EDCType,
  case when _EDCResultUIGroup.EDCResultUIGroup is null then _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup else _EDCResultUIGroup.EDCResultUIGroup end as EDCResultUIGroup AS EDCResultUIGroupendasEDCResultUIGroup,
  case when _EDCResultProcessGrouping.EDCResultProcess is null then _ResultUIGroupResulProcAssgmt.EDCResultProcess else _EDCResultProcessGrouping.EDCResultProcess end as EDCResultProcess AS EDCResultProcessendasEDCResultProcess
LEFT OUTER JOIN R_EDCResultUIGroup AS _EDCResultUIGroup ON _EDCResultUIGroup.EDCType = _EDCRsltUIGrpRprstnTypeRltn.EDCType AND _EDCResultUIGroup.EDCResultUIGroup = _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup  -- association [1..1]
LEFT OUTER JOIN R_EDCResultUIGroupText AS _EDCResultUIGroupText ON _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _EDCResultUIGroupText.EDCResultUIGroup AND _EDCRsltUIGrpRprstnTypeRltn.EDCType = _EDCResultUIGroupText.EDCType AND _EDCResultUIGroupText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN R_EDCRsltUIGrpRsltProcAssgmt AS _ResultUIGroupResulProcAssgmt ON _EDCRsltUIGrpRprstnTypeRltn.EDCType = _ResultUIGroupResulProcAssgmt.EDCType AND _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _ResultUIGroupResulProcAssgmt.EDCResultUIGroup  -- association [1..*]
LEFT OUTER JOIN I_EDCResultProcess AS _EDCResultProcessGrouping ON _EDCRsltUIGrpRprstnTypeRltn.EDCType = _EDCResultProcessGrouping.EDCType AND _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _EDCResultProcessGrouping.EDCResultProcess  -- association [1..1]
LEFT OUTER JOIN I_ElectronicDocProcessText AS _ElectronicDocProcessText ON _EDCRsltUIGrpRprstnTypeRltn.EDCResultUIGroup = _ElectronicDocProcessText.ElectronicDocProcess AND _ElectronicDocProcessText.Language = $session.system_language  -- association [1..1]
;

Learn More