P_KZ_DSVATRetDoc

@AbapCatalog.sqlViewName: 'PKZDSVATRETDOC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 

define view P_KZ_DSVATRetDoc
  with parameters

    P_StatryRptgEntity         : srf_reporting_entity,
    P_StatryRptCategory        : srf_rep_cat_id,
    P_StatryRptRunID           : srf_report_run_id,
    P_VATReturnVersion         : j_3rvatdversion,
    P_ReportingPeriodStartDate : datum,
    P_ReportingPeriodEndDate   : datum
  as select from I_JournalEntry            as JournalEntry


//    join         I_OperationalAcctgDocItem as DocumentItem on  JournalEntry.CompanyCode        = DocumentItem.CompanyCode

//                                                           and JournalEntry.AccountingDocument = DocumentItem.AccountingDocument

//                                                           and JournalEntry.FiscalYear         = DocumentItem.FiscalYear


    join         I_TaxItem                 as TaxItem      on  JournalEntry.CompanyCode            = TaxItem.CompanyCode
                                                           and JournalEntry.AccountingDocument     = TaxItem.AccountingDocument
                                                           and JournalEntry.FiscalYear             = TaxItem.FiscalYear
//                                                           and DocumentItem.AccountingDocumentItem = TaxItem.TaxItem

                                                           


    inner join         I_KZ_VATReturnCustomizing as Customazing  on(
                                                              Customazing.TaxCode = TaxItem.TaxCode
                                                              and Customazing.AccountingDocumentType = JournalEntry.AccountingDocumentType
                                                              and Customazing.TransactionTypeDetermination = TaxItem.TransactionTypeDetermination
                                                              
                                                             )
                                                           or(
                                                             Customazing.TaxCode                    = TaxItem.TaxCode
                                                             and Customazing.AccountingDocumentType = JournalEntry.AccountingDocumentType
                                                             and Customazing.TransactionTypeDetermination = ''
                                                           )
                                                           or(
                                                             Customazing.TaxCode                    = TaxItem.TaxCode
                                                             and Customazing.AccountingDocumentType = ''
                                                             and Customazing.TransactionTypeDetermination = TaxItem.TransactionTypeDetermination
                                                           )
                                                           or(
                                                             Customazing.TaxCode                    = TaxItem.TaxCode
                                                             and Customazing.AccountingDocumentType = ''
                                                             and Customazing.TransactionTypeDetermination = ''
                                                           )
{

  key $parameters.P_StatryRptgEntity        as StatryRptgEntity,
  key $parameters.P_StatryRptCategory       as StatryRptCategory,
  key $parameters.P_StatryRptRunID          as StatryRptRunID,
  key JournalEntry.CompanyCode,
  key JournalEntry.FiscalYear,
  key JournalEntry.AccountingDocument,
  key TaxItem.TaxItem as AccountingDocumentItem,
  key Customazing.KZ_VATReturnSectionType   as SectionNum,
  key Customazing.KZ_VATLineItem               as LineItem,
  key Customazing.KZ_VATOperationCode             as OperationCode,
  key Customazing.KZ_VATReturnSectionColumn as ColumnNum


}
where

  // check DebitCreditCode type according to customizing

  (
        Customazing.DebitCreditCode         = ''
    or  JournalEntry.IsReversal             =  ''
    and TaxItem.DebitCreditCode             =  Customazing.DebitCreditCode
    or  JournalEntry.IsReversal             =  'X'
    and TaxItem.DebitCreditCode             <> Customazing.DebitCreditCode
  )
  and
  (
        Customazing.KZ_VATReturnSectionType =  ''
    or  Customazing.KZ_VATReturnSectionType =  '01'
    or  Customazing.KZ_VATReturnSectionType =  '02'
    or  Customazing.KZ_VATReturnSectionType =  '04'
    or  Customazing.KZ_VATReturnSectionType =  '06'
  )
  and   
  JournalEntry.TaxReportingDate       >= $parameters.P_ReportingPeriodStartDate
  and   JournalEntry.TaxReportingDate       <= $parameters.P_ReportingPeriodEndDate
  and Customazing.KZ_VATReturnVersion = $parameters.P_VATReturnVersion
  and Customazing.TotalNumberIsCondition = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_KZ_VATRETURNCUSTOMIZING",
"I_TAXITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/