SAP Table P0060

HR Master Record: Infotype 0060 (Fiscal Data - NL)

P0060 (HR Master Record: Infotype 0060 (Fiscal Data - NL)) 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 P0060 to other SAP tables.

Source: P0060 (HR Master Record: Infotype 0060 (Fiscal Data - NL))

P0060 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
SOFIN SoFi Number SOFIN NUMC 9 0
KDLHF Conversion Rule P052_KDLHF T5N2A CHAR 1 0
BGLST Marital Status According to Indiv. Employment Tax Statement BGLST T5N2C NUMC 1 0
TABEL Calculation Table P05_TABEL T5N2D CHAR 1 0
TIJDV Period Table for Wage Tax [LH] Calculation TIJDV T5N2M CHAR 1 0
TARGR Tax Credit According to Individual Employment Tax Statement TARGR T5N2G CHAR 1 0
INKKD Income Indicator INKKD T5NII NUMC 2 0
JAARL Annual Amount Appl.to Spec. Tax Relief for Deductible Items JAARL NUMC 6 0
JRLOT Annual Salary for Special Tax Rate JRLOT DEC 6 0
BYZTR Special Tax Rate BYZTR DEC 4 2
MACHT Date for Special Tax Rate MACHT DATS 8 0
BEPBT Calculation Method for Special Tax Rate Percentage BEPBT CHAR 1 0
BAFTD Special Employment Tax Relief for Deductible Items BAFTD DATS 8 0
BAFTB Special Employment Tax Relief Amount for Deductible Items BAFTB CURR 7 2
BTARD Decision Date for Change of Tax Class BTARD DATS 8 0
BTART Indicator for the Ruling of the Tax Inspector (Decision) BTART NUMC 1 0
0 No Decision
1 Decision on Deductible Items
2 Decision on Different Tax Class
3 Decision on Low Tax Rate for Non-resident Taxpayers
4 Combination of 1, 2 and/or 3
BLTBD Date for Different Conversion Rule BLTBD DATS 8 0
SPEC1 Special Tax Indicator SPAAN T5N2S CHAR 2 0
SPEC2 Special Tax Indicator SPAAN T5N2S CHAR 2 0
SPEC3 Special Tax Indicator SPAAN T5N2S CHAR 2 0
SPEC4 Special Tax Indicator SPAAN T5N2S CHAR 2 0
SPEC5 Special Tax Indicator SPAAN T5N2S CHAR 2 0
AUSNA Special Employee Groups AUSNS T5N2Q CHAR 3 0
GEMBZ SI Exemption for Conscientious Reasons GEMBZ CHAR 1 0
NULL No Conscientious Objections
1 Conscientious Objections for Social Insurance
2 Conscientious Objections for Employed Pers. Ins. Schemes
3 Conscient.Objections for Soc.Ins.and Emplyd Pers.Ins.Schemes
ONKST Special Expense Regulations P05_ONKST CHAR 2 0
01 30% Scheme for SI
02 30% Scheme for Taxes
03 30% Scheme SI Advantage for ER
04 30% Scheme Tax Advantage for ER
05 New 30% Rule
06 New 30% Rule Advantage ER
ATRFG Different Tax Class P05_ATRFG T5N2G CHAR 1 0
AKLHF Different Conversion Rule P05_AKLHF T5N2A CHAR 1 0
CDFIS Notification Tax Authority P05_CDFIS T5N9D CHAR 2 0
CDVDR Yes/No Field Advantage Rule P05_CDVDR CHAR 1 0
OTHOG Increased Compensatory Allowance [Overhevelingstoeslag] P05_OTHOG CHAR 1 0
X Yes
NULL No
AFBBT Different Amount Special Rate P05_AFBBT CURR 7 2
VERSI Version Number for Conversion of IT0060 P05_VERSIE CHAR 1 0
PWNBD Part-Time Employee (According to Tax Authority Definition) P05_PARTTIMER_BD CHAR 1 0
X true
- false
NULL unknown
NOTHK No Temporary Tax Credit P05_NO_THK CHAR 1 0
X Yes
NULL No

