HRPY_RGDIR

Transparent Table Application Table
39 Fields 1 CDS Views

Directory for Payroll Results

HRPY_RGDIR is an SAP database table in S/4HANA. Directory for Payroll Results. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
hrpy_pcc_rgdir view from PCC Payroll Directory for Productive Payroll

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr P_PERNR Personnel No.
KEY seqnr CDSEQ Sequence Number
abkrs ABKRS Payroll area
fpper FAPER For-period
fpbeg FPBEG For-Period Strt D
fpend FPEND For-Period EndD.
iabkrs ABKRS Payroll area
iperm PERMO Period Param.
inper IPERI In-Period
ipend IPEND In-Period End Date
juper JUPER Legal person
srtza SRTZA Indicator: Result
payty PAYTY Payroll type
payid PAYID Payroll Identifier
void VOID Reversed
bondt BONDT Payment date
rundt RUNDT Date
runtm RUNTM Time of payroll
permo PERMO Period Param.
voidd VOID_DATE Void date
voidt VOID_TIME Void time
voidr VOID_CODE Cancel. reason
paydt PAY_DATE Payment date
inpty PAYTY Payroll type
inpid PAYID Payroll Identifier
ocrsn PAY_OCRSN Off-cycle reas.
inocr PAY_OCRSN Off-cycle reas.
occat PAY_OCCAT Off-cycle cat.
inocc PAY_OCCAT Off-cycle cat.
reversal VOID Reversed
outofseq PAY_OUTOFSEQ Out-of-seq.check
oosdate PAY_OOSDATE OOS date
arc_group ARC_GROUP Archiving Group
calcd CALCD accounted
molga MOLGA HCM Local.
person PERSONID Person Number
persdata PERNR_D Personnel No.
bracket PAY_BRACKET Bracket

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Directory for Payroll Results
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRPY_RGDIR (
    MANDT,      -- Client [MANDT]
    PERNR,      -- Personnel No. [P_PERNR]
    SEQNR,      -- Sequence Number [CDSEQ]
    ABKRS,      -- Payroll area [ABKRS]
    FPPER,      -- For-period [FAPER]
    FPBEG,      -- For-Period Strt D [FPBEG]
    FPEND,      -- For-Period EndD. [FPEND]
    IABKRS,     -- Payroll area [ABKRS]
    IPERM,      -- Period Param. [PERMO]
    INPER,      -- In-Period [IPERI]
    IPEND,      -- In-Period End Date [IPEND]
    JUPER,      -- Legal person [JUPER]
    SRTZA,      -- Indicator: Result [SRTZA]
    PAYTY,      -- Payroll type [PAYTY]
    PAYID,      -- Payroll Identifier [PAYID]
    VOID,       -- Reversed [VOID]
    BONDT,      -- Payment date [BONDT]
    RUNDT,      -- Date [RUNDT]
    RUNTM,      -- Time of payroll [RUNTM]
    PERMO,      -- Period Param. [PERMO]
    VOIDD,      -- Void date [VOID_DATE]
    VOIDT,      -- Void time [VOID_TIME]
    VOIDR,      -- Cancel. reason [VOID_CODE]
    PAYDT,      -- Payment date [PAY_DATE]
    INPTY,      -- Payroll type [PAYTY]
    INPID,      -- Payroll Identifier [PAYID]
    OCRSN,      -- Off-cycle reas. [PAY_OCRSN]
    INOCR,      -- Off-cycle reas. [PAY_OCRSN]
    OCCAT,      -- Off-cycle cat. [PAY_OCCAT]
    INOCC,      -- Off-cycle cat. [PAY_OCCAT]
    REVERSAL,   -- Reversed [VOID]
    OUTOFSEQ,   -- Out-of-seq.check [PAY_OUTOFSEQ]
    OOSDATE,    -- OOS date [PAY_OOSDATE]
    ARC_GROUP,  -- Archiving Group [ARC_GROUP]
    CALCD,      -- accounted [CALCD]
    MOLGA,      -- HCM Local. [MOLGA]
    PERSON,     -- Person Number [PERSONID]
    PERSDATA,   -- Personnel No. [PERNR_D]
    BRACKET,    -- Bracket [PAY_BRACKET]
    PRIMARY KEY (MANDT, PERNR, SEQNR)
);

Learn More