QSTRE SAP (FI/HR Withholding Tax Report for Spain) Table details

Dictionary Type: Table
Description: FI/HR Withholding Tax Report for Spain




ABAP Code to SELECT data from QSTRE
Related tables to QSTRE
Access table QSTRE




Table field list including key, data, relationships and ABAP select examples

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.

The QSTRE table consists of various fields, each holding specific information or linking keys about FI/HR Withholding Tax Report for Spain data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), BUZEI (Number of Line Item Within Accounting Document), GJAHR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP QSTRE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DATHERData Origin for Table QSTRE QSDATHERCHAR1QSDATHER
FPRCDProvincial tax code FPRCDCHAR3FPRCD
QSREPRecipient Code for Recipient Type QSREPCHAR3QSREP
QEKARIncome Type QEKARCHAR4Assigned to domainQEKAR
KZDPCInd.fr Donations/Pyts on Act (Donativos/Pagos) fr Wth.Tx Rep QSKZDPCCHAR1CHAR01
STECDTax Number 1 STCD1CHAR16STCD1
STCEGVAT Registration Number STCEGCHAR20STCEG
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
STRASHouse number and street STRAS_GPCHAR35TEXT35
GBDATDate of birth of the person subject to withholding tax GBDAT_QDATS8DATUM
GBORTPlace of birth of the person subject to withholding tax GBORT_QCHAR25TEXT25
GBPRONative Region of the Party Subject to Withholding Tax GBPRO_QCHAR3TEXT3
SEXKZKey for the Sex of the Person Subject to Withholding Tax SEXKZCHAR1SEXKZ
STKZNNatural Person STKZNCHAR1STKZN
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
QLANDWithholding Tax Country Key QLANDCHAR3Assigned to domainQLAND
QPROZPercentage Subject to Withholding Tax QPROZDEC5(2) PRZ32
BUDATPosting Date in the Document BUDATDATS8DATUM
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
QSSHHWithholding Tax Base Amount (Local Currency) QSSHHCURR13(2) WERT7
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QBSHHWithholding Tax Amount (in Local Currency) QBSHHCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
QSFBHAmount Exempt from Withholding Tax (in Local Currency) QSFBHCURR13(2) WERT7
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
WAERQCurrency Key for Withholding Tax Report QSWAERSCHAR5QSWAERS
NOHIJTax - Number of Children NOHIJDEC2DEC2

Key field Non-key field



How do I retrieve data from SAP table QSTRE using ABAP code

The following ABAP code Example will allow you to do a basic selection on QSTRE to SELECT all data from the table
DATA: WA_QSTRE TYPE QSTRE.

SELECT SINGLE *
FROM QSTRE
INTO CORRESPONDING FIELDS OF WA_QSTRE
WHERE...

How to access SAP table QSTRE

Within an ECC or HANA version of SAP you can also view further information about QSTRE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!