TTSTRT

Transparent Table Customizing Table
14 Fields 2 CDS Views

Texts for time stream administration table

TTSTRT is an SAP database table in S/4HANA. Texts for time stream administration table. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PlanningCalendarText view from BASIC Planning Calendar text view
I_SchedulingWorkingTimeText view from BASIC Scheduling Working Time - Text

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY langkey LANGU Language
KEY tstrtype TSTRTYPE TimeStreamType
KEY tstreamid TSTRID Time stream ID
KEY calendarid TSTRCALID Calendar
text10 TSTRTEXT10 Short text
text40 TSTRTEXT40 Long text
textobject TDOBJECT Text object
textid TDID Text ID
textobname TDOBNAME Text Name
created TSTRCREATS Created At
createdby TSTRCREATN Created by
changed TSTRCHANGS Changed at
changedby TSTRCHANGN Changed by

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.

-- Texts for time stream administration table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TTSTRT (
    MANDT,       -- Client [MANDT]
    LANGKEY,     -- Language [LANGU]
    TSTRTYPE,    -- TimeStreamType [TSTRTYPE]
    TSTREAMID,   -- Time stream ID [TSTRID]
    CALENDARID,  -- Calendar [TSTRCALID]
    TEXT10,      -- Short text [TSTRTEXT10]
    TEXT40,      -- Long text [TSTRTEXT40]
    TEXTOBJECT,  -- Text object [TDOBJECT]
    TEXTID,      -- Text ID [TDID]
    TEXTOBNAME,  -- Text Name [TDOBNAME]
    CREATED,     -- Created At [TSTRCREATS]
    CREATEDBY,   -- Created by [TSTRCREATN]
    CHANGED,     -- Changed at [TSTRCHANGS]
    CHANGEDBY,   -- Changed by [TSTRCHANGN]
    PRIMARY KEY (MANDT, LANGKEY, TSTRTYPE, TSTREAMID, CALENDARID)
);

Learn More