P_GLDisplayItemChangeLogItm

DDL: P_GLDISPLAYITEMCHANGELOGITM Type: view_entity CONSUMPTION Package: ODATA_GL_OVP

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.

2 data source(s) 15 fields

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
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
KEY DatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
CompanyCode
Ledger
AccountingDocument
AccountingDocumentItem
FiscalYear
UserName I_ChangeDocument CreatedByUser
LastChangeDate I_ChangeDocument CreationDate
LastChangeTime I_ChangeDocument CreationTime
OldFieldContent I_ChangeDocumentItem ChangeDocPreviousFieldValue
NewFieldContent I_ChangeDocumentItem ChangeDocNewFieldValue 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true

define view entity P_GLDisplayItemChangeLogItm
  as select from I_ChangeDocumentItem as ChangeDocumentItem
    inner join   I_ChangeDocument     as ChangeDocumentHeader on  ChangeDocumentItem.ChangeDocObjectClass = ChangeDocumentHeader.ChangeDocObjectClass
                                                              and ChangeDocumentItem.ChangeDocObject      = ChangeDocumentHeader.ChangeDocObject
                                                              and ChangeDocumentItem.ChangeDocument       = ChangeDocumentHeader.ChangeDocument

{
  key ChangeDocumentItem.ChangeDocObject,
  key ChangeDocumentItem.ChangeDocument,
  key ChangeDocumentItem.DatabaseTable,
  key ChangeDocumentItem.ChangeDocTableKey,
  key 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
}
where
  (
        ChangeDocumentHeader.ChangeDocObjectClass = 'BELEG'
    and ChangeDocumentItem.DatabaseTable        = 'ACDOCA'
  )

Learn More