FISCDS_TRK_DOC_04

CDS View

Journal Entry History 04

FISCDS_TRK_DOC_04 is a CDS View in S/4HANA. Journal Entry History 04. 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: 'FISCDSTRKDOC04'
@EndUserText.label: 'Journal Entry History 04'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view FISCDS_TRK_DOC_04
  as select from    bseg as bseg
    left outer join bkpf as bkpf on  bseg.bukrs = bkpf.bukrs
                                 and bseg.gjahr = bkpf.gjahr
                                 and bseg.belnr = bkpf.belnr
{
  key    bseg.bukrs                                                                                                                                     as CompanyCode,
  key    bseg.belnr                                                                                                                                     as AccountingDocument,
  key    bseg.gjahr                                                                                                                                     as FiscalYear,
  key    cast(bseg.buzei 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( bseg.mandt, concat(rpad(bseg.bukrs, 4, '|'), concat( bseg.belnr, bseg.gjahr))), '|', '| |'), '|', '')                  as objectid,
         replace(replace(concat( bseg.mandt, concat(rpad(bseg.bukrs, 4, '|'), concat( bseg.belnr, concat( bseg.gjahr , buzei)))), '|', '| |'), '|', '') as tabkey,
         bseg.koart                                                                                                                                     as AccountType,
         bseg.saknr                                                                                                                                     as GLAccountNR
}
where
  bstat <> 'C'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF",
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More