SAP Table P0062

HR master record Infotype 0062 (Tax - Spain)

P0062 (HR master record Infotype 0062 (Tax - 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 P0062 to other SAP tables.

P0062 table fields

Field Data element Checktable Datatype Length Decimals
PERNR Personnel Number PERNR_D NUMC 8 0
INFTY Infotype INFTY T582A CHAR 4 0
SUBTY Subtype SUBTY CHAR 4 0
OBJPS Object Identification OBJPS CHAR 2 0
SPRPS Lock Indicator for HR Master Data Record SPRPS CHAR 1 0
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
SEQNR Number of Infotype Record with Same Key SEQNR NUMC 3 0
AEDTM Changed On AEDAT DATS 8 0
UNAME Name of Person Who Changed Object AENAM CHAR 12 0
HISTO Historical Record Flag HISTO CHAR 1 0
ITXEX Text Exists for Infotype ITXEX CHAR 1 0
X Yes
NULL No
REFEX Reference Fields Exist (Primary/Secondary Costs) PRFEX CHAR 1 0
X Yes
NULL No
ORDEX Confirmation Fields Exist ORDEX CHAR 1 0
X Yes
NULL No
ITBLD Infotype Screen Control ITBLD CHAR 2 0
PREAS Reason for Changing Master Data PREAS T530E CHAR 2 0
FLAG1 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG2 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG3 Reserved Field/Unused Field NUSED CHAR 1 0
FLAG4 Reserved Field/Unused Field NUSED CHAR 1 0
RESE1 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
RESE2 Reserved Field/Unused Field of Length 2 NUSED2 CHAR 2 0
GRPVL Grouping Value for Personnel Assignments PCCE_GPVAL CHAR 4 0
CODIM Tax payer's reference number (NIF) CODIM CHAR 9 0
CODAU Tax modifier (employment tax) CODAU NUMC 2 0
01 Araba/Alava
20 Gipuzkoa
31 Navarra
48 Bizkaia
51 Ceuta
52 Melilla
99 Other provinces
FAMST Marital status FAMS1 CHAR 1 0
NOHIJ Number of family members relevant for employment tax (IRPF) PES_NFAMI DEC 2 0
SBRUT Gross salary SBRUT CURR 9 2
VESFI Fixed variable payments VESFI CURR 9 2
VESVR Variable variable payments VESVR CURR 9 2
PORAP Percentage applied PORAP DEC 2 0
CPER1 Payment key CPERX T5EIA CHAR 1 0
MOTIV Change reason MOTIV T5E38 NUMC 2 0
FAMNU Challenge category for fiscal purposes PES_CATMIN CHAR 1 0
3 Grade between 33% and 65%
A Grade between 33% and 65% w/helps
6 Grade equal or greater than 65%
PERTR Work permit number PERT1 CHAR 9 0
CPER2 Payment subkey CPER2 NUMC 1 0
PGEES Payment in kind for IRPF PGEES CURR 9 2
PECOM Compensatory payments PECOM CURR 9 2
QLAND Country code PB04_QLAND CHAR 3 0
RENIR Reduction due to irregular performances PES_RENIR CURR 9 2
COTIZ Social insurance or healthcare company costs PES_COTIZ CURR 9 2
ALIME Annuities for child maintenance PES_ALIME CURR 9 2
REGRT Employment tax (IRPF): Deductions up to adjustment PES_REGRT CURR 9 2
REGBR Gross annual salary received PES_REGBR CURR 9 2
PORA4 Employment tax (IRPF) code applied PES_PORAP DEC 4 2
PROVN Province PES_PROVN T005S CHAR 3 0
CD296 Foreign code PES_296CD CHAR 12 0
PORDB Employment tax code stored (database only not displayed) PES_PORDB DEC 4 2
FFRMG End date PES_ENDDA DATS 8 0
FNOIR Payroll date for adjustment amounts PES_FNOIR DATS 8 0
PORPR Previous IRPF percentage PES_PORPR DEC 4 2
PORNM Employment tax (IRPF) code applied PES_PORAP DEC 4 2
ART81 Apply Article 81.5 PES_ART81 CHAR 1 0
NULL No
X Yes
MOCON Contract type for tax according to the tax office PES_MOCON CHAR 1 0
1 General contract
2 Contract of less than one year duration
3 Special dependent work relationship
PORNA Payroll percentage maintained automatically PES_PORNA CHAR 1 0
SEXPA Foreigner situation PES_SEXPA CHAR 1 0
1 Resident
2 Expatriate
3 Resident expatriate
MIPAG Decrease due to mortgage PES_MIPAG CHAR 1 0
NULL Without loan
X Transitional arrangements (up to 12/31/2010)
1 Normal arrangements (as of 01/01/2011)
MINOP Applied decrease PES_MINOP CURR 9 2
RENI2 Reduction due to irregular performance PES_RENI2 CURR 9 2
SITPER Personal situation for employment tax PES_SITPER CHAR 1 0
1 Other family situations
C W/ spouse in care
M Single parent
WERTX Reduction due to extentsion of work activity PES_WERTX CHAR 1 0
X Yes
NULL No

P0062 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0062 CPER1 P0062 CPER1 T5EIA Payment keys CPER1
P0062 CPER1 * T5EIA Payment keys ENDDA
P0062 CPER1 SYST MANDT T5EIA Payment keys MANDT
P0062 CPER1 P0062 CODAU T5EIA Payment keys REGFI
P0062 INFTY P0062 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0062 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0062 MOTIV SYST MANDT T5E38 Reasons for IRPF percentage change MANDT
P0062 MOTIV P0062 MOTIV T5E38 Reasons for IRPF percentage change MOTIV
P0062 PREAS SYST MANDT T530E Reasons for Changes MANDT
P0062 PREAS P0062 INFTY T530E Reasons for Changes INFTY
P0062 PREAS P0062 PREAS T530E Reasons for Changes PREAS
P0062 PROVN P0062 PROVN T005S Taxes: Region (Province) Key BLAND
P0062 PROVN SYST MANDT T005S Taxes: Region (Province) Key MANDT
P0062 PROVN 'ES' T005S Taxes: Region (Province) Key LAND1