TNROI
Definition der Nummernkreisobjekte - Inaktiv
TNROI is an SAP database table in S/4HANA. Definition der Nummernkreisobjekte - Inaktiv. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| NR_LANG_VRS_OBJ_EDIT_NROB | view_entity | union | Language Version of Active and Inactive Number Range Objects |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | object | nrobji | 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 | as4flag | Flag (X or Blank) |
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 der Nummernkreisobjekte - Inaktiv
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TNROI (
OBJECT, -- Object Name [nrobji]
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, -- Flag (X or Blank) [as4flag]
PRIMARY KEY (OBJECT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA