P_ProcIntegDsputCaseMultiple

DDL: P_PROCINTEGDSPUTCASEMULTIPLE SQL: PDCASEMULTIPLE Type: view COMPOSITE Package: FINS_FIS_APAR_APPS

Process Integrated Cases which aren't alone on the rel. item

P_ProcIntegDsputCaseMultiple is a Composite CDS View that provides data about "Process Integrated Cases which aren't alone on the rel. item" in SAP S/4HANA. It reads from 2 data sources (I_CaseAttribute, P_ProcIntegDsputCaseMultiLtst) and exposes 11 fields. Part of development package FINS_FIS_APAR_APPS.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_CaseAttribute _CaseAttribute inner
P_ProcIntegDsputCaseMultiLtst _ProcIntegDsputCaseMultiLtst from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDCASEMULTIPLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
ObjectKey P_ProcIntegDsputCaseMultiLtst ObjectKey
CaseID I_CaseAttribute CaseID
CaseUniqueID I_CaseAttribute CaseUniqueID
CasePriority I_CaseAttribute CasePriority
CasePriorityName
CaseTitle I_CaseAttribute CaseTitle
CaseReason I_CaseAttribute CaseReason
CaseReasonName
CaseStatus I_CaseAttribute CaseStatus
CaseStatusName
CaseProcessor I_CaseAttribute CaseProcessor 
@AbapCatalog.sqlViewName: 'PDCASEMULTIPLE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ProcIntegDsputCaseMultiple 
  as select from P_ProcIntegDsputCaseMultiLtst as _ProcIntegDsputCaseMultiLtst
  
    left outer to many join P_ProcIntegDsputCaseMultiDspOb as _DisputedObject on _DisputedObject.ObjectKey               = _ProcIntegDsputCaseMultiLtst.ObjectKey
                                                               
    inner join I_CaseAttribute as _CaseAttribute        on  _DisputedObject.CaseUniqueID              = _CaseAttribute.CaseUniqueID
                                                        and _ProcIntegDsputCaseMultiLtst.CaseCreatedOn = _CaseAttribute.CaseCreatedOn  
{
  _ProcIntegDsputCaseMultiLtst.ObjectKey,
  _CaseAttribute.CaseID,
  _CaseAttribute.CaseUniqueID,
  _CaseAttribute.CasePriority,
  _CaseAttribute._Priority._Text[1:Language = $session.system_language].CasePriorityName,
  _CaseAttribute.CaseTitle,
  _CaseAttribute.CaseReason,
  _CaseAttribute._Reasons._Text[1:Language = $session.system_language].CaseReasonName,
  _CaseAttribute.CaseStatus,
  _CaseAttribute._Individual._Text[1:Language = $session.system_language].CaseStatusName,
  _CaseAttribute.CaseProcessor
}

Learn More