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.
@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
}defineviewentity C_EDCResultProcess
asselectfrom R_EDCType as _ConsistencyType
// leftouter to many join edcconvaltype as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype
// innerjoin edcconexist as EDCExistCheck on _ConsistencyType.EDCType = EDCExistCheck.contype
// and _ComparisonType.convaltype = EDCExistCheck.convaltype
leftouter to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
innerjoin 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
}
unionselectfrom R_EDCType as _ConsistencyType
// leftouter to many join edcconvaltype as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype
// innerjoin edcconstat as EDCStatusCheck on _ConsistencyType.EDCType = EDCStatusCheck.contype
// and _ComparisonType.convaltype = EDCStatusCheck.convaltype
leftouter to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
innerjoin 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
}
unionselectfrom R_EDCType as _ConsistencyType
// leftouter to many join edcconvaltype as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.contype
leftouter to many join R_EDCComparisonTypeDefinition as _ComparisonType on _ConsistencyType.EDCType = _ComparisonType.EDCType
innerjoin 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
}