P_GLDisplayItemChangeLogHdr1

DDL: P_GLDISPLAYITEMCHANGELOGHDR1 Type: view_entity CONSUMPTION Package: ODATA_GL_OVP

Display G/L Item ChangeLog Ovw

P_GLDisplayItemChangeLogHdr1 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 13 fields with key fields ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocTableKey, DatabaseTableField. Part of development package ODATA_GL_OVP.

2 data source(s) 13 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 (13)

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
AccountingDocument
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_GLDisplayItemChangeLogHdr1
  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, 4, 4)                     as CompanyCode,
      substring(ChangeDocumentItem.ChangeDocTableKey, 8, 10)                    as AccountingDocument,
      cast(substring(ChangeDocumentItem.ChangeDocTableKey, 18, 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               =  'BKPF'
    and ChangeDocumentItem.ChangeDocDatabaseTableField != 'AEDAT'
  )

Learn More