1. Home
  2. Resources
  3. SAP Tables
  4. QSTRE - FI/HR Withholding Tax Report for Spain

SAP Table QSTRE

FI/HR Withholding Tax Report for Spain

QSTRE (FI/HR Withholding Tax Report for Spain) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QSTRE to other SAP tables.

QSTRE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
GJAHR Fiscal Year GJAHR NUMC 4 0
DATHER Data Origin for Table QSTRE QSDATHER CHAR 1 0
F FI
H HR
X External
FPRCD Provincial tax code FPRCD CHAR 3 0
QSREP Recipient Code for Recipient Type QSREP CHAR 3 0
QEKAR Income Type QEKAR CHAR 4 0
KZDPC Ind.fr Donations/Pyts on Act (Donativos/Pagos) fr Wth.Tx Rep QSKZDPC CHAR 1 0
STECD Tax Number 1 STCD1 CHAR 16 0
STCEG VAT Registration Number STCEG CHAR 20 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
STRAS House number and street STRAS_GP CHAR 35 0
GBDAT Date of birth of the person subject to withholding tax GBDAT_Q DATS 8 0
GBORT Place of birth of the person subject to withholding tax GBORT_Q CHAR 25 0
GBPRO Native Region of the Party Subject to Withholding Tax GBPRO_Q CHAR 3 0
SEXKZ Key for the Sex of the Person Subject to Withholding Tax SEXKZ CHAR 1 0
1 Male
2 Female
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
REGIO Region (State, Province, County) REGIO CHAR 3 0
QLAND Withholding Tax Country Key QLAND CHAR 3 0
QPROZ Percentage Subject to Withholding Tax QPROZ DEC 5 2
BUDAT Posting Date in the Document BUDAT DATS 8 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
WRBTR Amount in document currency WRBTR CURR 13 2
DMBTR Amount in Local Currency DMBTR CURR 13 2
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QSSHH Withholding Tax Base Amount (Local Currency) QSSHH CURR 13 2
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
QBSHH Withholding Tax Amount (in Local Currency) QBSHH CURR 13 2
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
QSFBH Amount Exempt from Withholding Tax (in Local Currency) QSFBH CURR 13 2
KURSF Exchange rate KURSF DEC 9 5
WAERQ Currency Key for Withholding Tax Report QSWAERS CHAR 5 0
NOHIJ Tax - Number of Children NOHIJ DEC 2 0