TCY31FT

Transparent Table Control Table (SAP+Cust)
6 Fields 1 CDS Views

Text table for sorts per layout and chart

TCY31FT is an SAP database table in S/4HANA. Text table for sorts per layout and chart. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
TCY31FT_M view from Verticalization of TCY31FT

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY spras spras Language
KEY layout cy_layout Layout ID
KEY chartnr cy_chartn Chart nr.
KEY sorting cy_sorting Sort
sorttext cy_sorttxt Sort

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 sorts per layout and chart
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCY31FT (
    MANDT,     -- Client [mandt]
    SPRAS,     -- Language [spras]
    LAYOUT,    -- Layout ID [cy_layout]
    CHARTNR,   -- Chart nr. [cy_chartn]
    SORTING,   -- Sort [cy_sorting]
    SORTTEXT,  -- Sort [cy_sorttxt]
    PRIMARY KEY (MANDT, SPRAS, LAYOUT, CHARTNR, SORTING)
);

Learn More