P_PROCINTEGDSPUTCASEMULTILTST

CDS View

P_PROCINTEGDSPUTCASEMULTILTST is a CDS View in S/4HANA. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ProcIntegDsputCaseMultiple view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
ObjectKey ObjectKey 1 
@AbapCatalog.sqlViewName: 'PDCASEMULTILTST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ProcIntegDsputCaseMultiLtst 
  as select from P_ProcIntegDsputCaseCount as _ProcIntegDsputCaseCount
  
  left outer to many join I_DisputedObject as _DisputedObject      on _DisputedObject.ObjectKey               = _ProcIntegDsputCaseCount.ObjectKey
                                                           and _DisputedObject.ObjectType             = 'BSEG'
                                                           and (   _DisputedObject.RelationshipNumber = 'F1'
                                                                or _DisputedObject.RelationshipNumber = 'F2' )
                                                           and _DisputedObject.DisputeCaseIsVoided    = ''     
                                                           
  left outer to one join I_CaseAttribute as _CaseAttribute  on _DisputedObject.CaseUniqueID = _CaseAttribute.CaseUniqueID 
{

  _ProcIntegDsputCaseCount.ObjectKey,
  max( _CaseAttribute.CaseCreatedOn ) as CaseCreatedOn  
}
where    _ProcIntegDsputCaseCount.DisputeCaseCount > 1
group by _ProcIntegDsputCaseCount.ObjectKey

Learn More