P2RX_EVAL_PERIOD

Transparent Table Application Table
18 Fields 2 CDS Views

Index for Payroll Results Periods

P2RX_EVAL_PERIOD is an SAP database table in S/4HANA. Index for Payroll Results Periods. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
HRPY_PCC_EVP view from PCC Evaluation Period for Prod. Payroll
HRPY_PCC_TPY_EVP view union PCC Evaluation Period for Test Payroll

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dct_pernr P_PERNR Personnel No.
KEY dct_seqnr CDSEQ Sequence Number
KEY iabkrs ABKRS Payroll area
KEY inper IPERI In-Period
KEY ipend IPEND In-Period End Date
KEY inpty PAYTY Payroll type
KEY inpid PAYID Payroll Identifier
KEY srtza SRTZA Indicator: Result
abkrs ABKRS Payroll area
fpper FPPER For-period for garnishment
fpend FPEND For-Period EndD.
payty PAYTY Payroll type
payid PAYID Payroll Identifier
calcd CALCD accounted
period_key HRDCT_PERIOD_KEY Period Key
fpbeg FPBEG For-Period Strt D
void VOID Reversed

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.

-- Index for Payroll Results Periods
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P2RX_EVAL_PERIOD (
    MANDT,       -- Client [MANDT]
    DCT_PERNR,   -- Personnel No. [P_PERNR]
    DCT_SEQNR,   -- Sequence Number [CDSEQ]
    IABKRS,      -- Payroll area [ABKRS]
    INPER,       -- In-Period [IPERI]
    IPEND,       -- In-Period End Date [IPEND]
    INPTY,       -- Payroll type [PAYTY]
    INPID,       -- Payroll Identifier [PAYID]
    SRTZA,       -- Indicator: Result [SRTZA]
    ABKRS,       -- Payroll area [ABKRS]
    FPPER,       -- For-period for garnishment [FPPER]
    FPEND,       -- For-Period EndD. [FPEND]
    PAYTY,       -- Payroll type [PAYTY]
    PAYID,       -- Payroll Identifier [PAYID]
    CALCD,       -- accounted [CALCD]
    PERIOD_KEY,  -- Period Key [HRDCT_PERIOD_KEY]
    FPBEG,       -- For-Period Strt D [FPBEG]
    VOID,        -- Reversed [VOID]
    PRIMARY KEY (MANDT, DCT_PERNR, DCT_SEQNR, IABKRS, INPER, IPEND, INPTY, INPID, SRTZA)
);

Learn More