CNV_ANA2_NRIV

Transparent Table Temporary Data

Analysis: Result of number range intervals

CNV_ANA2_NRIV is an SAP database table in S/4HANA. Analysis: Result of number range intervals. It contains 11 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
V_LTR2_ANA2_INV view_entity from Comprehensive Intervals View
V_LTR2_ANA2_INV view_entity left_outer Comprehensive Intervals View
V_LTR2_ANA2_INV_GRP view_entity from Extract Distinct Interval in Sender
V_LTR2_RN_ANA_INV view_entity from Extract Intervals NOT in Renumbering

Fields (11)

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
KEY subobject NRSOBJ Subobject value
KEY toyear NRYEAR To year
KEY nrrangenr NRNR No. Range No.
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.

-- Analysis: Result of number range intervals
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNV_ANA2_NRIV (
    MANDT,       -- Client [MANDT]
    RUN_GUID,    -- Analysis Run GUID [CNV_ANA2_RUN_GUID]
    SYS_TYPE,    -- System Type [CNV_ANA2_SYS_TYPE]
    OBJECT,      -- Object name [NROBJ]
    SUBOBJECT,   -- Subobject value [NRSOBJ]
    TOYEAR,      -- To year [NRYEAR]
    NRRANGENR,   -- No. Range No. [NRNR]
    FROMNUMBER,  -- From number [NRFROM]
    TONUMBER,    -- To number [NRTO]
    NRLEVEL,     -- Number Status [NRLEVEL]
    EXTERNIND,   -- External [NRIND]
    PRIMARY KEY (MANDT, RUN_GUID, SYS_TYPE, OBJECT, SUBOBJECT, TOYEAR, NRRANGENR)
);