I_BPEMCase

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 I_BPEMCase.
-- 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: IBPEMCASE

CREATE VIEW I_BPEMCase AS
SELECT
  emma_case.casenr AS BPEMCase,
  emma_case.bpcode AS BPEMBusinessProcessCode,
  emma_case.ctype AS BPEMCaseType,
  emma_case.status AS BPEMCaseStatus,
  emma_case.ccat AS BPEMCaseCategory,
  emma_case.prio AS BPEMCasePriority,
  emma_case.brgru AS AuthorizationGroup,
  emma_case.mainobjtype AS BPEMCaseMainObjectType,
  emma_case.mainobjkey AS BPEMCaseMainObject,
  emma_case.orig_date AS BPEMCaseOriginalDate,
  emma_case.orig_time AS BPEMCaseOriginalTime,
  emma_case.currproc AS BPEMCaseCurrentProcessor,
  emma_case.reacode AS BPEMCaseForwardingReason,
  emma_case.cancode AS BPEMCaseReversalReason,
  emma_case.prevproc AS BPEMCasePreviousProcessor,
  emma_case.due_date AS BPEMCaseDueDate,
  emma_case.due_time AS BPEMCaseDueTime,
  emma_case.xnote AS BPEMCaseNoteIsExisting,
  emma_case.casetxt AS BPEMCaseName,
  emma_case.created_date AS BPEMCaseCreationDate,
  emma_case.created_time AS BPEMCaseCreationTime,
  emma_case.created_by AS BPEMCaseCreatedByUser,
  emma_case.changed_date AS BPEMCaseLastChangedDate,
  emma_case.changed_time AS BPEMCaseLastChangedTime,
  emma_case.changed_by AS BPEMCaseLastChangedByUser,
  emma_case.custstatus AS BPEMCaseCustomStatus
FROM emma_case
LEFT OUTER JOIN I_BPEMCaseActor AS _BPEMCaseActor ON BPEMCase = _BPEMCaseActor.BPEMCase  -- association [0..*]
LEFT OUTER JOIN I_BPEMCaseObject AS _BPEMCaseObject ON BPEMCase = _BPEMCaseObject.BPEMCase  -- association [0..*]
LEFT OUTER JOIN I_BPEMCaseMessage AS _BPEMCaseMessage ON BPEMCase = _BPEMCaseMessage.BPEMCase  -- association [0..*]
LEFT OUTER JOIN I_BPEMBusinessProcessCode AS _BPEMBusinessProcessCode ON BPEMBusinessProcessCode = _BPEMBusinessProcessCode.BPEMBusinessProcessCode  -- association [0..1]
LEFT OUTER JOIN I_BPEMCaseType AS _BPEMCaseType ON BPEMCaseType = _BPEMCaseType.BPEMCaseType  -- association [0..1]
LEFT OUTER JOIN I_BPEMCaseStatus AS _BPEMCaseStatus ON BPEMCaseStatus = _BPEMCaseStatus.BPEMCaseStatus  -- association [1..1]
LEFT OUTER JOIN I_BPEMCaseCategory AS _BPEMCaseCategory ON BPEMCaseCategory = _BPEMCaseCategory.BPEMCaseCategory  -- association [1..1]
LEFT OUTER JOIN I_BPEMCasePriority AS _BPEMCasePriority ON BPEMCasePriority = _BPEMCasePriority.BPEMCasePriority  -- association [1..1]
LEFT OUTER JOIN I_BPEMCaseForwardReason AS _BPEMCaseForwardReason ON BPEMCaseForwardingReason = _BPEMCaseForwardReason.BPEMCaseForwardingReason  -- association [0..1]
LEFT OUTER JOIN I_BPEMCaseReversalReason AS _BPEMCaseReversalReason ON BPEMCaseReversalReason = _BPEMCaseReversalReason.BPEMCaseReversalReason  -- association [0..1]
LEFT OUTER JOIN I_User AS _BPEMCaseCreatedByUser ON BPEMCaseCreatedByUser = _BPEMCaseCreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _BPEMCaseLastChangedByUser ON BPEMCaseLastChangedByUser = _BPEMCaseLastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BPEMCaseCustomStatus AS _BPEMCaseCustomStatus ON BPEMCaseCustomStatus = _BPEMCaseCustomStatus.BPEMCaseCustomStatus  -- association [0..1]
;