P_JOURNALENTRYITEMHISTORY

CDS View

Change History Line Item Entry View

P_JOURNALENTRYITEMHISTORY is a CDS View in S/4HANA. Change History Line Item Entry View. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_JournalEntryHistory view inner COMPOSITE Journal Entry History Export as CDS Service

Fields (3)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
CreationTime CreationTime 1 
@AbapCatalog.sqlViewName: 'PFIGLJNITEMHIST'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'AccountingDocument'
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true

define view P_JournalEntryItemHistory
  as select from    I_OperationalAcctgDocItem as bseg
    left outer join I_JournalEntry            as bkpf on  bseg.CompanyCode        = bkpf.CompanyCode
                                                      and bseg.FiscalYear         = bkpf.FiscalYear
                                                      and bseg.AccountingDocument = bkpf.AccountingDocument
{
  key    bseg.CompanyCode,
  key    bseg.AccountingDocument,
  key    bseg.FiscalYear,
  key    cast(bseg.AccountingDocumentItem as  docln6)                                                                                        as AccountingDocumentItem,
         bkpf.Ledger,
         bkpf.PostingDate,
         bkpf.DocumentDate,
         CreationTime                                                                                                                        as timestamp,
         CreationTime,
         AccountingDocumentCreationDate,
         replace(replace(concat( bseg.mandt, concat( rpad(bseg.CompanyCode, 4, '|'), concat( bseg.AccountingDocument, bseg.FiscalYear))), '|', '| |'), '|', '')                                   as objectid,
         replace(replace(concat( bseg.mandt, concat( rpad(bseg.CompanyCode, 4, '|'), concat( bseg.AccountingDocument, concat( bseg.FiscalYear , AccountingDocumentItem)))), '|', '| |'), '|', '') as tabkey,
         bseg.FinancialAccountType,
         bseg.GLAccount,
         bseg.AccountingDocumentCategory,
         bseg.AccountingDocumentType
}
where
  bseg.AccountingDocumentCategory <> 'C'

Learn More