FISCDS_TRK_DOC_03
Change History for Ledger View
FISCDS_TRK_DOC_03 is a CDS View in S/4HANA. Change History for Ledger View. It contains 1 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FISVD_TRK_DOC_11 | view | inner | Journal Entry History Convert GS Fields |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | JournalEntryItem | JournalEntryItem | 1 |
@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":""
}
}*/