FAC_DART_Z3_VNDRCHGDOC

@AbapCatalog.sqlViewName: 'FAC_DZVNDRCHGDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Vendor change Document'
define view FAC_DART_Z3_VNDRCHGDOC
  with parameters
//    P_CompanyCode      : bukrs,

    P_Ledger           : fins_ledger,
    P_FiscalYear       : fins_gjahr,
    @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 FAC_DART_Z3_VNDRCHGDOC_BASE  as _vendorhis
    inner join   I_LedgerCompanyCodeCrcyRoles on  I_LedgerCompanyCodeCrcyRoles.CompanyCode = _vendorhis.CompanyCode
                                              and I_LedgerCompanyCodeCrcyRoles.Ledger      = $parameters.P_Ledger

  association [0..*] to I_ChangeLogDatabaseTableText as _ChangeLogDatabaseTableText on  _vendorhis.DatabaseTable = _ChangeLogDatabaseTableText.DatabaseTable
  association [0..*] to dd03m                        as _ChangeDocFieldNames        on  _vendorhis.DatabaseTable               = _ChangeDocFieldNames.tabname
                                                                                    and _vendorhis.ChangeDocDatabaseTableField = _ChangeDocFieldNames.fieldname
  association [0..*] to I_ChgDocItemChangeTypeText   as _ChgDocItemChangeTypeText   on  _vendorhis.ChangeDocItemChangeType = _ChgDocItemChangeTypeText.ChangeDocItemChangeType

  association [0..1] to I_FiscalPeriodForVariant     as _ToFiscalPeriodForVariant   on  _ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant
                                                                                    and _ToFiscalPeriodForVariant.FiscalYear        = $parameters.P_FiscalYear
                                                                                    and _ToFiscalPeriodForVariant.FiscalPeriod      = $parameters.P_ToFiscalPeriod
  association [0..1] to I_FiscalPeriodForVariant     as _FromFiscalPeriodForVariant on  _FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant
                                                                                    and _FromFiscalPeriodForVariant.FiscalYear        = $parameters.P_FiscalYear
                                                                                    and _FromFiscalPeriodForVariant.FiscalPeriod      = $parameters.P_FromFiscalPeriod
{
  key Vendor,
  key _vendorhis.CompanyCode,
      //Vendor ID

      //  @EndUserText.label: 'Vendor'

  key ChangeDocObject,
      //KRED

  key ChangeDocObjectClass,
      //Changenr

  key ChangeDocument,
  key DatabaseTable,
  key ChangeDocTableKey,
  key ChangeDocDatabaseTableField,
  key ChangeDocItemChangeType,
      _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText,

      //      I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant as FiscalYearVariant,


      _ChangeLogDatabaseTableText[1: Language = $parameters.P_Language].DatabaseTableText,
      _ChangeDocFieldNames[1: ddlanguage = $parameters.P_Language].scrtext_l,

      ChangeDocNewFieldValue,
      ChangeDocPreviousFieldValue,
      ChangeDocPreviousUnit,
      ChangeDocNewUnit,
      ChangeDocPreviousCurrency,
      ChangeDocNewCurrency,
      ChangeDocTextIsChanged,

      @EndUserText.label: 'Output Length'
      case when newLength >= oldLength
        then newLength
        else oldLength end                           as outputLength,

      CreatedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.systemTime.createdAt: true
      CreationTime,
      ChangeTransactionCode,
      ChangeDocChangeType,
      @Semantics.language: true
      ChangeDocLanguage,

      _header,

//      /*Add for auth check */

//      SupplierForAuth,

//      _Supplier,

//      AuthorizationGroup,

//      IsBusinessPurposeCompleted,


      I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant as FiscalYearVariant,
//      $parameters.P_CompanyCode                      as ReportCompanyCode,

      @EndUserText.label: 'System Client'
      cast ( $session.client as char3 )              as SystemClient
}
where
       _vendorhis.CreationDate >= _FromFiscalPeriodForVariant.FiscalPeriodStartDate
  and  _vendorhis.CreationDate <= _ToFiscalPeriodForVariant.FiscalPeriodEndDate
//  and(

//       _vendorhis.CompanyCode  = $parameters.P_CompanyCode

//    or _vendorhis.CompanyCode  =  ''

//  )

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAC_DART_Z3_VNDRCHGDOC_BASE",
"I_CHANGELOGDATABASETABLETEXT",
"I_CHGDOCITEMCHANGETYPETEXT",
"I_FISCALPERIODFORVARIANT",
"I_LEDGERCOMPANYCODECRCYROLES",
"DD03M"
],
"ASSOCIATED":
[
"I_CHANGEDOCUMENT",
"I_CHANGELOGDATABASETABLETEXT",
"I_CHGDOCITEMCHANGETYPETEXT",
"I_FISCALPERIODFORVARIANT",
"DD03M"
],
"BASE":
[
"FAC_DART_Z3_VNDRCHGDOC_BASE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/