P_ProcIntegDsputCaseMultiple

DDL: P_PROCINTEGDSPUTCASEMULTIPLE SQL: PDCASEMULTIPLE Type: view COMPOSITE

P_ProcIntegDsputCaseMultiple is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CaseAttribute, P_ProcIntegDsputCaseMultiLtst) and exposes 11 fields.

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 I_DisputedObject as _DisputedObject on _DisputedObject.ObjectKey               = _ProcIntegDsputCaseMultiLtst.ObjectKey
                                                                and _DisputedObject.ObjectType             = 'BSEG'
                                                                and (   _DisputedObject.RelationshipNumber = 'F1'
                                                                     or _DisputedObject.RelationshipNumber = 'F2' )
                                                                and _DisputedObject.DisputeCaseIsVoided    = ''     
                                                           
    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
}



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CASEATTRIBUTE",
"I_CASEINDIVIDUALSTATUS",
"I_CASEINDIVIDUALSTATUSTEXT",
"I_CASEPRIORITY",
"I_CASEPRIORITYTEXT",
"I_CASEREASONS",
"I_CASEREASONSTEXT",
"I_DISPUTEDOBJECT",
"P_PROCINTEGDSPUTCASEMULTILTST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More