FISCDS_TRK_DOC_05

CDS View

Change History from non-leading Ledger

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

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FISVD_TRK_DOC_11 view inner Journal Entry History Convert GS Fields

Fields (1)

KeyField CDS FieldsUsed in Views
KEY JournalEntryItem JournalEntryItem 1 
@AbapCatalog.sqlViewName: 'FISCDSTRKDOC05'
@EndUserText.label: 'Change History from non-leading Ledger'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view FISCDS_TRK_DOC_05
  as select from bkpf
{
  key    bkpf.bukrs                                                                                as CompanyCode,
  key    bkpf.belnr                                                                                as AccountingDocument,
  key    bkpf.gjahr                                                                                as FiscalYear,
         cast('' as  docln6)                                                                       as JournalEntryItem,
         bkpf.rldnr                                                                                as Ledger,
         bkpf.budat                                                                                as PostingDate,
         bldat                                                                                     as DocumentDate,
         cputm                                                                                     as timestamp,
         cputm                                                                                     as CreationTime,
         cpudt                                                                                     as CreationDate,
         // n2736524 support for Company Codes with less than four characters (preserve trailing spaces)

         replace(replace(concat( bkpf.mandt, concat(rpad(bkpf.bukrs, 4, '|'), concat( bkpf.belnr, bkpf.gjahr))), '|', '| |'), '|', '')
             as objectid,
         replace(replace(concat( bkpf.mandt, concat(rpad(bkpf.bukrs, 4, '|'), concat( bkpf.belnr, bkpf.gjahr))), '|', '| |'), '|', '')
             as bkpf_tabkey,
         ''                                                                                        as AccountType,
         ''                                                                                        as GLAccountNR
}
where
  bstat = 'L'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More