I_OpenBPEMCase

DDL: I_OPENBPEMCASE SQL: IEOPENBPEM Type: view COMPOSITE
40 Fields 1 Data Sources 2 Associations

Open BPEM Case

I_OpenBPEMCase is a Composite CDS View that provides data about "Open BPEM Case" in SAP S/4HANA. It reads from 1 data source (I_BPEMCase) and exposes 40 fields with key field BPEMCase. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BPEMCase I_BPEMCase from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_User _User $projection.BPEMCaseCurrentProcessor = _User.UserID
[0..1] I_User _PreviousUser $projection.BPEMCasePreviousProcessor = _PreviousUser.UserID

Annotations (10)

NameValueLevelField
EndUserText.label Open BPEM Case view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IEOPENBPEM view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BPEMCase BPEMCase Case
BPEMBusinessProcessCode BPEMBusinessProcessCode BusinessProcess
BPEMCaseType BPEMCaseType Type
BPEMCaseStatus BPEMCaseStatus Workflow Status
BPEMCaseCategory BPEMCaseCategory Case Category
BPEMCasePriority BPEMCasePriority Profile priority
BPEMCaseMainObjectType BPEMCaseMainObjectType Prim.ObjectType
BPEMCaseMainObject BPEMCaseMainObject Key
BPEMCaseOriginalDate BPEMCaseOriginalDate Original Date
BPEMCaseOriginalTime BPEMCaseOriginalTime Original Time
BPEMCaseCurrentProcessor BPEMCaseCurrentProcessor Processor
BPEMCaseForwardingReason BPEMCaseForwardingReason Forwarding Reason
BPEMCaseReversalReason BPEMCaseReversalReason Reversal Reason
BPEMCasePreviousProcessor BPEMCasePreviousProcessor Prev. Processor
BPEMCaseDueDate BPEMCaseDueDate Net Due Date
BPEMCaseDueTime BPEMCaseDueTime Due Time
BPEMCaseNoteIsExisting BPEMCaseNoteIsExisting Note Entered
BPEMCaseName BPEMCaseName Case Text
BPEMCaseCreationDate BPEMCaseCreationDate Time Stamp
BPEMCaseCreationTime BPEMCaseCreationTime Time Stamp
BPEMCaseCreatedByUser BPEMCaseCreatedByUser Version Created By
BPEMCaseLastChangedDate BPEMCaseLastChangedDate Changed on
BPEMCaseLastChangedTime BPEMCaseLastChangedTime Time Stamp
BPEMCaseLastChangedByUser BPEMCaseLastChangedByUser User Name
AuthorizationGroup AuthorizationGroup AuthorizGroup
BPEMCaseAndDateTime
_BPEMBusinessProcessCode I_BPEMCase _BPEMBusinessProcessCode
_BPEMCaseActor I_BPEMCase _BPEMCaseActor
_BPEMCaseCategory I_BPEMCase _BPEMCaseCategory
_BPEMCaseCreatedByUser I_BPEMCase _BPEMCaseCreatedByUser
_BPEMCaseForwardReason I_BPEMCase _BPEMCaseForwardReason
_BPEMCaseLastChangedByUser I_BPEMCase _BPEMCaseLastChangedByUser
_BPEMCaseMessage I_BPEMCase _BPEMCaseMessage
_BPEMCaseObject I_BPEMCase _BPEMCaseObject
_BPEMCasePriority I_BPEMCase _BPEMCasePriority
_BPEMCaseReversalReason I_BPEMCase _BPEMCaseReversalReason
_BPEMCaseType I_BPEMCase _BPEMCaseType
_BPEMCaseStatus I_BPEMCase _BPEMCaseStatus
_User _User
_PreviousUser _PreviousUser

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_OpenBPEMCase.
-- 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: IEOPENBPEM

CREATE VIEW I_OpenBPEMCase AS
SELECT
  BPEMCase,
  BPEMBusinessProcessCode,
  BPEMCaseType,
  BPEMCaseStatus,
  BPEMCaseCategory,
  BPEMCasePriority,
  BPEMCaseMainObjectType,
  BPEMCaseMainObject,
  BPEMCaseOriginalDate,
  BPEMCaseOriginalTime,
  BPEMCaseCurrentProcessor,
  BPEMCaseForwardingReason,
  BPEMCaseReversalReason,
  BPEMCasePreviousProcessor,
  BPEMCaseDueDate,
  BPEMCaseDueTime,
  BPEMCaseNoteIsExisting,
  BPEMCaseName,
  BPEMCaseCreationDate,
  BPEMCaseCreationTime,
  BPEMCaseCreatedByUser,
  BPEMCaseLastChangedDate,
  BPEMCaseLastChangedTime,
  BPEMCaseLastChangedByUser,
  AuthorizationGroup,
  CONCAT( CONCAT(BPEMCaseCreationDate, BPEMCaseCreationTime), BPEMCase) AS BPEMCaseAndDateTime,
  I_BPEMCase._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  I_BPEMCase._BPEMCaseActor AS _BPEMCaseActor,
  I_BPEMCase._BPEMCaseCategory AS _BPEMCaseCategory,
  I_BPEMCase._BPEMCaseCreatedByUser AS _BPEMCaseCreatedByUser,
  I_BPEMCase._BPEMCaseForwardReason AS _BPEMCaseForwardReason,
  I_BPEMCase._BPEMCaseLastChangedByUser AS _BPEMCaseLastChangedByUser,
  I_BPEMCase._BPEMCaseMessage AS _BPEMCaseMessage,
  I_BPEMCase._BPEMCaseObject AS _BPEMCaseObject,
  I_BPEMCase._BPEMCasePriority AS _BPEMCasePriority,
  I_BPEMCase._BPEMCaseReversalReason AS _BPEMCaseReversalReason,
  I_BPEMCase._BPEMCaseType AS _BPEMCaseType,
  I_BPEMCase._BPEMCaseStatus AS _BPEMCaseStatus
FROM I_BPEMCase
LEFT OUTER JOIN I_User AS _User ON BPEMCaseCurrentProcessor = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _PreviousUser ON BPEMCasePreviousProcessor = _PreviousUser.UserID  -- association [0..1]
;

Learn More