P_KZ_VAT_HELPER

@AbapCatalog.sqlViewName: 'PKZVATHELPER'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED

define view P_KZ_VAT_HELPER 

with parameters
  P_DeclarationType : abap.char(1),
  P_DeductionMethod : abap.char(1),
  P_TaxpayerCategory: abap.char(1),
  P_InvoicingMethod : abap.char(1),
  P_ReceiptMethod   : abap.char(1),
  P_ACRPhase        : abap.char(5),
  P_NotifNum        : abap.char(20),
  
  @Environment.systemField : #SYSTEM_DATE
  P_SystemDate : syst_datum,
  P_RegressionFlag  : abap.char(1)
    
as select from    I_SAPClient
  
{

  case ($parameters.P_DeclarationType) when '1' then 'true' end as dt_main,
  case ($parameters.P_DeclarationType) when '5' then 'true' end as dt_final,
  
  case ($parameters.P_DeclarationType) when '1' then ''
                                       when '5' then ''
                                       else 
                                        case ($parameters.P_ACRPhase) when 'STAND' then 'true' end
                                       end as dt_regular,

  case ($parameters.P_DeclarationType) when '1' then ''
                                       when '5' then ''
                                       else 
                                        case ($parameters.P_ACRPhase) when 'CORR' then 
                                           case ($parameters.P_NotifNum) when '' then '' else 'true' end  end
                                       end as dt_notice,  

  case ($parameters.P_DeclarationType) when '1' then ''
                                       when '5' then ''
                                       else 
                                        case ($parameters.P_ACRPhase) when 'CORR' then 
                                            case ($parameters.P_NotifNum) when '' then 'true' end end
                                       end as dt_additional,                                     
  
  case ($parameters.P_DeductionMethod) when '1' then 'true' end as ded_meth1,
  case ($parameters.P_DeductionMethod) when '2' then 'true' end as ded_meth2,
  case ($parameters.P_DeductionMethod) when '3' then 'true' end as ded_meth3,
  
  case ($parameters.P_TaxpayerCategory) when '1' then 'true' end as upr_dov,
  case ($parameters.P_TaxpayerCategory) when '2' then 'true' end as uchr_dov,
  case ($parameters.P_TaxpayerCategory) when '3' then 'true' end as use_article,
  case ($parameters.P_TaxpayerCategory) when '4' then 'true' end as use_another,
  case ($parameters.P_TaxpayerCategory) when '5' then 'true' end as mfca,
  
  
  case ($parameters.P_InvoicingMethod) when '2' then 'true' when '3' then 'true' end as schet_extract_electronic,
  case ($parameters.P_InvoicingMethod) when '1' then 'true' when '3' then 'true' end as schet_extract_paper,

  case ($parameters.P_ReceiptMethod) when '2' then 'true' when '3' then 'true' end as schet_reception_electronic,
  case ($parameters.P_ReceiptMethod) when '1' then 'true' when '3' then 'true' end as schet_reception_paper,
    
  case ($parameters.P_RegressionFlag) when ' ' then  
  CONCAT( SUBSTRING( $parameters.P_SystemDate, 7, 2 ) , 
    CONCAT('.', 
      CONCAT(SUBSTRING( $parameters.P_SystemDate, 5, 2 ), 
        CONCAT('.', SUBSTRING( $parameters.P_SystemDate, 1, 4 ) ) ) ) ) 
  else '25.07.2020'
  end as SystemDate,
  case ($parameters.P_RegressionFlag) when ' ' then  
        substring($parameters.P_SystemDate, 1, 8) 
  else '20200725'
  end as UnformattedSystemDate
}