NRIV

Transparent Table Customizing Table
9 Fields 10 CDS Views

Number Range Intervals

NRIV is an SAP database table in S/4HANA. Number Range Intervals. It contains 9 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
Fisvd_Docnr_Gap_Rangeblock view from Range Block
Fisvd_Docnr_Gap_Rangefrom view from Range From
Fisvd_Docnr_Gap_Rangeto view inner Range To
Fisvd_Docnr_Gap_Startnum view from Start and end number of number range
I_AR_ODNRngeIntvl view from BASIC Number Range Interval for Official Document Numbering
I_ChgRecdTypeConfiguration view inner BASIC Change Record Type Configuration
I_NumberRangeInterval view from BASIC Intervalle von Nummernkreisen
I_NUMBERRANGEINTERVALRATIO view from BASIC Intervalle von Nummernkreisen
MDCV_E_NRIV view from Number range objects for T399D
P_SDM_Number_range_VEKP view from BASIC

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY object NROBJ Object name
KEY subobject NRSOBJ Subobject value
KEY nrrangenr NRNR No. Range No.
KEY toyear NRYEAR To year
fromnumber NRFROM From number
tonumber NRTO To number
nrlevel NRLEVEL Number Status
externind NRIND External

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.

-- Number Range Intervals
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NRIV (
    CLIENT,      -- Client [MANDT]
    OBJECT,      -- Object name [NROBJ]
    SUBOBJECT,   -- Subobject value [NRSOBJ]
    NRRANGENR,   -- No. Range No. [NRNR]
    TOYEAR,      -- To year [NRYEAR]
    FROMNUMBER,  -- From number [NRFROM]
    TONUMBER,    -- To number [NRTO]
    NRLEVEL,     -- Number Status [NRLEVEL]
    EXTERNIND,   -- External [NRIND]
    PRIMARY KEY (CLIENT, OBJECT, SUBOBJECT, NRRANGENR, TOYEAR)
);

Learn More