I_SAFTAccountingItem

@AbapCatalog.sqlViewName: 'ISAFTACCITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'SAF-T Accounting Item'
define view I_SAFTAccountingItem as select from I_OperationalAcctgDocItem  as a 

                                                    
association [0..1] to I_OperationalAcctgDocItem    as _ItemCustomer on _ItemCustomer.AccountingDocument = a.AccountingDocument 
                                                                   and _ItemCustomer.CompanyCode        = a.CompanyCode 
                                                                   and _ItemCustomer.FiscalYear         = a.FiscalYear
                                                                   and _ItemCustomer.FinancialAccountType = 'D'
                                                                   and _ItemCustomer.PostingKey           = '01' 
                                                                    
association [0..1] to I_StRpTaxItem                as _TaxItem      on _TaxItem.AccountingDocument = a.AccountingDocument 
                                                                   and _TaxItem.CompanyCode        = a.CompanyCode 
                                                                   and _TaxItem.FiscalYear         = a.FiscalYear
                                                                   and _TaxItem.TaxCode            = a.TaxCode 
                                                                   
//association [0..1] to P_SAFTACCT_TAXRATE as _TaxRateHasDecimals on  _TaxRateHasDecimals.AccountingDocument = a.AccountingDocument

//                                             and _TaxRateHasDecimals.CompanyCode      = a.CompanyCode

//                                             and _TaxRateHasDecimals.FiscalYear       = a.FiscalYear

//                                             and _TaxRateHasDecimals.TaxCode          = a.TaxCode                                                                                                                                                       

   {


   key  a.AccountingDocument                                      as AccountingDocument,
   key  a.FiscalYear                                              as FiscalYear,
   key  a.CompanyCode                                             as CompanyCode,
   key  a.AccountingDocumentItem                                  as AccountingDocumentItem ,
   
   a.ChartOfAccounts,
   a.GLAccount,
   
   a.Material as Material,
                                                                                                                          
  case 
    when a.Quantity <> 0
     then a.Quantity
    else 1                                          
   end                                                           as Quantity,//MENGE,

                                                                
  a.CompanyCodeCurrency, 
   
  a.BaseUnit                                                     as UnitOfMeasure,
                          
  a.BaseUnit                                                     as BaseUnit,
  
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
  case  
    when a.Quantity <> 0
     then  division(abs(a.AmountInCompanyCodeCurrency),a.Quantity, 2 )
     else  abs(a.AmountInCompanyCodeCurrency)       
  end                                                            as NetPriceAmount,
                                                                
                                                                
                                                                
   a.DocumentDate                                                as DocumentDate , 
   a.PostingDate                                                 as PostingDate,  


  
   a.DocumentItemText,
   
   @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
   case 
      when a.DebitCreditCode = 'S'   // Credit/debit need to be switched as is to reflect the customer accounting indicator

        then  abs(a.AmountInCompanyCodeCurrency)
      else  0
   end                                                          as DebitAmountInCoCodeCrcy,
   
   @Semantics.amount.currencyCode: 'CompanyCodeCurrency' 
   case 
      when a.DebitCreditCode = 'H'
        then  abs(a.AmountInCompanyCodeCurrency)
      else 0
   end                                                          as CreditAmountInCoCodeCrcy,
   a.AmountInCompanyCodeCurrency,  
   a.TaxCode                                                    as TaxCode, 
//   _TaxRateHasDecimals.ConditionCalculationType, //CE2011

   
   a.InvoiceReference,

   a.InvoiceReferenceFiscalYear,
   

   a.AccountingDocumentType,
   
   a.PaymentMethod,
   a.SpecialGLCode,
   
   a.FinancialAccountType,
   
   a.TaxAmountInCoCodeCrcy,
   
_GLAccountInChartOfAccounts,   
_AccountingDocumentType,   
_CompanyCodeCurrency,   
_CompanyCode,   
_ItemCustomer,
_TaxItem,   
_BaseUnit,
_JournalEntry
                              
} where AccountingDocumentItemType <> 'T'
    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_COMPANYCODE",
"I_CURRENCY",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"I_STRPTAXITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/