SAP table T5J69 (HR Attributes to SYOYO payroll run JP)

SAP table T5J69 has 5 primary key fields being MANDT,ABKRS,PAYTY,PAYID,BONDT.

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
MANDT Client CLNT 3 0 T000 MANDT
ABKRS Payroll Area CHAR 2 0 T549A ABKRS
PAYTY Payroll type CHAR 1 0 PAYTY
Regular payroll run
A Bonus payment
B Correction accounting
C Manual check
S Additional payment
PAYID Payroll Identifier CHAR 1 0 PAYID
BONDT Off-cycle payroll payment date DATS 8 0 BONDT
SYMON Number of months associated to SHOYO payment NUMC 2 0 P22J_SYMON
BEGDA Start of SHOYO time period DATS 8 0 P22J_SYBEG
ENDDA End of SHOYO time period DATS 8 0 P22J_SYEND
WTYEA Flag: run Year End Adjustment with SHOYO payment in December CHAR 1 0 P22J_WTYEA
OCCAT Category for off-cycle reason CHAR 2 0 T52OCC PAY_OCCAT
OCRSN Reason for Off-Cycle Payroll CHAR 4 0 T52OCR PAY_OCRSN
DETDA Shoyo Determination Date DATS 8 0 P22J_SYDTD

T5J69 foreign key relationships

Table Field Check Table Check Field
0 T5J69 ABKRS T549A Payroll areas MANDT
0 T5J69 ABKRS T549A Payroll areas ABKRS
1 T5J69 OCCAT T52OCC Categories for Off-Cycle Reasons MOLGA
1 T5J69 OCCAT T52OCC Categories for Off-Cycle Reasons OCCAT
0 T5J69 OCRSN T52OCR Reasons for Off-Cycle Payroll Runs MOLGA
0 T5J69 OCRSN T52OCR Reasons for Off-Cycle Payroll Runs OCRSN