C_JournalCaseHistory

DDL: C_JOURNALCASEHISTORY Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

Journal Case History

C_JournalCaseHistory is a Consumption CDS View that provides data about "Journal Case History" in SAP S/4HANA. It reads from 1 data source (R_JournalCaseHistory) and exposes 21 fields with key fields JournalCaseUUID, JournalCaseObjectUUID, JournalCase, ChangeDocument, DatabaseTable.

Data Sources (1)

SourceAliasJoin Type
R_JournalCaseHistory _History from

Annotations (9)

NameValueLevelField
EndUserText.label Journal Case History view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #MANDATORY view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY JournalCaseUUID JournalCaseUUID UUID
KEY JournalCaseObjectUUID JournalCaseObjectUUID
KEY JournalCase JournalCase Case ID
KEY ChangeDocument ChangeDocument Document Number
KEY DatabaseTable DatabaseTable Table Name
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
JournalCaseCategory JournalCaseCategory Category Code
JournalCaseSubcategory JournalCaseSubcategory Subcategory Code
CnsldtnLfcycOperationTypeText CnsldtnLfcycOperationTypeText
ChangedBy ChangedBy User Name
ChangedByUserName
LastChangeTime R_JournalCaseHistory LastChangeTime Time changed
OldFieldContent R_JournalCaseHistory OldFieldContent
NewFieldContent R_JournalCaseHistory NewFieldContent
LastChangeDate R_JournalCaseHistory LastChangeDate Time Stamp
LastChangeDateTime R_JournalCaseHistory LastChangeDateTime Timestamp
ChangeDocDatabaseTblFieldText
ChangeDocOldFieldValueText
ChangeDocNewFieldValueText
_ChangedByContactCard _ChangedByContactCard

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_JournalCaseHistory.
-- 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_JournalCaseHistory AS
SELECT
  JournalCaseUUID,
  JournalCaseObjectUUID,
  JournalCase,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  JournalCaseCategory,
  JournalCaseSubcategory,
  CnsldtnLfcycOperationTypeText,
  ChangedBy,
  _History._ChangedByContactCard.FullName AS ChangedByUserName,
  _History.LastChangeTime AS LastChangeTime,
  _History.OldFieldContent AS OldFieldContent,
  _History.NewFieldContent AS NewFieldContent,
  _History.LastChangeDate AS LastChangeDate,
  _History.LastChangeDateTime AS LastChangeDateTime,
  cast( '' as abap.char( 30 ) ) AS ChangeDocDatabaseTblFieldText,
  cast( '' as fac_mje_fieldval_old ) AS ChangeDocOldFieldValueText,
  cast( '' as fac_mje_fieldval_new ) AS ChangeDocNewFieldValueText
FROM R_JournalCaseHistory AS _History
;

Learn More