P_ProcIntegDsputCaseMultiple

DDL: P_PROCINTEGDSPUTCASEMULTIPLE SQL: PDCASEMULTIPLE Type: view COMPOSITE
11 Fields 2 Data Sources

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.

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 Object Key
CaseID I_CaseAttribute CaseID Case ID
CaseUniqueID I_CaseAttribute CaseUniqueID UUID
CasePriority I_CaseAttribute CasePriority Priority
CasePriorityName
CaseTitle I_CaseAttribute CaseTitle Case Title
CaseReason I_CaseAttribute CaseReason Reason
CaseReasonName
CaseStatus I_CaseAttribute CaseStatus Status
CaseStatusName
CaseProcessor I_CaseAttribute CaseProcessor Processor

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ProcIntegDsputCaseMultiple.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PDCASEMULTIPLE

CREATE VIEW P_ProcIntegDsputCaseMultiple AS
SELECT
  _ProcIntegDsputCaseMultiLtst.ObjectKey AS ObjectKey,
  _CaseAttribute.CaseID AS CaseID,
  _CaseAttribute.CaseUniqueID AS CaseUniqueID,
  _CaseAttribute.CasePriority AS CasePriority,
  _CaseAttribute._Priority._Text[1:Language = $session.system_language].CasePriorityName AS CasePriorityName,
  _CaseAttribute.CaseTitle AS CaseTitle,
  _CaseAttribute.CaseReason AS CaseReason,
  _CaseAttribute._Reasons._Text[1:Language = $session.system_language].CaseReasonName AS CaseReasonName,
  _CaseAttribute.CaseStatus AS CaseStatus,
  _CaseAttribute._Individual._Text[1:Language = $session.system_language].CaseStatusName AS CaseStatusName,
  _CaseAttribute.CaseProcessor AS CaseProcessor
FROM P_ProcIntegDsputCaseMultiLtst AS _ProcIntegDsputCaseMultiLtst
INNER JOIN I_CaseAttribute AS _CaseAttribute ON /* join condition not captured in parsed metadata */
;

Learn More