P0060 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
P0060 AKLHF SYST MANDT T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) MANDT
P0060 AKLHF P0060 AKLHF T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) KDLHF
P0060 AKLHF * T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) ENDDA
P0060 ATRFG SYST LANGU T5N2G Tax Classes for Wage Tax [loonheffing] (NL) MANDT
P0060 ATRFG P0060 ATRFG T5N2G Tax Classes for Wage Tax [loonheffing] (NL) TARGR
P0060 ATRFG * T5N2G Tax Classes for Wage Tax [loonheffing] (NL) ENDDA
P0060 AUSNA * T5N2Q Wage Tax [Loonheffing] Exemptions (NL) ENDDA
P0060 AUSNA * T5N2Q Wage Tax [Loonheffing] Exemptions (NL) LEEFT
P0060 AUSNA P0060 AUSNA T5N2Q Wage Tax [Loonheffing] Exemptions (NL) AUSNA
P0060 AUSNA SYST MANDT T5N2Q Wage Tax [Loonheffing] Exemptions (NL) MANDT
P0060 BGLST SYST MANDT T5N2C Marital Status for Wage Tax [Loonheffing] (NL) MANDT
P0060 BGLST SYST LANGU T5N2C Marital Status for Wage Tax [Loonheffing] (NL) SPRSL
P0060 BGLST P0060 BGLST T5N2C Marital Status for Wage Tax [Loonheffing] (NL) BGLST
P0060 CDFIS '02' T5N9D Executive Authority and Tax Office Notification (NL) SOORT
P0060 CDFIS SYST MANDT T5N9D Executive Authority and Tax Office Notification (NL) MANDT
P0060 CDFIS P0060 CDFIS T5N9D Executive Authority and Tax Office Notification (NL) CDMDG
P0060 INFTY P0060 INFTY T582A Infotypes: Customer-Specific Settings INFTY
P0060 INFTY SYST MANDT T582A Infotypes: Customer-Specific Settings MANDT
P0060 INKKD P0060 INKKD T5NII Income Indicators (NL) INKKD
P0060 INKKD SYST MANDT T5NII Income Indicators (NL) MANDT
P0060 INKKD * T5NII Income Indicators (NL) ENDDA
P0060 KDLHF * T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) ENDDA
P0060 KDLHF P0060 KDLHF T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) KDLHF
P0060 KDLHF SYST MANDT T5N2A Wage tax [loonheffing] Conversion Rule Indicators (NL) MANDT
P0060 PREAS SYST MANDT T530E Reasons for Changes MANDT
P0060 PREAS P0060 INFTY T530E Reasons for Changes INFTY
P0060 PREAS P0060 PREAS T530E Reasons for Changes PREAS
P0060 SPEC1 P0060 SPEC1 T5N2S Special Indicator Codes (Tax Authority) SPECA
P0060 SPEC1 SYST MANDT T5N2S Special Indicator Codes (Tax Authority) MANDT
P0060 SPEC2 SYST MANDT T5N2S Special Indicator Codes (Tax Authority) MANDT
P0060 SPEC2 P0060 SPEC2 T5N2S Special Indicator Codes (Tax Authority) SPECA
P0060 SPEC3 SYST MANDT T5N2S Special Indicator Codes (Tax Authority) MANDT
P0060 SPEC3 P0060 SPEC3 T5N2S Special Indicator Codes (Tax Authority) SPECA
P0060 SPEC4 SYST MANDT T5N2S Special Indicator Codes (Tax Authority) MANDT
P0060 SPEC4 P0060 SPEC4 T5N2S Special Indicator Codes (Tax Authority) SPECA
P0060 SPEC5 SYST MANDT T5N2S Special Indicator Codes (Tax Authority) MANDT
P0060 SPEC5 P0060 SPEC5 T5N2S Special Indicator Codes (Tax Authority) SPECA
P0060 TABEL SYST MANDT T5N2D Tax Table Category (NL) MANDT
P0060 TABEL * T5N2D Tax Table Category (NL) ENDDA
P0060 TABEL P0060 TABEL T5N2D Tax Table Category (NL) TABEL
P0060 TARGR * T5N2G Tax Classes for Wage Tax [loonheffing] (NL) ENDDA
P0060 TARGR P0060 TARGR T5N2G Tax Classes for Wage Tax [loonheffing] (NL) TARGR
P0060 TARGR SYST MANDT T5N2G Tax Classes for Wage Tax [loonheffing] (NL) MANDT
P0060 TIJDV SYST MANDT T5N2M Tax Table Periods (NL) MANDT
P0060 TIJDV P0060 TIJDV T5N2M Tax Table Periods (NL) TIJDV
P0060 TIJDV * T5N2M Tax Table Periods (NL) ENDDA