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 |