TNROT

Transparent Table System Table (transport)
10 Fields 2 CDS Views

Text for number range object

TNROT is an SAP database table in S/4HANA. Text for number range object. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_NumberRangeText view from Text für Nummernkreisobjekt
I_NumberRangeText2 view from Text für Nummernkreisobjekt

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY langu SPRAS Language
KEY object NROBJ Object name
txt NROBJTXT Long text
txtshort NROBJSTXT Short text
uname AS4USER Last Changed By
udate AS4DATE Date
utime AS4TIME Time
ename AUTHOR Author
edate AS4DATE Date
etime AS4TIME Time

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 for number range object
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TNROT (
    LANGU,     -- Language [SPRAS]
    OBJECT,    -- Object name [NROBJ]
    TXT,       -- Long text [NROBJTXT]
    TXTSHORT,  -- Short text [NROBJSTXT]
    UNAME,     -- Last Changed By [AS4USER]
    UDATE,     -- Date [AS4DATE]
    UTIME,     -- Time [AS4TIME]
    ENAME,     -- Author [AUTHOR]
    EDATE,     -- Date [AS4DATE]
    ETIME,     -- Time [AS4TIME]
    PRIMARY KEY (LANGU, OBJECT)
);

Learn More