HRDCT_TPY_RGDIR

Transparent Table Application Table
41 Fields 1 CDS Views

Declustering - Directory for Test Payroll Results

HRDCT_TPY_RGDIR is an SAP database table in S/4HANA. Declustering - Directory for Test Payroll Results. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
hrpy_pcc_tpy_rgdir view from PCC Payroll DIrectory for Test Payroll Results

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dct_tpy_id HRDCT_TPY_ID Test Payroll ID
KEY dct_pernr P_PERNR Personnel No.
KEY dct_seqnr CDSEQ Sequence Number
dct_is_tpy HRDCT_IS_TPY Payroll Test Results
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.

-- Declustering - Directory for Test Payroll Results
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRDCT_TPY_RGDIR (
    MANDT,       -- Client [MANDT]
    DCT_TPY_ID,  -- Test Payroll ID [HRDCT_TPY_ID]
    DCT_PERNR,   -- Personnel No. [P_PERNR]
    DCT_SEQNR,   -- Sequence Number [CDSEQ]
    DCT_IS_TPY,  -- Payroll Test Results [HRDCT_IS_TPY]
    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, DCT_TPY_ID, DCT_PERNR, DCT_SEQNR)
);

Learn More