I_ClrgInfoRelationForAcctgDoc

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.representativeKey: 'ClearingAccountingDocument'
@ObjectModel.compositionRoot: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ICLEARINGINFO',
  compiler.compareFilter: true
}
@EndUserText.label: 'Clearing Information for Accounting'
@Metadata.allowExtensions: true
@AbapCatalog.preserveKey: true
define view I_ClrgInfoRelationForAcctgDoc as select from bse_clr

  association [1..1] to I_CompanyCode as _ClearingInfoCompanyCode on $projection.ClearingInfoCompanyCode = _ClearingInfoCompanyCode.CompanyCode
  association [1..1] to I_CompanyCode as _CompanyCode    on $projection.CompanyCode    = _CompanyCode.CompanyCode
  
  association [0..1] to I_AccountingDocument as _ClearingDocument   on $projection.ClearingAccountingDocument = _ClearingDocument.AccountingDocument
                                                                   and $projection.ClearingInfoCompanyCode    = _ClearingDocument.CompanyCode
                                                                   and $projection.ClearingFiscalYear         = _ClearingDocument.FiscalYear
                                                                   
  association [0..1] to I_AccountingDocument as _AccountingDocument on $projection.AccountingDocument      = _AccountingDocument.AccountingDocument
                                                                   and $projection.ClearingInfoCompanyCode = _AccountingDocument.CompanyCode
                                                                   and $projection.ClearingFiscalYear      = _AccountingDocument.FiscalYear                             
   
  association [0..1] to I_FiscalYearForCompanyCode as _ClearingFiscalYear on $projection.ClearingFiscalYear      = _ClearingFiscalYear.FiscalYear
                                                                        and $projection.ClearingInfoCompanyCode = _ClearingFiscalYear.CompanyCode
  association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear    on $projection.FiscalYear              = _FiscalYear.FiscalYear
                                                                    and $projection.CompanyCode             = _FiscalYear.CompanyCode
  
  association [0..1] to I_Currency as _Currency       on $projection.companycodecurrency = _Currency.Currency
  
  association [0..1] to I_DebitCreditCode as _DebitCreditCode on $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
                                                                 
  
{
  key bukrs_clr as ClearingInfoCompanyCode, 
  key belnr_clr as ClearingAccountingDocument,
  key gjahr_clr as ClearingFiscalYear, 
  key index_clr as ClearingInformationIndex,
  agzei as ClearingItem,
  agbuz as DownPaymentItem,
//  agbuz as SetLineNumber,  

  waers as TransactionCurrency, 
  clrin as ClearingInformationType, 
  bukrs as CompanyCode, 
  belnr as AccountingDocument, 
  gjahr as FiscalYear, 
  buzei as AccountingDocumentItem,
  shkzg as DebitCreditCode, 
  _ClearingDocument.CompanyCodeCurrency,
  _ClearingDocument.AdditionalCurrency1,
  _ClearingDocument.AdditionalCurrency2,
  
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
  dmbtr as AmountInCompanyCodeCurrency,
  @Semantics.amount.currencyCode: 'AdditionalCurrency1' 
  dmbe2 as AmountInAdditionalCurrency1, 
  @Semantics.amount.currencyCode: 'AdditionalCurrency2' 
  dmbe3 as AmountInAdditionalCurrency2, 
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  wrbtr as AmountInTransactionCurrency, 
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  difhw as DifferenceAmtInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'AdditionalCurrency1'
  difh2 as DiffAmtInAdditionalCurrency1,
  @Semantics.amount.currencyCode: 'AdditionalCurrency2'
  difh3 as DiffAmtInAdditionalCurrency2,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  diffw as DifferenceAmtInTransCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sknto as CashDiscountAmtInCoCodeCrcy, 
  @Semantics.amount.currencyCode: 'AdditionalCurrency1'
  sknt2 as CashDiscountAmtInAddlCrcy1, 
  @Semantics.amount.currencyCode: 'AdditionalCurrency2'
  sknt3 as CashDiscountAmtInAddlCrcy2,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  wskto as CashDiscountAmount,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  bdiff as ValuationDiffAmtInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'AdditionalCurrency1'
  bdif2 as ValuationDiffAmtInAddlCrcy1, 
  @Semantics.amount.currencyCode: 'AdditionalCurrency2'
  bdif3 as ValuationDiffAmtInAddlCrcy2, 
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  rdiff as ExchRateDiffAmtInCoCodeCrcy, 
  @Semantics.amount.currencyCode: 'AdditionalCurrency1'
  rdif2 as ExchRateDiffAmtInAddlCrcy1,
  @Semantics.amount.currencyCode: 'AdditionalCurrency2'
  rdif3 as ExchRateDiffAmtInAddlCrcy2,
  koart as AccountType, 
  umskz as SpecialGLCode,
  
  _ClearingInfoCompanyCode,
  _CompanyCode,
  _ClearingDocument,
  _AccountingDocument,
  _ClearingFiscalYear,
  _FiscalYear,
  _Currency,
  _DebitCreditCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"BSE_CLR"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_COMPANYCODE",
"I_CURRENCY",
"I_DEBITCREDITCODE",
"I_FISCALYEARFORCOMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/