/ISDFPS/NRIV

Transparent Table Application Table
21 Fields 2 CDS Views

Zentrale Tabelle für systemübergreifende Nummernkreise

/ISDFPS/NRIV is an SAP database table in S/4HANA. Zentrale Tabelle für systemübergreifende Nummernkreise. 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.

-- Zentrale Tabelle für systemübergreifende Nummernkreise
-- 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