TNRO

Transparent Table System Table (transport)
34 Fields 4 CDS Views

Definition of number range objects

TNRO is an SAP database table in S/4HANA. Definition of number range objects. It contains 34 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_NameNumberRangeObject view_entity from BASIC View für Nummerkreisobjekt
I_NumberRangeObject view from BASIC Nummernkreisobjekte
NR_LANG_VRS_OBJ_ACTIVE_NROB view_entity from
NR_LANG_VRS_OBJ_EDIT_NROB view_entity from

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY object NROBJ Object name
dtelsobj NRSOBJNAM Subobj. data element
nrtab NRTAB Group table
nrintfld NRINTNR Int./Ext.no.range no
nrextfld NRINTNR Int./Ext.no.range no
nrfld NRNRNAME NRangeNo
nrsobjfld NRNRSUBOBJ SObj.field
nrelefld NRNRELEM NoRangeElement
yearind NRYEARIND To-year flag
domlen NRLENDOM Length Domain
percentage NRPERC Warning %
code NRCODE No.r.transation
textind NRTEXTIND Display text
nreltxttab NRELTXTTAB Element text table
nreltxtsob NRELTXTOBJ Subobject field
nreltxtele NRELTXTELE Element field
nreltxttxt NRELTXTTXT Text field
nreltxtlng NRELTXTLNG Lang.Field
buffer NRBUFFER Buffering
noivbuffer NRIVBUFFER No. of numbers
nonrswap NRSWAP No rolling
rfcdest RFCDEST Destination
nrcheckascii NRCHECKASCII Prefix
abap_language_version ABAP_LANGUAGE_VERSION Language Version
status R3STATE Program Status
changed_at TIMESTAMPL Time Stamp
changed_by SYUNAME User Name
uname AS4USER Last Changed By
udate AS4DATE Date
utime AS4TIME Time
ename AUTHOR Author
edate AS4DATE Date
etime AS4TIME Time
ignore_group NRIGNORE Ignore groups

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.

-- Definition of number range objects
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TNRO (
    OBJECT,                 -- Object name [NROBJ]
    DTELSOBJ,               -- Subobj. data element [NRSOBJNAM]
    NRTAB,                  -- Group table [NRTAB]
    NRINTFLD,               -- Int./Ext.no.range no [NRINTNR]
    NREXTFLD,               -- Int./Ext.no.range no [NRINTNR]
    NRFLD,                  -- NRangeNo [NRNRNAME]
    NRSOBJFLD,              -- SObj.field [NRNRSUBOBJ]
    NRELEFLD,               -- NoRangeElement [NRNRELEM]
    YEARIND,                -- To-year flag [NRYEARIND]
    DOMLEN,                 -- Length Domain [NRLENDOM]
    PERCENTAGE,             -- Warning % [NRPERC]
    CODE,                   -- No.r.transation [NRCODE]
    TEXTIND,                -- Display text [NRTEXTIND]
    NRELTXTTAB,             -- Element text table [NRELTXTTAB]
    NRELTXTSOB,             -- Subobject field [NRELTXTOBJ]
    NRELTXTELE,             -- Element field [NRELTXTELE]
    NRELTXTTXT,             -- Text field [NRELTXTTXT]
    NRELTXTLNG,             -- Lang.Field [NRELTXTLNG]
    BUFFER,                 -- Buffering [NRBUFFER]
    NOIVBUFFER,             -- No. of numbers [NRIVBUFFER]
    NONRSWAP,               -- No rolling [NRSWAP]
    RFCDEST,                -- Destination [RFCDEST]
    NRCHECKASCII,           -- Prefix [NRCHECKASCII]
    ABAP_LANGUAGE_VERSION,  -- Language Version [ABAP_LANGUAGE_VERSION]
    STATUS,                 -- Program Status [R3STATE]
    CHANGED_AT,             -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,             -- User Name [SYUNAME]
    UNAME,                  -- Last Changed By [AS4USER]
    UDATE,                  -- Date [AS4DATE]
    UTIME,                  -- Time [AS4TIME]
    ENAME,                  -- Author [AUTHOR]
    EDATE,                  -- Date [AS4DATE]
    ETIME,                  -- Time [AS4TIME]
    IGNORE_GROUP,           -- Ignore groups [NRIGNORE]
    PRIMARY KEY (OBJECT)
);

Learn More