P_US_WhldgTaxCodeThldFields

@AbapCatalog.sqlViewName: 'PUSWTTXTHLDFLD'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_US_WhldgTaxCodeThldFields as select from I_SAPClient {
  key cast( 'US' as land1)                   as Country,
  key cast('MISC' as qstyp )                 as ReportingType,
  key cast('' as witht )                     as WithholdingTaxType,
  key cast('08' as qsskz )                   as WithholdingTaxCode,
  key cast('US_MIN_DIVID' as fieldname)      as ThresholdFieldName
    
}
union 
select from I_SAPClient {
  key cast( 'US' as land1)                   as Country,
  key cast('MISC' as qstyp )                 as ReportingType,
  key cast('' as witht )                     as WithholdingTaxType,
  key cast('**' as qsskz )                   as WithholdingTaxCode,
  key cast('US_MIN_FED' as fieldname)        as ThresholdFieldName
    
}
union 
select from I_SAPClient {
key cast( 'US' as land1)                   as Country,
  key cast('MISC' as qstyp )                 as ReportingType,
  key cast('' as witht )                     as WithholdingTaxType,
  key cast('09' as qsskz )                   as WithholdingTaxCode,
  key cast('US_MIN_DIRECT' as fieldname)     as ThresholdFieldName
    
}
union
select from I_SAPClient {
  key cast( 'US' as land1)                   as Country,
  key cast('INT' as qstyp )                  as ReportingType,
  key cast('' as witht )                     as WithholdingTaxType,
  key cast('1J' as qsskz )                   as WithholdingTaxCode,
  key cast('US_MIN_INT_GEN' as fieldname)    as ThresholdFieldName
    
}
union  
select from I_SAPClient {
  key cast( 'US' as land1)                   as Country,
  key cast('MISC' as qstyp )                 as ReportingType,
  key cast('' as witht )                     as WithholdingTaxType,
  key cast('02' as qsskz )                   as WithholdingTaxCode,
  key cast('US_MIN_ROYAL' as fieldname)      as ThresholdFieldName
    
}