I_JournalCasePostingPolicyHist

DDL: I_JOURNALCASEPOSTINGPOLICYHIST Type: view_entity BASIC
16 Fields 3 Data Sources

Journal Case Posting Policy History

I_JournalCasePostingPolicyHist is a Basic CDS View that provides data about "Journal Case Posting Policy History" in SAP S/4HANA. It reads from 3 data sources (I_ChangeDocument, I_ChangeDocument_2, I_JournalCasePostingPolicy) and exposes 16 fields with key fields JournalCasePolicyUUID, JournalCasePolicyObjectUUID, JournalCasePolicy, ChangeDocument, DatabaseTable.

Data Sources (3)

SourceAliasJoin Type
I_ChangeDocument cdhdr inner
I_ChangeDocument_2 cdpos inner
I_JournalCasePostingPolicy policy from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Journal Case Posting Policy History view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY JournalCasePolicyUUID I_JournalCasePostingPolicy JournalCasePolicyUUID UUID
KEY JournalCasePolicyObjectUUID I_JournalCasePostingPolicy JournalCasePolicyObjectUUID
KEY JournalCasePolicy I_JournalCasePostingPolicy JournalCasePolicy Policy ID
KEY ChangeDocument I_ChangeDocument_2 ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocument_2 ChangeDocDatabaseTable Table/Constant Value
KEY ChangeDocTableKey I_ChangeDocument_2 ChangeDocShortTableKey Table Keys
KEY ChangeDocDatabaseTableField I_ChangeDocument_2 ChangeDocDatabaseTableField User
JournalCasePolicyVersion I_JournalCasePostingPolicy JournalCasePolicyVersion Version
JournalCaseSubcategory I_JournalCasePostingPolicy JournalCaseSubcategory Subcategory Code
JournalCaseCategory I_JournalCasePostingPolicy JournalCaseCategory Category Code
UserName I_ChangeDocument CreatedByUser User Name
LastChangeTime I_ChangeDocument CreationTime Time of Change
OldFieldContent I_ChangeDocument_2 ChangeDocPreviousFieldValue
NewFieldContent I_ChangeDocument_2 ChangeDocNewFieldValue
LastChangeDate I_ChangeDocument CreationDate Time Stamp
CnsldtnLfcycOperationTypeText

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 I_JournalCasePostingPolicyHist.
-- 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 I_JournalCasePostingPolicyHist AS
SELECT
  policy.JournalCasePolicyUUID AS JournalCasePolicyUUID,
  policy.JournalCasePolicyObjectUUID AS JournalCasePolicyObjectUUID,
  policy.JournalCasePolicy AS JournalCasePolicy,
  cdpos.ChangeDocument AS ChangeDocument,
  cdpos.ChangeDocDatabaseTable AS DatabaseTable,
  cdpos.ChangeDocShortTableKey AS ChangeDocTableKey,
  cdpos.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  policy.JournalCasePolicyVersion AS JournalCasePolicyVersion,
  policy.JournalCaseSubcategory AS JournalCaseSubcategory,
  policy.JournalCaseCategory AS JournalCaseCategory,
  cdhdr.CreatedByUser AS UserName,
  cdhdr.CreationTime AS LastChangeTime,
  cdpos.ChangeDocPreviousFieldValue AS OldFieldContent,
  cdpos.ChangeDocNewFieldValue AS NewFieldContent,
  cdhdr.CreationDate AS LastChangeDate,
  cdpos._ChangeTypeText[Language = $session.system_language ].Text AS CnsldtnLfcycOperationTypeText
FROM I_JournalCasePostingPolicy AS policy
INNER JOIN I_ChangeDocument AS cdhdr ON /* join condition not captured in parsed metadata */
INNER JOIN I_ChangeDocument_2 AS cdpos ON /* join condition not captured in parsed metadata */
;

Learn More