SAP Table T5G42

HR-GB: National Insurance Categories

T5G42 (HR-GB: National Insurance Categories) 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 T5G42 to other SAP tables.

T5G42 table fields

Field Data element Checktable Datatype Length Decimals
NICAT NI category (GB) NICAT CHAR 2 0
CTOUT Contracted Out Flag P08_CTOUT CHAR 1 0
X Yes
NULL No
ENDDA End Date ENDDA DATS 8 0
BEGDA Start Date BEGDA DATS 8 0
NITXT HR-GB: National insurance category text P08_NITXT CHAR 60 0
COPEN Contracted out NI Category P08_COPEN CHAR 1 0
M COMPS
S COSRS
NULL Not contracted out
LVCAT HR-GB. NI category mapping for late payments to leavers P08_LVCAT T5G42 CHAR 2 0
CERNI HR-GB: Certificate for NI category P08_CERNI CHAR 1 0
A CA4139 - Female only reduced rate
B CA4140 - Age exemption
C CA2700 - Deferment
NULL No certificate
D CA4140/CA2700 Age exemption or Deferment
MFCAT HR-GB: Allowed gender for NI category P08_MFCAT CHAR 1 0
M Male
F Female
NULL Gender independent
EOYF1 HR-GB: EOY indicator for NI exclusion (Column 1a, to LEL) P08_EOYF1 CHAR 1 0
X Yes
NULL No
EOYF2 HR-GB: EOY indicator for NI exclusion (Column 1b, LEL-EET) P08_EOYF2 CHAR 1 0
X Yes
NULL No
EOYF3 HR-GB: EOY indicator for NI exclusion (Column 1c, ERT-UEL) P08_EOYF3 CHAR 1 0
X Yes
NULL No
EOYF4 HR-GB: EOY indicator for NI exclusion (Earnings from UEL) P08_EOYF4 CHAR 1 0
X Yes
NULL No
EOYF5 HR-GB: EOY indicator for NI exclusion (Column 1d Ee+Er NICs) P08_EOYF5 CHAR 1 0
X Yes
NULL No
EOYF6 HR-GB: EOY indicator for NI exclusion (Er NICs) P08_EOYF6 CHAR 1 0
X Yes
NULL No
EOYF7 HR-GB: EOY indicator for NI exclusion (Column 1e, Ee NICs) P08_EOYF7 CHAR 1 0
X Yes
NULL No

T5G42 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T5G42 LVCAT T5G42 LVCAT T5G42 HR-GB: National Insurance Categories NICAT
T5G42 LVCAT * T5G42 HR-GB: National Insurance Categories CTOUT
T5G42 LVCAT * T5G42 HR-GB: National Insurance Categories ENDDA