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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QSTRE	Table Relationship Diagram
Short Description	FI/HR Withholding Tax Report for Spain

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
5	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	DATHER	☐	QSDATHER	QSDATHER	CHAR	1	0	Data Origin for Table QSTRE
7	FPRCD	☐	FPRCD	FPRCD	CHAR	3	0	Provincial tax code
8	QSREP	☐	QSREP	QSREP	CHAR	3	0	Recipient Code for Recipient Type
9	QEKAR	☐	QEKAR	QEKAR	CHAR	4	0	Income Type	*
10	KZDPC	☐	QSKZDPC	CHAR01	CHAR	1	0	Ind.fr Donations/Pyts on Act (Donativos/Pagos) fr Wth.Tx Rep
11	STECD	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
12	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
13	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
14	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
15	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
17	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
18	GBDAT	☐	GBDAT_Q	DATUM	DATS	8	0	Date of birth of the person subject to withholding tax
19	GBORT	☐	GBORT_Q	TEXT25	CHAR	25	0	Place of birth of the person subject to withholding tax
20	GBPRO	☐	GBPRO_Q	TEXT3	CHAR	3	0	Native Region of the Party Subject to Withholding Tax
21	SEXKZ	☐	SEXKZ	SEXKZ	CHAR	1	0	Key for the Sex of the Person Subject to Withholding Tax
22	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
23	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
24	QLAND	☐	QLAND	QLAND	CHAR	3	0	Withholding Tax Country Key	*
25	QPROZ	☐	QPROZ	PRZ32	DEC	5	2	Percentage Subject to Withholding Tax
26	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
27	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
28	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
29	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
30	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
31	QSSHB	☐	QSSHB	WERT7	CURR	13	2	Withholding Tax Base Amount
32	QSSHH	☐	QSSHH	WERT7	CURR	13	2	Withholding Tax Base Amount (Local Currency)
33	QBSHB	☐	QBSHB	WERT7	CURR	13	2	Withholding Tax Amount (in Document Currency)
34	QBSHH	☐	QBSHH	WERT7	CURR	13	2	Withholding Tax Amount (in Local Currency)
35	QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
36	QSFBH	☐	QSFBH	WERT7	CURR	13	2	Amount Exempt from Withholding Tax (in Local Currency)
37	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
38	WAERQ	☐	QSWAERS	QSWAERS	CHAR	5	0	Currency Key for Withholding Tax Report
39	NOHIJ	☐	NOHIJ	DEC2	DEC	2	0	Tax - Number of Children

History

Last changed by/on	SAP	20130529
SAP Release Created in