C_BPEMCaseTP

DDL: C_BPEMCASETP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

BPEM Case

C_BPEMCaseTP is a Consumption CDS View that provides data about "BPEM Case" in SAP S/4HANA. It reads from 1 data source (I_BPEMCaseTP) and exposes 23 fields with key field BPEMCase.

Data Sources (1)

SourceAliasJoin Type
I_BPEMCaseTP I_BPEMCaseTP projection

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label BPEM Case view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY BPEMCase
BPEMCaseMainObject BPEMCaseTP BPEMCaseMainObject
BPEMBusinessProcessCode BPEMCaseTP BPEMBusinessProcessCode
BPEMCaseStatus BPEMCaseTP BPEMCaseStatus
BPEMCaseCategory BPEMCaseTP BPEMCaseCategory
BPEMCasePriority BPEMCaseTP BPEMCasePriority
AuthorizationGroup BPEMCaseTP AuthorizationGroup AuthorizGroup
BPEMCaseMainObjectType BPEMCaseTP BPEMCaseMainObjectType
BPEMCaseOriginalDate BPEMCaseTP BPEMCaseOriginalDate
BPEMCaseCurrentProcessor BPEMCaseTP BPEMCaseCurrentProcessor
BPEMCasePreviousProcessor
UserDescription _User UserDescription Full Name
LastChangedByUserDescription _PreviousUser UserDescription Full Name
BPEMCaseForwardingReason BPEMCaseTP BPEMCaseForwardingReason
BPEMCaseDueDate BPEMCaseTP BPEMCaseDueDate
BPEMCaseCreationDate BPEMCaseTP BPEMCaseCreationDate
_BPEMBusinessProcessCode BPEMCaseTP _BPEMBusinessProcessCode
_BPEMCaseCategory BPEMCaseTP _BPEMCaseCategory
_BPEMCasePriority BPEMCaseTP _BPEMCasePriority
_BPEMCaseStatus BPEMCaseTP _BPEMCaseStatus
_BPEMCaseForwardReason BPEMCaseTP _BPEMCaseForwardReason
_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 C_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 C_BPEMCaseTP AS
SELECT
  cast( BPEMCaseTP.BPEMCase as e_clarificationcase_vdm preserving type ) AS BPEMCase,
  BPEMCaseTP.BPEMCaseMainObject AS BPEMCaseMainObject,
  BPEMCaseTP.BPEMBusinessProcessCode AS BPEMBusinessProcessCode,
  BPEMCaseTP.BPEMCaseStatus AS BPEMCaseStatus,
  BPEMCaseTP.BPEMCaseCategory AS BPEMCaseCategory,
  BPEMCaseTP.BPEMCasePriority AS BPEMCasePriority,
  BPEMCaseTP.AuthorizationGroup AS AuthorizationGroup,
  BPEMCaseTP.BPEMCaseMainObjectType AS BPEMCaseMainObjectType,
  BPEMCaseTP.BPEMCaseOriginalDate AS BPEMCaseOriginalDate,
  BPEMCaseTP.BPEMCaseCurrentProcessor AS BPEMCaseCurrentProcessor,
  cast( BPEMCaseTP.BPEMCasePreviousProcessor as e_clarcaseprevproc_vdm preserving type ) AS BPEMCasePreviousProcessor,
  _User.UserDescription AS UserDescription,
  _PreviousUser.UserDescription AS LastChangedByUserDescription,
  BPEMCaseTP.BPEMCaseForwardingReason AS BPEMCaseForwardingReason,
  BPEMCaseTP.BPEMCaseDueDate AS BPEMCaseDueDate,
  BPEMCaseTP.BPEMCaseCreationDate AS BPEMCaseCreationDate,
  BPEMCaseTP._BPEMBusinessProcessCode AS _BPEMBusinessProcessCode,
  BPEMCaseTP._BPEMCaseCategory AS _BPEMCaseCategory,
  BPEMCaseTP._BPEMCasePriority AS _BPEMCasePriority,
  BPEMCaseTP._BPEMCaseStatus AS _BPEMCaseStatus,
  BPEMCaseTP._BPEMCaseForwardReason AS _BPEMCaseForwardReason
FROM I_BPEMCaseTP
;

Learn More