SAP TABLES | Financial Accounting | General Ledger Accounting | Information System(FI-GL-IS) SAP FI

QSTRE SAP FI/HR Withholding Tax Report for Spain Table and data







QSTRE is a standard SAP Table which is used to store FI/HR Withholding Tax Report for Spain data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP QSTRE Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: L - Table for storing temporary data, delivered empty

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories


SAP QSTRE Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
BUKRSBUKRSCHAR4
*
Company Code
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
DATHERQSDATHERCHAR1 Data Origin for Table QSTRE
FPRCDFPRCDCHAR3 Provincial tax code
QSREPQSREPCHAR3 Recipient Code for Recipient Type
QEKARQEKARCHAR4
*
Income Type
KZDPCQSKZDPCCHAR1 Ind.fr Donations/Pyts on Act (Donativos/Pagos) fr Wth.Tx Rep
STECDSTCD1CHAR16 Tax Number 1
STCEGSTCEGCHAR20 VAT Registration Number
NAME1NAME1_GPCHAR35 Name 1
NAME2NAME2_GPCHAR35 Name 2
ORT01ORT01_GPCHAR35 City
PSTLZPSTLZCHAR10 Postal Code
STRASSTRAS_GPCHAR35 House number and street
GBDATGBDAT_QDATS8 Date of birth of the person subject to withholding tax
GBORTGBORT_QCHAR25 Place of birth of the person subject to withholding tax
GBPROGBPRO_QCHAR3 Native Region of the Party Subject to Withholding Tax
SEXKZSEXKZCHAR1 Key for the Sex of the Person Subject to Withholding Tax
STKZNSTKZNCHAR1 Natural Person
QLANDQLANDCHAR3
*
Withholding Tax Country Key
QPROZQPROZDEC5(2) Percentage Subject to Withholding Tax
BUDATBUDATDATS8 Posting Date in the Document
QSSKZQSSKZCHAR2
*
Withholding Tax Code
QSZNRQSZNRCHAR10 Certificate Number of the Withholding Tax Exemption
WRBTRWRBTRCURR13(2) Amount in document currency
DMBTRDMBTRCURR13(2) Amount in Local Currency
QSSHBQSSHBCURR13(2) Withholding Tax Base Amount
QSSHHQSSHHCURR13(2) Withholding Tax Base Amount (Local Currency)
QBSHBQBSHBCURR13(2) Withholding Tax Amount (in Document Currency)
QBSHHQBSHHCURR13(2) Withholding Tax Amount (in Local Currency)
QSFBTQSFBTCURR13(2) Withholding Tax-Exempt Amount (in Document Currency)
QSFBHQSFBHCURR13(2) Amount Exempt from Withholding Tax (in Local Currency)
KURSFKURSFDEC9(5) Exchange rateEXCRT
WAERQQSWAERSCHAR5 Currency Key for Withholding Tax Report
NOHIJNOHIJDEC2 Tax - Number of Children



Key field
Non-key field