SAP ABAP Table HCMT_BSP_PA_ES_R0062 (Tax data Spain)

Hierarchy

☛ EA-HRCES (Software Component) Sub component EA-HRCES of EA-HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PAOC_PAD_UI_ES (Package) User Interface for Personnel Administration - Spain

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_ES_R0062	Table Relationship Diagram
Short Description	Tax data Spain

Delivery and Maintenance

Pool/cluster
Delivery Class
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	OBJECT_KEY	☑	HCM_OBJECT_KEY		CHAR	100	0	HCM Object Key
2	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
3	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	SPRTX	☐	SPRPSTEXT	SPRPSTEXT	CHAR	40	0	Lock indicator for HR master record (text)
9	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
10	BEGDA	☐	PAD_BEGDA	DATUM	DATS	8	0	Valid-From Date
11	ENDDA	☐	PAD_ENDDA	DATUM	DATS	8	0	Valid To Date
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	CODIM	☐	CODIM	CHAR9	CHAR	9	0	Tax payer's reference number (NIF)
14	PERTR	☐	PERT1	CHAR9	CHAR	9	0	Work permit number
15	QLAND	☐	PES_ILAND	LAND1	CHAR	3	0	Country code	*
16	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
17	CD296	☐	PES_296CD	CHAR12	CHAR	12	0	Foreign code
18	PROVN	☐	PES_PROVN	REGIO	CHAR	3	0	Province	T005S
19	TPROV	☐	TPROV	TEXT30	CHAR	30	0	Text for country indicator
20	CODAU	☐	CODAU	PB04_CODAU	NUMC	2	0	Tax modifier (employment tax)
21	CPER1	☐	CPERX	CPERX	CHAR	1	0	Payment key	T5EIA
22	CTEXT	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
23	FATXT	☐	FATXT	FATXT	CHAR	6	0	Marital Status
24	FAMST	☐	FAMS1	FAMST	CHAR	1	0	Marital status	*
25	SITPER	☐	PES_SITPER	PES_SITPER	CHAR	1	0	Personal situation for employment tax
26	FAMNU	☐	PES_CATMIN	PES_CATMIN	CHAR	1	0	Challenge category for fiscal purposes
27	FFRMG	☐	PES_FFRMG	DATUM	DATS	8	0	Reduction end date due to geographical mobility
28	NOHIJ	☐	PES_NFAMI	DEC2	DEC	2	0	Number of family members relevant for employment tax (IRPF)
29	SBRUT	☐	SBRUT	WERTV5	CURR	9	2	Gross salary
30	WAERS_SBRUT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
31	VESFI	☐	VESFI	WERTV5	CURR	9	2	Fixed variable payments
32	WAERS_VESFI	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
33	VESVR	☐	VESVR	WERTV5	CURR	9	2	Variable variable payments
34	WAERS_VESVR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
35	PGEES	☐	PGEES	WERTV5	CURR	9	2	Payment in kind for IRPF
36	WAERS_PGEES	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
37	WAERS_RETOT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	RENIR	☐	PES_RENIR	WERTV5	CURR	9	2	Reduction due to irregular performances
39	WAERS_RENIR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	RENI2	☐	PES_RENI2	WERTV5	CURR	9	2	Reduction due to irregular performance
41	WAERS_RENI2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
42	COTIZ	☐	PES_COTIZ	WERTV5	CURR	9	2	Social insurance or healthcare company costs
43	WAERS_COTIZ	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
44	SPRED	☐	PES_SPRED	WERTV5	CURR	9	2	Employment tax (IRPF): Other reductions
45	WAERS_SPRED	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
46	PECOM	☐	PECOM	WERTV5	CURR	9	2	Compensatory payments
47	WAERS_PECOM	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
48	ALIME	☐	PES_ALIME	WERTV5	CURR	9	2	Annuities for child maintenance
49	WAERS_ALIME	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
50	WAERS_SUMME	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
51	PORCL	☐	PRCAL	DEC2_2	DEC	4	2	Calculated employment tax type
52	SIMBL_PORCL	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
53	PORDB	☐	PES_PORDB	DEC2_2	DEC	4	2	Employment tax code stored (database only not displayed)
54	PORA4	☐	PES_PORAP	DEC2_2	DEC	4	2	Employment tax (IRPF) code applied
55	SIMBL_PORA4	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
56	MOTIV	☐	MOTIV	MOTIV	NUMC	2	0	Reason for markdown	T5E38
57	REGRT	☐	PES_REGRT	WERTV5	CURR	9	2	Employment tax (IRPF): Deductions up to adjustment
58	WAERS_REGRT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
59	REGBR	☐	PES_REGBR	WERTV5	CURR	9	2	Gross annual salary received
60	WAERS_REGBR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
61	CAUTX	☐	PES_CAUTX	CHAR26	CHAR	26	0	Reason for adjustment
62	PORNM	☐	PES_PORAP	DEC2_2	DEC	4	2	Employment tax (IRPF) code applied
63	SIMBL_PORNM	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
64	SEXPA	☐	PES_SEXPA	PES_SEXPA	CHAR	1	0	Expatriate situation
65	MOCON	☐	PES_MOCON	PES_MOCON	CHAR	1	0	Contract type for tax according to the tax office
66	PORPR	☐	PES_PORPR	DEC2_2	DEC	4	2	Previous IRPF percentage
67	SIMBL_PORPR	☐	PAD_PRCNT	PAD_PRCNT	CHAR	1	0	Percentage
68	MOCON_TEXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
69	CPER2	☐	CPER2	CPER2	NUMC	1	0	Payment subkey
70	MIPAG	☐	PES_MIPA2	PES_MIPAG	CHAR	1	0	Decrease due to mortgage
71	MINOP	☐	PES_MINOP	WERT05	CURR	9	2	Applied decrease
72	WERTX	☐	PES_WERTX	XFELD	CHAR	1	0	Reduction due to extentsion of work activity
73	.INCLUDE	☐				0	0	Settlement base (Details)
74	RETOT	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
75	MINPE	☐	PES_MINPE	WERTV5	CURR	9	2	Employment tax (IRPF): Personal minimum
76	MINHI	☐	PES_MINHI	WERTV5	CURR	9	2	Employment tax (IRPF): Family minimum for children
77	RENTR	☐	PES_RENTR	WERTV5	CURR	9	2	Employment tax (IRPF): Reduction for work performance
78	PRACL	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
79	MOVGE	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
80	DISTA	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
81	CUIHI	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
82	XEDAD	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
83	ASIST	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
84	DISTN	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
85	PENSS	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
86	MAS2H	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
87	SUMME	☐	PES_BALIQ	WERTV5	CURR	9	2	Settlement basis for employment tax (IRPF)
88	XEDAC	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
89	ASISC	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
90	MINVC	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
91	ASIMC	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
92	MINVD	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
93	ASIMD	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
94	XEDAA	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
95	ASISA	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
96	MINVA	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
97	ASIMA	☐	PES_IBETR	WERTV5	CURR	9	2	Amount for employment tax calculation
98	.INCLUDE	☐				0	0	Next of kin (Details)
99	NASCD	☐	PES_NASCD	NUMC2	NUMC	2	0	Number of ancestors for employment tax
100	NDESC	☐	PES_NDESC	NUMC2	NUMC	2	0	Employment tax (IRPF): Number of descendants
101	NDE01	☐	PES_NDE01	NUMC2	NUMC	2	0	Employment tax (IRPF): Descendants under 3 years old
102	NDE02	☐	PES_NDE02	NUMC2	NUMC	2	0	Employment tax (IRPF): Descendants aged between 3 and 16
103	NDE03	☐	PES_NDE03	NUMC2	NUMC	2	0	Employment tax (IRPF): Descendants aged between 16 and 25
104	NDM33	☐	PES_NDM33	NUMC2	NUMC	2	0	IRPF: Descendants between 33% and 65% disabled
105	NDM65	☐	PES_NDM65	NUMC2	NUMC	2	0	Descendants 65% disabled or over
106	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_ES_R0062	CPER1	T5EIA	CPER1	REF	1	CN
2	HCMT_BSP_PA_ES_R0062	LAND1	T005	LAND1	KEY
3	HCMT_BSP_PA_ES_R0062	MOTIV	T5E38	MOTIV	KEY	1	CN
4	HCMT_BSP_PA_ES_R0062	PROVN	T005S	BLAND

History

Last changed by/on	SAP	20131127
SAP Release Created in	100