FISCDS_TRK_DOC_02

CDS View

Journal Entry History

FISCDS_TRK_DOC_02 is a CDS View in S/4HANA. Journal Entry History. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAC_DART_Z3_JournalEnty_CHGDOC view from Journal Entry Change Document 
@AbapCatalog.sqlViewName: 'FISV_TRK_DOC_02'
@EndUserText.label: 'Journal Entry History'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK

define view fiscds_trk_doc_02
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from FISVD_TRK_DOC_11
  association [0..1] to fiscds_trk_fld_text as field_text on  $projection.TableName = field_text.tabname
                                                          and $projection.rollname     = field_text.fieldname
  association [0..1] to dd04t               as dele_text  on  $projection.rollname = dele_text.rollname
{

  key CompanyCode,
  key Ledger,
  key AccountingDocument,
  key changenr,
  key TableName,
  key tabkey,
  key fname,
  key JournalEntryItem,
      rollname,
      case when
        field_text[1:language = :P_Language].ddtext <> '' then field_text[1:language = :P_Language].ddtext
      else
        dele_text[1:ddlanguage = :P_Language].ddtext
       end as FieldName,
      FiscalYear,
      PostingDate,
      DocumentDate,
      ChangedBy,
      ChangedAt,
      OldValue,
      NewValue,
      ChangedOn,
      CreationDate,
      CreationTime,
      text_case,
      AccountType,
      GLAccountNR,
      chngind

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FISCDS_TRK_FLD_TEXT",
"FISVD_TRK_DOC_11",
"DD04T"
],
"ASSOCIATED":
[
"FISCDS_TRK_FLD_TEXT",
"DD04T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More