CNV_ANA2_TNRO

Transparent Table Temporary Data
20 Fields 2 CDS Views

Analysis: Result of number range object

CNV_ANA2_TNRO is an SAP database table in S/4HANA. Analysis: Result of number range object. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
V_LTR2_ANA2_NROBJ view_entity from Comprehensive NR Object View
V_LTR2_ANA2_NROBJ view_entity left_outer Comprehensive NR Object View

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY run_guid CNV_ANA2_RUN_GUID Analysis Run GUID
KEY sys_type CNV_ANA2_SYS_TYPE System Type
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
code NRCODE No.r.transation
nonrswap NRSWAP No rolling
nrcheckascii NRCHECKASCII Prefix
devclass DEVCLASS Package
leng DDLENG No. of Characters
txt NROBJTXT Long text
txtshort NROBJSTXT Short Text

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.

-- Analysis: Result of number range object
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNV_ANA2_TNRO (
    MANDT,         -- Client [MANDT]
    RUN_GUID,      -- Analysis Run GUID [CNV_ANA2_RUN_GUID]
    SYS_TYPE,      -- System Type [CNV_ANA2_SYS_TYPE]
    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]
    CODE,          -- No.r.transation [NRCODE]
    NONRSWAP,      -- No rolling [NRSWAP]
    NRCHECKASCII,  -- Prefix [NRCHECKASCII]
    DEVCLASS,      -- Package [DEVCLASS]
    LENG,          -- No. of Characters [DDLENG]
    TXT,           -- Long text [NROBJTXT]
    TXTSHORT,      -- Short Text [NROBJSTXT]
    PRIMARY KEY (MANDT, RUN_GUID, SYS_TYPE, OBJECT)
);

Learn More