I_EXTENDEDWHLDGTAXCODE

CDS View

Extended Withholding Tax Code

I_EXTENDEDWHLDGTAXCODE is a CDS View in S/4HANA. Extended Withholding Tax Code. It contains 3 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 3 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_WhldgTaxCodeVHTemp view from CONSUMPTION Withholding Tax Code
I_CoCodeWithholdingTaxCode view from BASIC Withholding Tax Code in Company Code
I_WithholdingTaxCodeVH view from COMPOSITE Extended Withholding Tax Code
P_US_StRpFrgnVndrWhldgTax view from COMPOSITE US 1042S chapter 3 & 4 WHT exemption
P_US_StRpFrgnVndrWhldgTax view union_all COMPOSITE US 1042S chapter 3 & 4 WHT exemption

Fields (3)

KeyField CDS FieldsUsed in Views
KEY WithholdingTaxCode WithholdingTaxCode 1
KEY WithholdingTaxType WithholdingTaxType 1
WithholdingTaxPercent WithholdingTaxPercent 1 
@AbapCatalog.sqlViewName: 'IFIEWHTAXCODE'
@EndUserText.label: 'Extended Withholding Tax Code'
@VDM.viewType: #BASIC
@Analytics: { dataCategory: #CUBE }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@AbapCatalog.preserveKey:true
@Metadata.allowExtensions:true
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.supportedCapabilities: #CDS_MODELING_ASSOCIATION_TARGET
@Metadata.ignorePropagatedAnnotations:true

define view I_Extendedwhldgtaxcode
  as select from t059z

  association [1]    to I_Country                  as _Country  on  $projection.Country = _Country.Country

  association [1..*] to I_ExtendedWhldgTaxCodeText as _CodeText on  $projection.WithholdingTaxType = _CodeText.WithholdingTaxType
                                                                and $projection.WithholdingTaxCode = _CodeText.WithholdingTaxCode
                                                                and $projection.Country            = _CodeText.CountryCode

{

  key land1     as Country,
  key witht     as WithholdingTaxType,
  key wt_withcd as WithholdingTaxCode,
      qscod     as OfficialWhldgTaxCode,
      qproz     as WhldgTaxRelevantPercent,
      qsatz     as WithholdingTaxPercent,
      xqfor     as WhldgTaxCalcFormulaIsUsed,
      regio     as Region,
      fprcd     as ProvincialTaxCode,
      qekar     as WithholdingTaxIncomeType,
      wt_posin  as WithholdingTaxPostingRule,
      withcd2   as WhldgTaxReferenceText,

      _Country,
      _CodeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T059Z"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_EXTENDEDWHLDGTAXCODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More