C_JournalCaseApplicationLogTP

DDL: C_JOURNALCASEAPPLICATIONLOGTP Type: view_entity CONSUMPTION
16 Fields 1 Data Sources

Jrnl Case App Log Consumption

C_JournalCaseApplicationLogTP is a Consumption CDS View that provides data about "Jrnl Case App Log Consumption" in SAP S/4HANA. It reads from 1 data source (R_JournalCaseApplicationLogTP) and exposes 16 fields with key field JournalCaseApplicationLogUUID.

Data Sources (1)

SourceAliasJoin Type
R_JournalCaseApplicationLogTP R_JournalCaseApplicationLogTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Jrnl Case App Log Consumption view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY JournalCaseApplicationLogUUID JournalCaseApplicationLogUUID
JournalCaseUUID JournalCaseUUID UUID
JrnlCaseApplicationLogHandle JrnlCaseApplicationLogHandle
ApplicationLogObject ApplicationLogObject
ApplicationLogSubobject ApplicationLogSubobject
LogNumber LogNumber UUID
CreatedByUser CreatedByUser User Name
SeverityText SeverityText
SystemMessageType SystemMessageType Message type
ApplicationLogSubObjectText ApplicationLogSubObjectText
CreationDate CreationDate Time Stamp
CreationDateTime CreationDateTime Timestamp
JournalCase _Case JournalCase Case ID
CreatedByUserName _CreatedByUser UserDescription Full Name
JournalCaseStatus _Case JournalCaseStatus Case Status
_Case _Case

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_JournalCaseApplicationLogTP.
-- 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_JournalCaseApplicationLogTP AS
SELECT
  JournalCaseApplicationLogUUID,
  JournalCaseUUID,
  JrnlCaseApplicationLogHandle,
  ApplicationLogObject,
  ApplicationLogSubobject,
  LogNumber,
  CreatedByUser,
  SeverityText,
  SystemMessageType,
  ApplicationLogSubObjectText,
  CreationDate,
  CreationDateTime,
  _Case.JournalCase AS JournalCase,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _Case.JournalCaseStatus AS JournalCaseStatus
FROM R_JournalCaseApplicationLogTP
;

Learn More