FISCDS_TRK_DOC_03

DDL: FISVD_TRK_DOC_03 SQL: FISCDSTRKDOC03 Type: view

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 6 data sources and exposes 37 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocument, FiscalYear.

6 data source(s) 37 fields

Data Sources (6)

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

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 bkpf budat
DocumentDate bkpf bldat
timestamp cputm
CreationTime cputm
CreationDate 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,
         // n3337447 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 ='L'

  union
  select from acdoca as  acdoca
    left outer join bkpf     as bkpf on  acdoca.rbukrs = bkpf.bukrs
                                     and acdoca.gjahr = bkpf.gjahr
                                     and acdoca.belnr = bkpf.belnr
{
  key    acdoca.rbukrs                                                                                                              as CompanyCode,
  key    acdoca.belnr                                                                                                               as AccountingDocument,
  key    acdoca.gjahr                                                                                                               as FiscalYear,
         acdoca.docln                                                                                                          as JournalEntryItem,
         acdoca.rldnr                                                                                                                  as Ledger,
         bkpf.budat                                                                                                                  as PostingDate,
         bkpf.bldat                                                                                                                       as DocumentDate,
         cputm                                                                                                                       as timestamp,
         cputm                                                                                                                       as CreationTime,
         cpudt                                                                                                                       as CreationDate,
         // n3337447 support for Company Codes with less than four characters (preserve trailing spaces)

         replace(replace(concat( acdoca.rclnt, concat(rpad(acdoca.rbukrs, 4, '|'), concat( acdoca.belnr, acdoca.gjahr))), '|', '| |'), '|', '')
             as objectid,
         replace(replace(concat( acdoca.rclnt, concat( acdoca.rldnr, concat(rpad(acdoca.rbukrs, 4, '|'), concat( acdoca.gjahr,
                 concat( acdoca.belnr , acdoca.docln ))))), '|', '| |'), '|', '')
             as bsegadd_tabkey,
         acdoca.koart                                                                                                               as AccountType,
         acdoca.racct                                                                                                               as GLAccountNR

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"BKPF",
"BSEG_ADD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More