P_ADDLLEDGERDOCHEADERHISTORY

CDS View

Change History Header non-leading Ledger

P_ADDLLEDGERDOCHEADERHISTORY is a CDS View in S/4HANA. Change History Header non-leading Ledger. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

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

Fields (4)

KeyField CDS FieldsUsed in Views
KEY AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentType AccountingDocumentType 1
CreationTime CreationTime 1 
@AbapCatalog.sqlViewName: 'PADLEDHEADTRKDOC'
@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_AddlLedgerDocHeaderHistory
  as select from I_JournalEntry as bkpf
{
  key    bkpf.CompanyCode,
  key    bkpf.AccountingDocument,
  key    bkpf.FiscalYear,
         ''                                                                                                                as AccountingDocumentItem,
         bkpf.Ledger,
         bkpf.PostingDate,
         bkpf.DocumentDate,
         CreationTime                                                                                                      as timestamp,
         CreationTime,
         AccountingDocumentCreationDate,
         replace(replace(concat( bkpf.mandt, concat( rpad(bkpf.CompanyCode, 4, '|'), concat( bkpf.AccountingDocument, bkpf.FiscalYear))), '|', '| |'), '|', '')                 as objectid,
         replace(replace(concat( bkpf.mandt, concat( rpad(bkpf.CompanyCode, 4, '|'), concat( bkpf.AccountingDocument, FiscalYear))), '|', '| |'), '|', '')                      as bkpf_tabkey,
         ''                                                                                                                as FinancialAccountType,
         ''                                                                                                                as GLAccount,
         bkpf.AccountingDocumentType,
         bkpf.AccountingDocumentCategory
}
where
  AccountingDocumentCategory = 'L'

Learn More