SAP table T5G_DTONI (National Insurance Data Take-on)
SAP table T5G_DTONI has 8 primary key fields being MANDT,PERNR,NICAT,CTOUT,DIRFB,PAYTY,PAYID,PAYDT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
Personnel Number
NUMC
8
0
PERNR_D
NI category (GB)
CHAR
2
0
T5G42
NICAT
Contracted Out Flag
CHAR
1
0
P08_CTOUT
NI director indicator
CHAR
1
0
DIRFB
Payroll type
CHAR
1
0
PAYTY
Possible values
Regular payroll run
A
Bonus payment
B
Correction accounting
C
Manual check
S
Additional payment
Payroll Identifier
CHAR
1
0
PAYID
Pay date for payroll result
DATS
8
0
PAY_DATE
ASSGM
Assignment number
RAW
1
0
P08_ASSGM
PRRTY
NI calculation priority
NUMC
2
0
P08_PRRTY
APPS
APPS flag
CHAR
1
0
P08_APPS
DIRRP
Director with regular payments
CHAR
1
0
P08_DIRRP
DIRPW
Director number of tax weeks for pro-rating
NUMC
2
0
P08_DIRPW
LSFLG
Late starter /forgotten time sheet flag
CHAR
1
0
P08_LSFLG
Possible values
not late starter/forgotten time sheet
A
late starter/forgotten time sheet to be processed this run
X
late starter/forgotten time sheet
Y
late starter/forgotten time sheet yet to be processed
LTLVR
Late leaver flag
CHAR
1
0
P08_LTLVR
WK6FL
Contracted-out later than six weeks after leaving flag
CHAR
1
0
P08_WK6FL
NIPAY
Niable pay
CURR
15
2
P08_NI_PAY
NIBASE
Niable pay base
CURR
15
2
P08_NIBASE
AMTTOLEL
Niable pay up to LEL
CURR
15
2
P08_TOLEL
AMTLELEET
Niable pay between LEL and PT
CURR
15
2
P08_TOEET
AMTEETERT
Niable pay between PT and ST
CURR
15
2
P08_TOERT
AMTERTUEL
Niable pay between ST and UST/AUST/UEL
CURR
15
2
P08_TOUEL
AMTFROMUEL
Niable pay above UEL
CURR
15
2
P08_FMUEL
EENIC
Employee NICs
CURR
15
2
P08_NIC_EE
ERNIC
Employer NICs
CURR
15
2
P08_NIC_ER
EENIR
Employee (primary) NI rebate
CURR
15
2
P08_NIREE
ERNIR
Employer (secondary) NI rebate
CURR
15
2
P08_NIRER
DELFLG
Delete Flag for Data Take On for National Tables
CHAR
1
0
P08_DTODEL
SRCFLG
Flag for source of adjustment data(NI)
CHAR
1
0
P08_SRCFLG
AMTERTUAP
Niable pay between ST and UAP
CURR
15
2
P08_TOUAP
AMTFROMUST
Niable Pay from UST to AUST
CURR
15
2
P08_FMUST
AMTERTFUST
Niable pay between PT - FUST
CURR
15
2
P08_FTOUEL
T5G_DTONI foreign key relationships
Table
Field
Check Table
Check Field
0 T5G_DTONI
NICAT
T5G42 HR-GB: National Insurance Categories
NICAT
0 T5G_DTONI
NICAT
T5G42 HR-GB: National Insurance Categories
CTOUT
0 T5G_DTONI
NICAT
T5G42 HR-GB: National Insurance Categories
ENDDA