I_BPEMCaseTP

DDL: I_BPEMCASETP Type: view_entity TRANSACTIONAL
43 Fields 1 Data Sources 3 Associations

BPEM Case

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

Data Sources (1)

SourceAliasJoin Type
I_BPEMCase BPEMCase from

Associations (3)

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

Annotations (9)

NameValueLevelField
EndUserText.label BPEM Case view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name BPEMClarificationCase view

Fields (43)

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
AuthorizationGroup AuthorizationGroup AuthorizGroup
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
BPEMCaseCustomStatus BPEMCaseCustomStatus Substatus
BPEMBusinessProcessArea
_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
_BPEMCaseStatus I_BPEMCase _BPEMCaseStatus
_BPEMCaseType I_BPEMCase _BPEMCaseType
_BPEMBusinessProcessArea
_BPEMCaseCustomStatus I_BPEMCase _BPEMCaseCustomStatus
_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_BPEMCaseTP.
-- 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.

CREATE VIEW I_BPEMCaseTP AS
SELECT
  BPEMCase,
  BPEMBusinessProcessCode,
  BPEMCaseType,
  BPEMCaseStatus,
  BPEMCaseCategory,
  BPEMCasePriority,
  AuthorizationGroup,
  BPEMCaseMainObjectType,
  BPEMCaseMainObject,
  BPEMCaseOriginalDate,
  BPEMCaseOriginalTime,
  BPEMCaseCurrentProcessor,
  BPEMCaseForwardingReason,
  BPEMCaseReversalReason,
  BPEMCasePreviousProcessor,
  BPEMCaseDueDate,
  BPEMCaseDueTime,
  BPEMCaseNoteIsExisting,
  BPEMCaseName,
  BPEMCaseCreationDate,
  BPEMCaseCreationTime,
  BPEMCaseCreatedByUser,
  BPEMCaseLastChangedDate,
  BPEMCaseLastChangedTime,
  BPEMCaseLastChangedByUser,
  BPEMCaseCustomStatus,
  BPEMCase._BPEMBusinessProcessCode.BPEMBusinessProcessArea AS BPEMBusinessProcessArea,
  BPEMCase._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  BPEMCase._BPEMCaseActor AS _BPEMCaseActor,
  BPEMCase._BPEMCaseCategory AS _BPEMCaseCategory,
  BPEMCase._BPEMCaseCreatedByUser AS _BPEMCaseCreatedByUser,
  BPEMCase._BPEMCaseForwardReason AS _BPEMCaseForwardReason,
  BPEMCase._BPEMCaseLastChangedByUser AS _BPEMCaseLastChangedByUser,
  BPEMCase._BPEMCaseMessage AS _BPEMCaseMessage,
  BPEMCase._BPEMCaseObject AS _BPEMCaseObject,
  BPEMCase._BPEMCasePriority AS _BPEMCasePriority,
  BPEMCase._BPEMCaseReversalReason AS _BPEMCaseReversalReason,
  BPEMCase._BPEMCaseStatus AS _BPEMCaseStatus,
  BPEMCase._BPEMCaseType AS _BPEMCaseType,
  BPEMCase._BPEMBusinessProcessCode._BPEMBusinessProcessArea AS _BPEMBusinessProcessArea,
  BPEMCase._BPEMCaseCustomStatus AS _BPEMCaseCustomStatus
FROM I_BPEMCase AS 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]
LEFT OUTER JOIN E_BPEMClrfctnCase AS _BPEMClrfctnCaseExtension ON BPEMCase = _BPEMClrfctnCaseExtension.BPEMCase  -- association [0..1]
;

Learn More