SAP table T5KR0 (Record of Employment (ROE) History)
SAP table T5KR0 has 5 primary key fields being MANDT,PERNR,LSTDT,RUNID,SEQNO.
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
T000
MANDT
Personnel Number
NUMC
8
0
PERNR_D
Last Day For Which Paid
DATS
8
0
PCA_ROE_LSTDT
Evaluation run ID
NUMC
10
0
PCERT
PCAL_ERNID
Sequential number
NUMC
2
0
PCA_SEQNO
ACTUAL
Update indicator for payroll reporting status
CHAR
1
0
P_ACTSTAT
FSTDT
First Day Worked
DATS
8
0
PCA_ROE_FSTDT
RUNDT
ROE run date
DATS
8
0
PCA_ROE_RUNDT
ROEDT
ROE Issue date
DATS
8
0
PCA_ROE_ROEDT
ROESN
ROE Serial Number
CHAR
9
0
T5KR1
PCA_ROE_ROESN
ORGSN
Amended ROE Serial Number
CHAR
9
0
T5KR1
PCA_ROE_ORGSN
CDSEQ1
Sequence Number
NUMC
5
0
CDSEQ
CDSEQ2
Sequence Number
NUMC
5
0
CDSEQ
STATUS
Reporting status
CHAR
2
0
PNA_STATUS
Possible values
00
New
01
New - 53 (Web only)
22
Magnetic media created
31
Run created
50
Run filed with government
60
Exported with errors
61
Exported
62
Imported with errors
63
Imported
68
Run completed with errors
69
Run completed
70
Make run available on ESS
80
EE form copy printed
91
Run voided
CREATOR
User Name
CHAR
12
0
USERNAME
CREADATE
Created On
DATS
8
0
HIER_FDATE
CREATIME
Created at
TIMS
6
0
HIER_FTIME
T5KR0 foreign key relationships
Table
Field
Check Table
Check Field
0 T5KR0
ORGSN
T5KR1 ROE serial number reference table
MANDT
1 T5KR0
ROESN
T5KR1 ROE serial number reference table
MANDT
0 T5KR0
RUNID
PCERT Payroll Posting Runs
MANDT
0 T5KR0
RUNID
PCERT Payroll Posting Runs
MOLGA
0 T5KR0
RUNID
PCERT Payroll Posting Runs
APPL
0 T5KR0
RUNID
PCERT Payroll Posting Runs
RUNID