P_GLDisplayItemChangeLogItm

DDL: P_GLDISPLAYITEMCHANGELOGITM Type: view_entity CONSUMPTION Package: ODATA_GL_OVP
15 Fields 2 Data Sources

Display G/L Item ChangeLog Ovw

P_GLDisplayItemChangeLogItm is a Consumption CDS View that provides data about "Display G/L Item ChangeLog Ovw" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocument, I_ChangeDocumentItem) and exposes 15 fields with key fields ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocTableKey, DatabaseTableField. Part of development package ODATA_GL_OVP.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocument ChangeDocumentHeader inner
I_ChangeDocumentItem ChangeDocumentItem from

Annotations (4)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject Object Value
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey Table Keys
KEY DatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
CompanyCode
Ledger
AccountingDocument
AccountingDocumentItem
FiscalYear
UserName I_ChangeDocument CreatedByUser User Name
LastChangeDate I_ChangeDocument CreationDate Time Stamp
LastChangeTime I_ChangeDocument CreationTime Time of Change
OldFieldContent I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Value
NewFieldContent I_ChangeDocumentItem ChangeDocNewFieldValue New Value

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 P_GLDisplayItemChangeLogItm.
-- 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 P_GLDisplayItemChangeLogItm AS
SELECT
  ChangeDocumentItem.ChangeDocObject AS ChangeDocObject,
  ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  ChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  ChangeDocumentItem.ChangeDocDatabaseTableField AS DatabaseTableField,
  substring(ChangeDocumentItem.ChangeDocTableKey, 6, 4) AS CompanyCode,
  substring(ChangeDocumentItem.ChangeDocTableKey, 4, 2) AS Ledger,
  substring(ChangeDocumentItem.ChangeDocTableKey, 14, 10) AS AccountingDocument,
  substring(ChangeDocumentItem.ChangeDocTableKey, 24, 6) AS AccountingDocumentItem,
  cast(substring(ChangeDocumentItem.ChangeDocTableKey, 10, 4) as fis_gjahr) AS FiscalYear,
  ChangeDocumentHeader.CreatedByUser AS UserName,
  ChangeDocumentHeader.CreationDate AS LastChangeDate,
  ChangeDocumentHeader.CreationTime AS LastChangeTime,
  ChangeDocumentItem.ChangeDocPreviousFieldValue AS OldFieldContent,
  ChangeDocumentItem.ChangeDocNewFieldValue AS NewFieldContent
FROM I_ChangeDocumentItem AS ChangeDocumentItem
INNER JOIN I_ChangeDocument AS ChangeDocumentHeader ON /* join condition not captured in parsed metadata */
;

Learn More