/ISDFPS/NRIV

Transparent Table Application Table
21 Fields 2 CDS Views

Central Table for Cross-System Number Ranges

/ISDFPS/NRIV is an SAP database table in S/4HANA. Central Table for Cross-System Number Ranges. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DFS_NmbrRngeNmbrVH view_entity from COMPOSITE Number range number for global intervals
I_DFS_NmbrRngeSubObjVH view_entity from COMPOSITE Subobjects for global NR range intervals

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY logsys /ISDFPS/LOGSYS Logical System
KEY object /ISDFPS/NR_OBJ NR Object Name
KEY subobject /ISDFPS/NR_SOBJ NR Subobj.
KEY nrrangenr /ISDFPS/NR_NR No. Range No.
KEY toyear /ISDFPS/NR_YEAR To Year
externind /ISDFPS/NR_EXT_IND External NR
global_key /ISDFPS/NR_GLOBAL_KEY Globality Ref.
fromnumber /ISDFPS/NR_FROM_NR From No.
tonumber /ISDFPS/NR_TO_NR To No.
from_nr_reserved /ISDFPS/NR_FROM_NR_RESERVED Reserved from No.
to_nr_reserved /ISDFPS/NR_TO_NR_RESERVED Reserved to No.
nrlevel /ISDFPS/NR_LEVEL No. Level
procind /ISDFPS/PROCIND Procg Flag
reserving_user /ISDFPS/RESERVING_USER Author of Reserv.
reserving_tz /ISDFPS/TIMEZONE Time Zone
reserving_date /ISDFPS/RESERVING_DATE Date of Reservation
reserving_time /ISDFPS/RESERVING_TIME Time of Reservation
trans_tz /ISDFPS/TIMEZONE Time Zone
trans_date /ISDFPS/TRANSMISSIONDATE Adjusted on
trans_time /ISDFPS/TRANSMISSIONTIME Adjusted at

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.

-- Central Table for Cross-System Number Ranges
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ISDFPS/NRIV (
    CLIENT,            -- Client [MANDT]
    LOGSYS,            -- Logical System [/ISDFPS/LOGSYS]
    OBJECT,            -- NR Object Name [/ISDFPS/NR_OBJ]
    SUBOBJECT,         -- NR Subobj. [/ISDFPS/NR_SOBJ]
    NRRANGENR,         -- No. Range No. [/ISDFPS/NR_NR]
    TOYEAR,            -- To Year [/ISDFPS/NR_YEAR]
    EXTERNIND,         -- External NR [/ISDFPS/NR_EXT_IND]
    GLOBAL_KEY,        -- Globality Ref. [/ISDFPS/NR_GLOBAL_KEY]
    FROMNUMBER,        -- From No. [/ISDFPS/NR_FROM_NR]
    TONUMBER,          -- To No. [/ISDFPS/NR_TO_NR]
    FROM_NR_RESERVED,  -- Reserved from No. [/ISDFPS/NR_FROM_NR_RESERVED]
    TO_NR_RESERVED,    -- Reserved to No. [/ISDFPS/NR_TO_NR_RESERVED]
    NRLEVEL,           -- No. Level [/ISDFPS/NR_LEVEL]
    PROCIND,           -- Procg Flag [/ISDFPS/PROCIND]
    RESERVING_USER,    -- Author of Reserv. [/ISDFPS/RESERVING_USER]
    RESERVING_TZ,      -- Time Zone [/ISDFPS/TIMEZONE]
    RESERVING_DATE,    -- Date of Reservation [/ISDFPS/RESERVING_DATE]
    RESERVING_TIME,    -- Time of Reservation [/ISDFPS/RESERVING_TIME]
    TRANS_TZ,          -- Time Zone [/ISDFPS/TIMEZONE]
    TRANS_DATE,        -- Adjusted on [/ISDFPS/TRANSMISSIONDATE]
    TRANS_TIME,        -- Adjusted at [/ISDFPS/TRANSMISSIONTIME]
    PRIMARY KEY (CLIENT, LOGSYS, OBJECT, SUBOBJECT, NRRANGENR, TOYEAR)
);

Learn More