FISCDS_TRK_DOC_07

CDS View

JE Change History only exist in BKPF

FISCDS_TRK_DOC_07 is a CDS View in S/4HANA. JE Change History only exist in BKPF. 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: 'FISCDSTRKDOC07'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'JE Change History only exist in BKPF'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view FISCDS_TRK_DOC_07
  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 = 'B'
  or bstat = 'U'
  or bstat = ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More