FISCDS_TRK_DOC_03

DDL: FISVD_TRK_DOC_03 SQL: FISCDSTRKDOC03 Type: view Package: FINS_FIS_GL

Change History for Ledger View

FISCDS_TRK_DOC_03 is a CDS View that provides data about "Change History for Ledger View" in SAP S/4HANA. It reads from 5 data sources (acdoca, bkpf, bkpf, bseg_add, bseg_add) and exposes 37 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocument, FiscalYear. It has 1 association to related views. Part of development package FINS_FIS_GL.

5 data source(s) 37 fields

Data Sources (5)

SourceAliasJoin Type
acdoca acdoca union
bkpf bkpf left_outer
bkpf bkpf left_outer
bseg_add bsegadd from
bseg_add bsegadd union

Associations (1)

CardinalityTargetAliasCondition
[1..1] bkpf _bkpf _bkpf.bukrs = acdoca.rbukrs and _bkpf.gjahr = acdoca.gjahr and _bkpf.belnr = acdoca.belnr

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISCDSTRKDOC03 view
EndUserText.label Change History for Ledger View view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bseg_add bukrs
KEY AccountingDocument bseg_add belnr
KEY FiscalYear bseg_add gjahr
JournalEntryItem
Ledger bkpf ldgrp
PostingDate bkpf budat
DocumentDate bldat
timestamp cputm
CreationTime cputm
CreationDate cpudt
objectid
AccountType bseg_add koart
bukrsasCompanyCode
KEY AccountingDocument bseg_add belnr
KEY FiscalYear bseg_add gjahr
JournalEntryItem
Ledger bkpf ldgrp
PostingDate bkpf budat
DocumentDate bldat
timestamp cputm
CreationTime cputm
CreationDate cpudt
objectid
AccountType bseg_add koart
rbukrsasCompanyCode
KEY AccountingDocument acdoca belnr
KEY FiscalYear acdoca gjahr
JournalEntryItem acdoca docln
Ledger acdoca rldnr
PostingDate budat
DocumentDate bldat
timestamp _bkpf cputm
CreationTime _bkpf cputm
CreationDate _bkpf cpudt
objectid
AccountType acdoca koart
GLAccountNR acdoca racct 
@AbapCatalog.sqlViewName: 'FISCDSTRKDOC03'
@EndUserText.label: 'Change History for Ledger View'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view FISCDS_TRK_DOC_03
  as select from    bseg_add as bsegadd
    left outer join bkpf     as bkpf on  bsegadd.bukrs = bkpf.bukrs
                                     and bsegadd.gjahr = bkpf.gjahr
                                     and bsegadd.belnr = bkpf.belnr
{
  key    bsegadd.bukrs                                                                                                               as CompanyCode,
  key    bsegadd.belnr                                                                                                               as AccountingDocument,
  key    bsegadd.gjahr                                                                                                               as FiscalYear,
         cast(bsegadd.buzei as  docln6)                                                                                              as JournalEntryItem,
         bkpf.ldgrp                                                                                                                  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( bsegadd.mandt, concat(rpad(bsegadd.bukrs, 4, '|'), concat( bsegadd.belnr, bsegadd.gjahr))), '|', '| |'), '|', '')
             as objectid,
         replace(replace(concat( bsegadd.mandt, concat( bkpf.ldgrp, concat(rpad(bsegadd.bukrs, 4, '|'), concat( bsegadd.gjahr,
                 concat( bsegadd.belnr , buzei))))), '|', '| |'), '|', '')
             as bsegadd_tabkey,
         bsegadd.koart                                                                                                               as AccountType,
         bsegadd.hkont                                                                                                               as GLAccountNR
}
where
  bkpf.bstat <> 'C'
 and bkpf.bstat <> 'L'

 union
select from bseg_add as bsegadd
  left outer join bkpf     as bkpf on  bsegadd.bukrs = bkpf.bukrs
                                     and bsegadd.gjahr = bkpf.gjahr
                                     and bsegadd.belnr = bkpf.belnr
{
  key    bsegadd.bukrs                                                                                                               as CompanyCode,
  key    bsegadd.belnr                                                                                                               as AccountingDocument,
  key    bsegadd.gjahr                                                                                                               as FiscalYear,
         cast(bsegadd.buzei as  docln6)                                                                                              as JournalEntryItem,
         bkpf.ldgrp                                                                                                                  as Ledger,
         bkpf.budat                                                                                                                  as PostingDate,
         bldat                                                                                                                       as DocumentDate,
         cputm                                                                                                                       as timestamp,
         cputm                                                                                                                       as CreationTime,
         cpudt                                                                                                                       as CreationDate,
         concat( bsegadd.mandt, concat( bsegadd.bukrs, concat( bsegadd.belnr, bsegadd.gjahr)))                                       as objectid,
         concat( bsegadd.mandt,  concat( bsegadd.bukrs, concat( bsegadd.belnr, concat( bsegadd.gjahr , buzei))))                     as bsegadd_tabkey,
         bsegadd.koart                                                                                                               as AccountType,
         bsegadd.hkont                                                                                                               as GLAccountNR
}
where
   bkpf.bstat ='L'

 union
  select from acdoca as  acdoca 
  association [1..1] to bkpf as _bkpf on  _bkpf.bukrs = acdoca.rbukrs 
                                      and _bkpf.gjahr = acdoca.gjahr 
                                      and _bkpf.belnr = acdoca.belnr 
{
  key    acdoca.rbukrs                                                                                                              as CompanyCode,
  key    acdoca.belnr                                                                                                               as AccountingDocument,
  key    acdoca.gjahr                                                                                                               as FiscalYear,
         acdoca.docln                                                                                                          as JournalEntryItem,
         acdoca.rldnr                                                                                                                  as Ledger,
         budat                                                                                                                  as PostingDate,
         bldat                                                                                                                       as DocumentDate,
         _bkpf.cputm                                                                                                                       as timestamp,
         _bkpf.cputm                                                                                                                       as CreationTime,
         _bkpf.cpudt                                                                                                                       as CreationDate,
         concat( acdoca.rclnt, concat( acdoca.rbukrs, concat( acdoca.belnr, acdoca.gjahr)))                                       as objectid,
         concat( acdoca.rclnt, concat(acdoca.rldnr, concat( acdoca.rbukrs, concat( acdoca.gjahr, concat( acdoca.belnr , acdoca.docln )))))             as bsegadd_tabkey,
         acdoca.koart                                                                                                               as AccountType,
         acdoca.racct                                                                                                               as GLAccountNR

}

Learn More