T7PIQYEART

Transparent Table Customizing Table
4 Fields 1 CDS Views

Text Table for Academic Years

T7PIQYEART is an SAP database table in S/4HANA. Text Table for Academic Years. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
PiqCdsAcademicYearText view from Text for Academic Years

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY peryr PIQPERYR Acad. Year
peryt PIQPERYT Acad. Year

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.

-- Text Table for Academic Years
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T7PIQYEART (
    MANDT,  -- Client [MANDT]
    SPRAS,  -- Language [SPRAS]
    PERYR,  -- Acad. Year [PIQPERYR]
    PERYT,  -- Acad. Year [PIQPERYT]
    PRIMARY KEY (MANDT, SPRAS, PERYR)
);

Learn More