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