C_EDCResultProcess

DDL: C_EDCRESULTPROCESS Type: view_entity CONSUMPTION

EDC Result Processes

C_EDCResultProcess is a Consumption CDS View that provides data about "EDC Result Processes" in SAP S/4HANA. It reads from 6 data sources and exposes 7 fields with key fields EDCType, EDCValidationType, EDCTypeasEDCType, EDCValidationType, EDCTypeasEDCType.

Data Sources (6)

SourceAliasJoin Type
R_EDCType _ConsistencyType from
R_EDCType _ConsistencyType union
R_EDCType _ConsistencyType union
I_EDCContentCheckFieldGroup EDCContentCheck inner
R_EDCExistenceCheckDefinition EDCExistCheck inner
R_EDCStatusCheckDefinition EDCStatusCheck inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label EDC Result Processes view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY EDCType R_EDCType EDCType
KEY EDCValidationType R_EDCExistenceCheckDefinition EDCValidationType
KEY EDCTypeasEDCType
KEY EDCValidationType R_EDCStatusCheckDefinition EDCValidationType
KEY EDCTypeasEDCType
KEY EDCValidationType I_EDCContentCheckFieldGroup EDCValidationType
KEY EDCResultProcess I_EDCContentCheckFieldGroup EDCResultProcess
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'EDC Result Processes'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType:#CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity C_EDCResultProcess
  as select from            R_EDCType                     as _ConsistencyType
  //    left outer to many join edcconvaltype as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype

  //    inner join              edcconexist   as EDCExistCheck   on  _ConsistencyType.EDCType   = EDCExistCheck.contype

  //                                                             and _ComparisonType.convaltype = EDCExistCheck.convaltype

    left outer to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
    inner join              R_EDCExistenceCheckDefinition as EDCExistCheck   on  _ConsistencyType.EDCType          = EDCExistCheck.EDCType
                                                                             and _ComparisonType.EDCValidationType = EDCExistCheck.EDCValidationType
{
  key _ConsistencyType.EDCType        as EDCType,
  key EDCExistCheck.EDCValidationType as EDCValidationType,
  key EDCExistCheck.EDCResultProcess  as EDCResultProcess
}
union

select from               R_EDCType                     as _ConsistencyType
//  left outer to many join edcconvaltype as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype

//  inner join              edcconstat    as EDCStatusCheck  on  _ConsistencyType.EDCType   = EDCStatusCheck.contype

//                                                           and _ComparisonType.convaltype = EDCStatusCheck.convaltype

  left outer to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
  inner join              R_EDCStatusCheckDefinition    as EDCStatusCheck  on  _ConsistencyType.EDCType          = EDCStatusCheck.EDCType
                                                                           and _ComparisonType.EDCValidationType = EDCStatusCheck.EDCValidationType
{
  key _ConsistencyType.EDCType         as EDCType,
  key EDCStatusCheck.EDCValidationType as EDCValidationType,
  key EDCStatusCheck.EDCResultProcess  as EDCResultProcess
}
union

select from               R_EDCType                     as _ConsistencyType
//  left outer to many join edcconvaltype               as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype

  left outer to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
  inner join              I_EDCContentCheckFieldGroup   as EDCContentCheck on  _ConsistencyType.EDCType          = EDCContentCheck.EDCType
                                                                           and _ComparisonType.EDCValidationType = EDCContentCheck.EDCValidationType
{
  key _ConsistencyType.EDCType          as EDCType,
  key EDCContentCheck.EDCValidationType as EDCValidationType,
  key EDCContentCheck.EDCResultProcess  as EDCResultProcess
}