RSQISET

Transparent Table Control Table (SAP+Cust)
35 Fields 2 CDS Views

Directory of all InfoSets

RSQISET is an SAP database table in S/4HANA. Directory of all InfoSets. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
RSODP_BW_Extraction view union ODP BW Extraction
Rv_P_Iset_ view from

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY infoset RSQINFOSET InfoSet
KEY objvers RSOBJVERS Version
objstat RSOBJSTAT Object Status
contrel RSCONTREL Content release
conttimestmp RSCONTTIMESTMP Cont.time stamp
owner RSOWNER Person Respons.
bwappl RSBWAPPL BW Application
activfl RSACTIVFL active
infoarea RSINFOAREA InfoArea
bctcomp RSQBCTCOMP Component
tstpnm RSTSTPNM Last Changed By
timestmp RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
crnm RSQCRNM Author
crtstp RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
bwstatistics RS_BOOL Boolean
bwstatwhm RS_BOOL Boolean
qpropvers RSQPROPVERS Version QP
readmode RSRREADMODE Query Read Mode
cachemode RSRCACHEMODE Query Cache Mode
cachedelay RSRCACHEDELAY Cache Validity (S)
nlreadmode RSD_NLREADMODE N-Line Storage Mode
noparallelqdef RRSNOPARALLEL No Parallel Process.
kidsel RRKIDSEL Selection of Struct.
cacheuserexit RSRNOCACHEFL Do Not Use Cache
nohpa RRSNOHPA Do Not Use BWA
trexops RSRTREXOPS SAP HANA/BWA Ops
materializequerylayer RSRMATERIALIZEQUERYLAYER Materialize Result
packflqdef RSDHIGHPRECFL Key F. w/ High Prec.
hanamodelfl RSMHANAMODEL SAP HANA View
supp_query_w_dupl_kyf SUPPORTS_KEYFIGURE_DUPLICATES Supp. queries w/ dupl. KYF which cont. diff. aggregations
cacheusagemode RSRCACHEUSAGEMODE Cache Usage Mode
data_integrity_scenario RSR_DATA_INTEGRITY_SCENARIO Data Integrity Prof.
read_child_kids RR_READ_CHILD_KIDS Read Child Members
autorefresh RSRAUTOREFRESH Automatic Refresh
force_db_pushdown RSR_FORCE_DB_PUSHDOWN Force Access via CS

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.

-- Directory of all InfoSets
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSQISET (
    INFOSET,                  -- InfoSet [RSQINFOSET]
    OBJVERS,                  -- Version [RSOBJVERS]
    OBJSTAT,                  -- Object Status [RSOBJSTAT]
    CONTREL,                  -- Content release [RSCONTREL]
    CONTTIMESTMP,             -- Cont.time stamp [RSCONTTIMESTMP]
    OWNER,                    -- Person Respons. [RSOWNER]
    BWAPPL,                   -- BW Application [RSBWAPPL]
    ACTIVFL,                  -- active [RSACTIVFL]
    INFOAREA,                 -- InfoArea [RSINFOAREA]
    BCTCOMP,                  -- Component [RSQBCTCOMP]
    TSTPNM,                   -- Last Changed By [RSTSTPNM]
    TIMESTMP,                 -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    CRNM,                     -- Author [RSQCRNM]
    CRTSTP,                   -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    BWSTATISTICS,             -- Boolean [RS_BOOL]
    BWSTATWHM,                -- Boolean [RS_BOOL]
    QPROPVERS,                -- Version QP [RSQPROPVERS]
    READMODE,                 -- Query Read Mode [RSRREADMODE]
    CACHEMODE,                -- Query Cache Mode [RSRCACHEMODE]
    CACHEDELAY,               -- Cache Validity (S) [RSRCACHEDELAY]
    NLREADMODE,               -- N-Line Storage Mode [RSD_NLREADMODE]
    NOPARALLELQDEF,           -- No Parallel Process. [RRSNOPARALLEL]
    KIDSEL,                   -- Selection of Struct. [RRKIDSEL]
    CACHEUSEREXIT,            -- Do Not Use Cache [RSRNOCACHEFL]
    NOHPA,                    -- Do Not Use BWA [RRSNOHPA]
    TREXOPS,                  -- SAP HANA/BWA Ops [RSRTREXOPS]
    MATERIALIZEQUERYLAYER,    -- Materialize Result [RSRMATERIALIZEQUERYLAYER]
    PACKFLQDEF,               -- Key F. w/ High Prec. [RSDHIGHPRECFL]
    HANAMODELFL,              -- SAP HANA View [RSMHANAMODEL]
    SUPP_QUERY_W_DUPL_KYF,    -- Supp. queries w/ dupl. KYF which cont. diff. aggregations [SUPPORTS_KEYFIGURE_DUPLICATES]
    CACHEUSAGEMODE,           -- Cache Usage Mode [RSRCACHEUSAGEMODE]
    DATA_INTEGRITY_SCENARIO,  -- Data Integrity Prof. [RSR_DATA_INTEGRITY_SCENARIO]
    READ_CHILD_KIDS,          -- Read Child Members [RR_READ_CHILD_KIDS]
    AUTOREFRESH,              -- Automatic Refresh [RSRAUTOREFRESH]
    FORCE_DB_PUSHDOWN,        -- Force Access via CS [RSR_FORCE_DB_PUSHDOWN]
    PRIMARY KEY (INFOSET, OBJVERS)
);

Learn More