P2RX_TPY_EVAL_P

Transparent Table Application Table
20 Fields 2 CDS Views

Test payroll run for eval period

P2RX_TPY_EVAL_P is an SAP database table in S/4HANA. Test payroll run for eval period. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
HRPY_PCC_TPY_EVP view from PCC Evaluation Period for Test Payroll
HRPY_PCC_TPY_EVP view left_outer PCC Evaluation Period for Test Payroll

Fields (20)

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

-- Test payroll run for eval period
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P2RX_TPY_EVAL_P (
    MANDT,       -- Client [MANDT]
    DCT_PERNR,   -- Personnel No. [P_PERNR]
    DCT_SEQNR,   -- Sequence Number [CDSEQ]
    DCT_TPY_ID,  -- Test Payroll ID [HRDCT_TPY_ID]
    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]
    DCT_IS_TPY,  -- Payroll Test Results [HRDCT_IS_TPY]
    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, DCT_TPY_ID, IABKRS, INPER, IPEND, INPTY, INPID, SRTZA)
);

Learn More