PYC_D_TL_RECT

Transparent Table Customizing Table
4 Fields 2 CDS Views

Payroll Activity List Recurrence Text

PYC_D_TL_RECT is an SAP database table in S/4HANA. Payroll Activity List Recurrence Text. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
hrpy_pcc_period view_entity left_outer Payroll Periods
HRPY_PCC_recurrence view left_outer Recurrence Data

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ref_id PYC_UUID PCC UUID
KEY sprsl SPRSL Language
name PYD_NAME_DB Name in DB

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.

-- Payroll Activity List Recurrence Text
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PYC_D_TL_RECT (
    MANDT,   -- Client [MANDT]
    REF_ID,  -- PCC UUID [PYC_UUID]
    SPRSL,   -- Language [SPRSL]
    NAME,    -- Name in DB [PYD_NAME_DB]
    PRIMARY KEY (MANDT, REF_ID, SPRSL)
);

Learn More