P_KZ_VATRetInDoc

@AbapCatalog.sqlViewName: 'PKZVATRETINDOC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter:true
define view P_KZ_VATRetInDoc
  as select distinct from    P_KZ_VATReturnSection3    as LogItems

    left outer join P_KZ_PurMaterialDetails   as PurchasingDocument on  PurchasingDocument.PurchasingDocument         = LogItems.OriginalReferenceDocNum
                                                                    and PurchasingDocument.InvoiceReferenceFiscalYear = LogItems.OriginalReferenceDocYear
                                                                    and ( ReferenceDocumentType                         = 'RMRP'
                                                                       or ReferenceDocumentType                         = 'CF3PM' )
                                                                    and ( PurchasingDocument.TaxCode = LogItems.TaxCode or PurchasingDocument.TaxCode = '')


    left outer join I_OperationalAcctgDocItem as DocumentItem       on  DocumentItem.CompanyCode        =  LogItems.CompanyCode
                                                                    and DocumentItem.AccountingDocument =  LogItems.AccountingDocument
                                                                    and DocumentItem.FiscalYear         =  LogItems.FiscalYear
                                                                    //and DocumentItem.Supplier           <> ''

                                                                    and DocumentItem.Material = PurchasingDocument.Material
                                                                    and ( DocumentItem.TaxCode = LogItems.TaxCode or DocumentItem.TaxCode = '')



{
  //P_KZ_VATReturnSection3

  LogItems.CompanyCode,
  LogItems.AccountingDocument,
  LogItems.FiscalYear,
  LogItems.TaxCode,
  LogItems.TaxRate,
  LogItems.AmountSign,
  NegativeSign,
  DocumentItem.AmountInCompanyCodeCurrency,

//  case when DocumentItem.AmountInCompanyCodeCurrency is null

//     then LogItems.TaxBaseAmountInCoCodeCrcy

//     else DocumentItem.AmountInCompanyCodeCurrency

//   end  as TaxBaseAmountInCoCodeCrcy,


//   case when  DocumentItem.AmountInCompanyCodeCurrency is null

//     then LogItems.TaxAmountInCoCodeCrcy

//     else

//

//         cast ( DIVISION( DocumentItem.AmountInCompanyCodeCurrency, LogItems.TaxBaseAmountInCoCodeCrcy, 2) as abap.dec( 3, 2 ) )

//                 * LogItems.TaxAmountInCoCodeCrcy

//

//

//   end  as TaxAmountInCoCodeCrcy,


  LogItems.TaxBaseAmountInCoCodeCrcy,
  LogItems.TaxAmountInCoCodeCrcy,


    abs( LogItems.TaxBaseAmountInCoCodeCrcy ) as TaxBaseAmountInCoCodeCrcyABS,
    abs( DocumentItem.AmountInCompanyCodeCurrency ) as AmountInCompanyCodeCurrencyABS,





  LogItems.TaxBaseAmountInCoCodeCrcy as TaxBaseAmountInCoCodeCrcyTot,

  LogItems.TaxAmountInCoCodeCrcy as TaxAmountInCoCodeCrcyTot,


  LogItems.TransactionTypeDetermination,
  LogItems.PostingDate,
  TaxReportingDate,

  case JrnlEntryCntrySpecificDate1
    when '' then LogItems.DocumentDate
    else JrnlEntryCntrySpecificDate1
    end as DocumentDate,

  LogItems.AccountingDocumentType,
  IsReversal,
  IsReversed,
  LogItems.OriginalReferenceDocument,
  LogItems.ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  LogItems.SenderLogicalSystem,
  LogItems.AccountingDocumentHeaderText,
  LogItems.AccountingDocCreatedByUser,
  LogItems.Reference1InDocumentHeader,
  LogItems.Reference2InDocumentHeader,
  LogItems.DocumentItemText,
  LogItems.CompanyCodeCurrency,
  Currency,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  LogItems.AccountingDocumentItem,
  KZ_VATReturnSectionType,
  DocumentItem.Material,
  DocumentItem.PurchasingDocument,
  DocumentItem.PurchasingDocumentItem,


  case JrnlEntryCntrySpecificRef1
    when ''
        then case DocumentReferenceID when ''
            then LogItems.AccountingDocument
        else DocumentReferenceID
        end
   else JrnlEntryCntrySpecificRef1
   end as InvoiceNumber,

  //  PurchasingDocument.QuantityUnit,

  //  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'

  //  PurchasingDocument.Quantity,



  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then PurchasingDocument.QuantityUnit
  else cast( '' as meins)
  end  as QuantityUnit,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'

  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then PurchasingDocument.Quantity
  else cast ( 0 as fkimg )
  end  as Quantity,

  case PurchasingDocument.KZ_MaterialSubGroup
  when 'MIN'
  then  PurchasingDocument.MaterialName
  else ''
  end  as MaterialName,

  case PurchasingDocument.Activity
    when '' then '1'
    else PurchasingDocument.Activity
  end  as Activity,

  PurchasingDocument.KZ_MaterialSubGroup,
  PurchasingDocument.QuantityUnit as AnalyticQuantityUnit,
  @Semantics.quantity.unitOfMeasure: 'AnalyticQuantityUnit'
  PurchasingDocument.Quantity as AnalyticQuantity,
  PurchasingDocument.MaterialName as AnalyticMaterialName
}

where
  KZ_VATReturnSectionType = '08'