FAC_DART_Z3_JournalEnty_CHGDOC

@AbapCatalog.sqlViewName: 'FAC_DZJECHGD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Journal Entry Change Document'
define view FAC_DART_Z3_JournalEnty_CHGDOC
  with parameters
    //    P_CompanyCode      : bukrs,

    P_Ledger           : fins_ledger,
    P_FiscalYear       : fins_gjahr,
    P_FromCreationDate   : fis_budat_from, 
    P_ToCreationDate     : fis_budat_to,
    //@EndUserText.label: 'From Fiscal Period'

    //P_FromFiscalPeriod : fins_fagl_fiscper_from,

    //@EndUserText.label: 'To Fiscal Period'

    //P_ToFiscalPeriod   : fins_fagl_fiscper_to,

    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language         : sylangu
  as select from    fiscds_trk_doc_02( P_Language : $parameters.P_Language ) as chlog
  association [0..*] to I_ChgDocItemChangeTypeText   as _ChgDocItemChangeTypeText   on  chlog.chngind = _ChgDocItemChangeTypeText.ChangeDocItemChangeType
  association [0..*] to I_ChangeLogDatabaseTableText as _ChangeLogDatabaseTableText on  chlog.TableName = _ChangeLogDatabaseTableText.DatabaseTable  
  association [0..1] to I_CompanyCode                as _CompanyCode                on  chlog.CompanyCode = _CompanyCode.CompanyCode
{
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key JournalEntryItem,
  key Ledger,
  key changenr                                       as ChangeDocument,
  key TableName                                      as DatabaseTable,
  key tabkey                                         as ChangeDocTableKey,
  key fname                                          as FieldName,
      GLAccountNR,
      _ChangeLogDatabaseTableText[1: Language = $parameters.P_Language].DatabaseTableText,
      FieldName                                      as FieldText,
      _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText,
      //I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant as FiscalYearVariant,

      ChangedBy                                as ChangedBy,
      ChangedAt                                as ChangedAt,
      OldValue                                 as OldValue,
      NewValue                                 as NewValue,
      ChangedOn                                as ChangedOn,
      text_case,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt: true
      CreationTime,
      //      $parameters.P_CompanyCode                      as ReportCompanyCode,

      @EndUserText.label: 'System Client'
      cast ( $session.client as char3 )              as SystemClient,
      _CompanyCode.ChartOfAccounts

}
where
       ChangedOn >= $parameters.P_FromCreationDate
  and  ChangedOn <= $parameters.P_ToCreationDate
  //  and(

  //       //       chlog.CompanyCode  = $parameters.P_CompanyCode

  //       chlog.CompanyCode =  ''

  //  )

  and(
       Ledger =  ''
    or Ledger = $parameters.P_Ledger
  )