CRMS4_IU_I_EC

DDL: CRMS4_IU_I_EC Type: view_entity
37 Fields 1 Data Sources

Utilities Clarification Case

CRMS4_IU_I_EC is a CDS View that provides data about "Utilities Clarification Case" in SAP S/4HANA. It reads from 1 data source (I_BPEMCase) and exposes 37 fields with key field BPEMCase.

Data Sources (1)

SourceAliasJoin Type
I_BPEMCase I_BPEMCase from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Utilities Clarification Case view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (37)

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
_BPEMBusinessProcessCode _BPEMBusinessProcessCode
_BPEMCaseActor _BPEMCaseActor
_BPEMCaseCategory _BPEMCaseCategory
_BPEMCaseCreatedByUser _BPEMCaseCreatedByUser
_BPEMCaseForwardReason _BPEMCaseForwardReason
_BPEMCaseLastChangedByUser _BPEMCaseLastChangedByUser
_BPEMCaseMessage _BPEMCaseMessage
_BPEMCaseObject _BPEMCaseObject
_BPEMCasePriority _BPEMCasePriority
_BPEMCaseReversalReason _BPEMCaseReversalReason
_BPEMCaseStatus _BPEMCaseStatus
_BPEMCaseType _BPEMCaseType

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 CRMS4_IU_I_EC.
-- 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 CRMS4_IU_I_EC 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
FROM I_BPEMCase
;

Learn More