FISCDS_TRK_DOC_05

DDL: FISVD_TRK_DOC_05 SQL: FISCDSTRKDOC05 Type: view Package: FINS_FIS_GL

Change History from non-leading Ledger

FISCDS_TRK_DOC_05 is a CDS View that provides data about "Change History from non-leading Ledger" in SAP S/4HANA. It reads from 1 data source (bkpf) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package FINS_FIS_GL.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
bkpf bkpf from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISCDSTRKDOC05 view
EndUserText.label Change History from non-leading Ledger view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L 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: 'FISCDSTRKDOC05'
@EndUserText.label: 'Change History from non-leading Ledger'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@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'

Learn More