C_BPEMCaseTP_2

DDL: C_BPEMCASETP_2 Type: view_entity CONSUMPTION
51 Fields 1 Data Sources

Processing of Clarification Cases

C_BPEMCaseTP_2 is a Consumption CDS View that provides data about "Processing of Clarification Cases" in SAP S/4HANA. It reads from 1 data source (I_BPEMCaseTP) and exposes 51 fields with key field BPEMCase.

Data Sources (1)

SourceAliasJoin Type
I_BPEMCaseTP I_BPEMCaseTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Processing of Clarification Cases view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
OData.entityType.name BPEMCase_Type view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY BPEMCase BPEMCase
BPEMBusinessProcessCode BPEMBusinessProcessCode
BPEMBusinessProcessCodeNamelocalized
BPEMBusinessProcessArea BPEMCaseTP BPEMBusinessProcessArea
BPEMBusinessProcessAreaNamelocalized
BPEMCaseType BPEMCaseType
BPEMCaseStatus BPEMCaseStatus
BPEMCaseStatusNamelocalized
BPEMCaseCategory BPEMCaseCategory
BPEMCaseCategoryNamelocalized
BPEMCasePriority BPEMCasePriority
BPEMCasePriorityNamelocalized
AuthorizationGroup AuthorizationGroup AuthorizGroup
BPEMCaseMainObjectType BPEMCaseMainObjectType
BPEMCaseMainObject BPEMCaseMainObject
BPEMCaseOriginalDate BPEMCaseOriginalDate
BPEMCaseOriginalTime BPEMCaseOriginalTime
BPEMCaseCurrentProcessor BPEMCaseCurrentProcessor
BPEMCaseForwardingReason BPEMCaseForwardingReason
BPEMCaseForwardingReasonNamelocalized
BPEMCaseReversalReason BPEMCaseReversalReason
BPEMCaseReversalReasonNamelocalized
BPEMCasePreviousProcessor BPEMCasePreviousProcessor
BPEMCaseDueDate BPEMCaseDueDate
BPEMCaseDueTime BPEMCaseDueTime
BPEMCaseNoteIsExisting BPEMCaseNoteIsExisting
BPEMCaseName BPEMCaseName
BPEMCaseCreationDate BPEMCaseCreationDate
BPEMCaseCreationTime BPEMCaseCreationTime
BPEMCaseCreatedByUser BPEMCaseCreatedByUser
BPEMCaseLastChangedDate BPEMCaseLastChangedDate
BPEMCaseLastChangedTime BPEMCaseLastChangedTime
BPEMCaseLastChangedByUser BPEMCaseLastChangedByUser
BPEMCaseCustomStatus BPEMCaseCustomStatus
BPEMCaseCustomStatusNamelocalized
_BPEMBusinessProcessCode _BPEMBusinessProcessCode
_BPEMCaseActor _BPEMCaseActor
_BPEMCaseCategory _BPEMCaseCategory
_BPEMCaseCreatedByUser _BPEMCaseCreatedByUser
_BPEMCaseForwardReason _BPEMCaseForwardReason
_BPEMCaseLastChangedByUser _BPEMCaseLastChangedByUser
_BPEMCaseMessage _BPEMCaseMessage
_BPEMCaseObject _BPEMCaseObject
_BPEMCasePriority _BPEMCasePriority
_BPEMCaseReversalReason _BPEMCaseReversalReason
_BPEMCaseStatus _BPEMCaseStatus
_BPEMCaseType _BPEMCaseType
_PreviousUser _PreviousUser
_User _User
_BPEMBusinessProcessArea _BPEMBusinessProcessArea
_BPEMCaseCustomStatus _BPEMCaseCustomStatus

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 C_BPEMCaseTP_2.
-- 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 C_BPEMCaseTP_2 AS
SELECT
  BPEMCase,
  BPEMBusinessProcessCode,
  _BPEMBusinessProcessCode._Text.BPEMBusinessProcessCodeName : localized AS BPEMBusinessProcessCodeNamelocalized,
  BPEMCaseTP.BPEMBusinessProcessArea AS BPEMBusinessProcessArea,
  _BPEMBusinessProcessArea._Text.BPEMBusinessProcessAreaName : localized AS BPEMBusinessProcessAreaNamelocalized,
  BPEMCaseType,
  BPEMCaseStatus,
  _BPEMCaseStatus._Text.BPEMCaseStatusName : localized AS BPEMCaseStatusNamelocalized,
  BPEMCaseCategory,
  _BPEMCaseCategory._Text.BPEMCaseCategoryName : localized AS BPEMCaseCategoryNamelocalized,
  BPEMCasePriority,
  _BPEMCasePriority._Text.BPEMCasePriorityName : localized AS BPEMCasePriorityNamelocalized,
  AuthorizationGroup,
  BPEMCaseMainObjectType,
  BPEMCaseMainObject,
  BPEMCaseOriginalDate,
  BPEMCaseOriginalTime,
  BPEMCaseCurrentProcessor,
  BPEMCaseForwardingReason,
  _BPEMCaseForwardReason._Text.BPEMCaseForwardingReasonName : localized AS BPEMCaseForwardingReasonNamelocalized,
  BPEMCaseReversalReason,
  _BPEMCaseReversalReason._Text.BPEMCaseReversalReasonName : localized AS BPEMCaseReversalReasonNamelocalized,
  BPEMCasePreviousProcessor,
  BPEMCaseDueDate,
  BPEMCaseDueTime,
  BPEMCaseNoteIsExisting,
  BPEMCaseName,
  BPEMCaseCreationDate,
  BPEMCaseCreationTime,
  BPEMCaseCreatedByUser,
  BPEMCaseLastChangedDate,
  BPEMCaseLastChangedTime,
  BPEMCaseLastChangedByUser,
  BPEMCaseCustomStatus,
  _BPEMCaseCustomStatus._Text.BPEMCaseCustomStatusName : localized AS BPEMCaseCustomStatusNamelocalized
FROM I_BPEMCaseTP
;

Learn More