FISCDS_TRK_DOC_04

DDL: FISVD_TRK_DOC_04 SQL: FISCDSTRKDOC04 Type: view

Journal Entry History 04

FISCDS_TRK_DOC_04 is a CDS View that provides data about "Journal Entry History 04" in SAP S/4HANA. It reads from 2 data sources (bkpf, bseg) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear, JournalEntryItem.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
bkpf bkpf left_outer
bseg bseg from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISCDSTRKDOC04 view
EndUserText.label Journal Entry History 04 view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bseg bukrs
KEY AccountingDocument bseg belnr
KEY FiscalYear bseg gjahr
KEY JournalEntryItem
Ledger bkpf rldnr
PostingDate bkpf budat
DocumentDate bldat
timestamp cputm
CreationTime cputm
CreationDate cpudt
objectid
tabkey
AccountType bseg koart
GLAccountNR bseg saknr 
@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'

Learn More