FISCDS_TRK_DOC_07

DDL: FISVD_TRK_DOC_07 SQL: FISCDSTRKDOC07 Type: view

JE Change History only exist in BKPF

FISCDS_TRK_DOC_07 is a CDS View that provides data about "JE Change History only exist in BKPF" in SAP S/4HANA. It reads from 1 data source (bkpf) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
bkpf bkpf from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FISCDSTRKDOC07 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label JE Change History only exist in BKPF view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

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

Learn More