C_JrnlEntryCorrespnc

@AbapCatalog.sqlViewName: 'CJRNLENCOR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@Search.searchable: true
@EndUserText.label: 'Correspondence SAP09 - Ledger View - Journal Entry'
define view C_JrnlEntryCorrespnc

  as select from I_JournalEntry

  association [1..*] to C_JrnlEntryItemCorrespnc     as _Item                       on  $projection.AccountingDocument = _Item.AccountingDocument
                                                                                    and $projection.CompanyCode        = _Item.CompanyCode
                                                                                    and $projection.FiscalYear         = _Item.FiscalYear

  association [0..*] to I_AccountingDocumentTypeText as _AccountingDocumentTypeText on  $projection.AccountingDocumentType = _AccountingDocumentTypeText.AccountingDocumentType

  association [0..*] to I_ReferenceDocumentTypeText  as _ReferenceDocumentTypeText  on  $projection.ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType


//  association [1..1] to I_CurrencyTypesCorrespnc     as _CurrencyTypesCorrespnc     on  $projection.CompanyCode       = _CurrencyTypesCorrespnc.CompanyCode

//                                                                                    and $projection.SourceLedger      = _CurrencyTypesCorrespnc.Ledger



  association [1..1] to I_CurrencyTypesCorrespnc as _CurrencyTypesCorrespnc     on  $projection.CompanyCode       = _CurrencyTypesCorrespnc.CompanyCode
                                                                                and $projection.SourceLedger      = _CurrencyTypesCorrespnc.Ledger
                                                                                
  association [0..*] to C_CorrespondenceHeaderNote   as _CorrespondenceHeaderNote   on  $projection.CompanyCode = _CorrespondenceHeaderNote.CompanyCode and
                                                                                        $projection.FiscalYear = _CorrespondenceHeaderNote.FiscalYear and
                                                                                        $projection.AccountingDocument = _CorrespondenceHeaderNote.AccountingDocument
{
      //I_JournalEntry

      @Search.defaultSearchElement: true
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
      AccountingDocumentType,
      _AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName,
      DocumentDate,
      PostingDate,
      FiscalPeriod,
      AccountingDocumentCreationDate,
      CreationTime,
      LastManualChangeDate,
      LastAutomaticChangeDate,
      LastChangeDate,
      ExchangeRateDate,
      AccountingDocCreatedByUser,
      TransactionCode,
      IntercompanyTransaction,
      DocumentReferenceID,
      RecurringAccountingDocument,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      AccountingDocumentHeaderText,
      TransactionCurrency,
      ExchangeRate,
      AccountingDocumentCategory,
      BusinessTransactionType,
      BatchInputSession,
      ReferenceDocumentType,
      _ReferenceDocumentTypeText[1:Language = $session.system_language].ReferenceDocumentTypeName,
      OriginalReferenceDocument,
      FinancialManagementArea,
      CompanyCodeCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,
      ReversalIsPlanned,
      PlannedReversalDate,
      TaxIsCalculatedAutomatically,
      TaxBaseAmountIsNetAmount,
      SourceCompanyCode,
      LogicalSystem,
      ReferenceDocumentLogicalSystem,
      TaxExchangeRate,
      ReversalReason,
      ParkingDate,
      ParkingTime,
      Branch,
      NmbrOfPages,
      IsDiscountDocument,
      Reference1InDocumentHeader,
      Reference2InDocumentHeader,
      InvoiceReceiptDate,
      Ledger,
      LedgerGroup,
      cast(AlternativeReferenceDocument as fis_xblnr_alt_alpha) as AlternativeReferenceDocument,
      TaxReportingDate,
      AccountingDocumentClass,
      ExchangeRateType,
      SenderLogicalSystem,
      SenderCompanyCode,
      SenderAccountingDocument,
      SenderFiscalYear,
      ReversalReferenceDocumentCntxt,
      ReversalReferenceDocument,
      LatePaymentReason,
      SalesDocumentCondition,
      IsReversal,
      IsReversed,

      Ledger as SourceLedger,
      
      _CompanyCode.ControllingArea,
      _CompanyCode._ControllingAreaText.ControllingAreaName,

      //Associations

      _Item,
      _CurrencyTypesCorrespnc,
      
      @ObjectModel.filter.enabled: false
      _CorrespondenceHeaderNote
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_JOURNALENTRY",
"I_REFERENCEDOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"C_CORRESPONDENCEHEADERNOTE",
"C_JRNLENTRYITEMCORRESPNC",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_CURRENCYTYPESCORRESPNC",
"I_REFERENCEDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/