SAP table HRPY_RGDIR (Directory for Payroll Results)
SAP table HRPY_RGDIR has 3 primary key fields being MANDT,PERNR,SEQNR.
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
P_PERNR
Sequence Number
NUMC
5
0
CDSEQ
ABKRS
Payroll Area
CHAR
2
0
*
ABKRS
FPPER
For-Period for Payroll (YYYYMM)
CHAR
6
0
FAPER
FPBEG
Start date of payroll period (FOR period)
DATS
8
0
FPBEG
FPEND
End of payroll period (for-period)
DATS
8
0
FPEND
IABKRS
Payroll Area
CHAR
2
0
*
ABKRS
IPERM
Period Parameters
NUMC
2
0
*
PERMO
INPER
In-period for payroll
CHAR
6
0
IPERI
IPEND
End of payroll period (IN period)
DATS
8
0
IPEND
JUPER
Legal Person
CHAR
4
0
JUPER
SRTZA
Indicator: Status of record
CHAR
1
0
SRTZA
Possible values
A
current result
O
old result
P
previous result
PAYTY
Payroll type
CHAR
1
0
PAYTY
Possible values
Regular payroll run
A
Bonus payment
B
Correction accounting
C
Manual check
S
Additional payment
PAYID
Payroll Identifier
CHAR
1
0
PAYID
VOID
Reversal Indicator
CHAR
1
0
VOID
BONDT
Off-cycle payroll payment date
DATS
8
0
BONDT
RUNDT
Date of payroll run
DATS
8
0
RUNDT
RUNTM
Time of payroll run
TIMS
6
0
RUNTM
PERMO
Period Parameters
NUMC
2
0
T549R
PERMO
VOIDD
Void date for payroll results
DATS
8
0
VOID_DATE
VOIDT
Void time for payroll results
TIMS
6
0
VOID_TIME
VOIDR
Cancellation reason for payroll results
CHAR
2
0
VOID_CODE
PAYDT
Pay date for payroll result
DATS
8
0
PAY_DATE
INPTY
Payroll type
CHAR
1
0
PAYTY
Possible values
Regular payroll run
A
Bonus payment
B
Correction accounting
C
Manual check
S
Additional payment
INPID
Payroll Identifier
CHAR
1
0
PAYID
OCRSN
Reason for Off-Cycle Payroll
CHAR
4
0
*
PAY_OCRSN
INOCR
Reason for Off-Cycle Payroll
CHAR
4
0
*
PAY_OCRSN
OCCAT
Category for off-cycle reason
CHAR
2
0
*
PAY_OCCAT
INOCC
Category for off-cycle reason
CHAR
2
0
*
PAY_OCCAT
REVERSAL
Reversal Indicator
CHAR
1
0
VOID
OUTOFSEQ
Out-Of-Sequence-Check Indicator
CHAR
1
0
PAY_OUTOFSEQ
Possible values
Payroll is no out-of-sequence check
X
Payroll is out-of-sequence check
OOSDATE
Create Out-Of-Sequence Check (acc. to Payroll Control Rec.)
DATS
8
0
PAY_OOSDATE
ARC_GROUP
Archiving Group
NUMC
6
0
ARC_GROUP
CALCD
Payroll Already Run for Indicator Period
CHAR
1
0
CALCD
Possible values
Payroll not yet run for period acc. to PA03
X
Payroll already run for period acc. to PA03
MOLGA
HCM Localization
CHAR
2
0
*
MOLGA
PERSON
Technical Person Number
NUMC
8
0
PERSONID
PERSDATA
Personnel Number
NUMC
8
0
PERNR_D
BRACKET
Bracket for a Period and its Supplementals
NUMC
5
0
PAY_BRACKET
HRPY_RGDIR foreign key relationships
Table
Field
Check Table
Check Field
0 HRPY_RGDIR
PERMO
T549R Period Parameters
MANDT
0 HRPY_RGDIR
PERMO
T549R Period Parameters
PERMO