QSTRE - FI/HR Withholding Tax Report for Spain
FI/HR Withholding Tax Report for Spain information is stored in SAP table QSTRE.
It is part of development package FREP in software component FI-GL-IS. This development package consists of objects that can be grouped under "RF reporting".
It is part of development package FREP in software component FI-GL-IS. This development package consists of objects that can be grouped under "RF reporting".
Fields for table QSTRE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | |
| BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
| BUZEI | Number of Line Item Within Accounting Document | X | BUZEI | NUMC | 6 | |
| GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| DATHER | Data Origin for Table QSTRE | QSDATHER | CHAR | 2 | ||
| FPRCD | Provincial Tax Code | FPRCD | CHAR | 6 | ||
| QSREP | Recipient Code for Recipient Type | QSREP | CHAR | 6 | ||
| QEKAR | Income Type | QEKAR | CHAR | 8 | ||
| KZDPC | Ind.fr Donations/Pyts on Act (Donativos/Pagos) fr Wth.Tx Rep | QSKZDPC | CHAR | 2 | ||
| STECD | Tax Number 1 | STCD1 | CHAR | 32 | ||
| STCEG | VAT Registration Number | STCEG | CHAR | 40 | ||
| NAME1 | Character field of length 40 | CHAR40 | CHAR | 80 | ||
| NAME2 | Name 2 | NAME2_GP | CHAR | 70 | ||
| ORT01 | City | ORT01_GP | CHAR | 70 | ||
| PSTLZ | Postal Code | PSTLZ | CHAR | 20 | ||
| STRAS | Street and House Number | STRAS_GP | CHAR | 70 | ||
| GBDAT | Date of Birth of the Person Subject to Withholding Tax | GBDAT_Q | DATS | 16 | ||
| GBORT | Place of birth of the person subject to withholding tax | GBORT_Q | CHAR | 50 | ||
| GBPRO | Native Region of the Party Subject to Withholding Tax | GBPRO_Q | CHAR | 6 | ||
| SEXKZ | Key for the Sex of the Person Subject to Withholding Tax | SEXKZ | CHAR | 2 | ||
| STKZN | Natural Person | STKZN | CHAR | 2 | ||
| REGIO | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| QLAND | Withholding Tax Country/Region Key | QLAND | CHAR | 6 | ||
| QPROZ | Percentage Subject to Withholding Tax | QPROZ | DEC | 3 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 4 | ||
| QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 20 | ||
| WRBTR | Amount in document currency | WRBTR | CURR | 12 | ||
| DMBTR | Amount in local currency | DMBTR | CURR | 12 | ||
| QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 12 | ||
| QSSHH | Withholding Tax Base Amount (Local Currency) | QSSHH | CURR | 12 | ||
| QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | CURR | 12 | ||
| QBSHH | Withholding Tax Amount (in Local Currency) | QBSHH | CURR | 12 | ||
| QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 12 | ||
| QSFBH | Amount Exempt from Withholding Tax (in Local Currency) | QSFBH | CURR | 12 | ||
| KURSF | Exchange rate | KURSF | DEC | 5 | ||
| WAERQ | Currency Key for Withholding Tax Report | QSWAERS | CHAR | 10 | ||
| NOHIJ | Tax - Number of Children | NOHIJ | DEC | 2 | ||
| LAND1 | Country/Region Key | LAND1 | CHAR | 6 |