RSRREPDIR

Transparent Table Control Table (SAP+Cust)
71 Fields 3 CDS Views

Directory of all reports

RSRREPDIR is an SAP database table in S/4HANA. Directory of all reports. It contains 71 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
BW4_TLOGO_LNG_LIST view from List of Lineage enabled TLOGO objects
Rsrts_Cds_Repdir view from
RSRTS_QF4_QueryProvider view_entity left_outer List of all released queries

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY compuid SYSUUID_25 ID
KEY objvers RSOBJVERS Version
KEY infocube RSINFOCUBE InfoCube
genuniid RSGENUNIID Query
comptype RSZCOMPTP Type of a reporting component
compid RSZCOMPID Query
rfcsupport RRTRFCSUPPORT Report suuports access using OLAP API
objstat RSOBJSTAT Object Status
smode RSSMODE SpecialReports
readmode RSRREADMODE Query Read Mode
noaggrfl RSRNOAGGRFL Flag: Do not use aggregates for this query
idvers RSIDVERS IntDict. vers.
dvers RSDVERS Dictionary vrsn
rname PROGRAMM Program Name
author XUAUTHOR Author
gentime RSRGENTIME Query Generation Time (Cache Invalidation)
lastuser RSTSTPNM Last Changed By
modtime RSRMODTIME Last Change to Definition
reptime RSRREPTIME Last Change of Query Runtime Object
gen1time RSRGEN1TIME Query Gen Time (tech. reasons, no cache invalidation needed)
packfl RSDHIGHPRECFL Key F. w/ High Prec.
packfl_def RS_BOOL Boolean
nospbuf RRNOSPBUF SP Cannot be Permanently Buffered
cachemode RSRCACHEMODE Query Cache Mode
cacheusagemode RSRCACHEUSAGEMODE Cache Usage Mode
kidsel RRKIDSEL Selection of Struct.
faggr_late RRKFAGGRLATE Commut. For. A. Ag.
opt_occurs RS_BOOL Boolean
opt_occurs_time RSTIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
opt_occurs_mode RSROPTMODE Optimization Mode
opt_occurs_per RSROPTPER Optimization Periods
supprmess RSRSUPPRMESS Suppress Messages
cacheuserexit RSCACHEUSEREXITFL Cache Use Desp. Char
noparallel RRSNOPARALLEL No Parallel Process.
genprot RSRGENPROT Generate Protocol
inputable RRINPUTBASIC Make All Basic Indicators Ready for Input
partitionmode RRSPPARTITION SP Grouping
deltacache RRDELTACACHE Update Cache Objects
actualdata RRACTUALDATA Data Integrity
olapstat RSDDOLAPSTAT Query Statistic
olapstatdetlev RSDDOLAPSTATDETLEV Statistic Det.
addnls RRADDNLS NLS Usage
nohpa RRSNOHPA Do Not Use BWA
readmode_deft RS_BOOL Boolean
actualdata_def RS_BOOL Boolean
cachemode_def RS_BOOL Boolean
deltacache_def RS_BOOL Boolean
partition_def RS_BOOL Boolean
dis_mode RSZDIS Disaggregation on Totals
infoprov_support RSIPROVSUPPORT Query InfoProvider
noparallel_def RS_BOOL Boolean
kidsel_def RS_BOOL Boolean
addnls_def RS_BOOL Boolean
nohpa_def RS_BOOL Boolean
chuserexit_def RS_BOOL Boolean
trexops RSRTREXOPS SAP HANA/BWA Ops
trexops_def RS_BOOL Boolean
materializequerylayer RSRMATERIALIZEQUERYLAYER Materialize Result
materializequerylayer_def RS_BOOL Boolean
force_db_pushdown RSR_FORCE_DB_PUSHDOWN Force Access via CS
force_db_pushdown_def RS_BOOL Boolean
is_planquery RS_BOOL Boolean
data_integrity_scenario RSR_DATA_INTEGRITY_SCENARIO Data Integrity Prof.
di_scenario_def RS_BOOL Boolean
read_child_kids RR_READ_CHILD_KIDS Read Child Members
read_child_kids_def RS_BOOL Boolean
olapeffort RSR_OLAPEFFORT OLAP Effort
document_support RSR_DOCUMENT_SUPPORT Document Support
default_doc_appl_id RSR_DEFAULT_DOC_APPL_ID Dflt Document Store
qmodi RSR_QMODI Q Mode Implement.
zsmode RSR_ZSMODE ZS Mode Impl

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 reports
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RSRREPDIR (
    COMPUID,                    -- ID [SYSUUID_25]
    OBJVERS,                    -- Version [RSOBJVERS]
    INFOCUBE,                   -- InfoCube [RSINFOCUBE]
    GENUNIID,                   -- Query [RSGENUNIID]
    COMPTYPE,                   -- Type of a reporting component [RSZCOMPTP]
    COMPID,                     -- Query [RSZCOMPID]
    RFCSUPPORT,                 -- Report suuports access using OLAP API [RRTRFCSUPPORT]
    OBJSTAT,                    -- Object Status [RSOBJSTAT]
    SMODE,                      -- SpecialReports [RSSMODE]
    READMODE,                   -- Query Read Mode [RSRREADMODE]
    NOAGGRFL,                   -- Flag: Do not use aggregates for this query [RSRNOAGGRFL]
    IDVERS,                     -- IntDict. vers. [RSIDVERS]
    DVERS,                      -- Dictionary vrsn [RSDVERS]
    RNAME,                      -- Program Name [PROGRAMM]
    AUTHOR,                     -- Author [XUAUTHOR]
    GENTIME,                    -- Query Generation Time (Cache Invalidation) [RSRGENTIME]
    LASTUSER,                   -- Last Changed By [RSTSTPNM]
    MODTIME,                    -- Last Change to Definition [RSRMODTIME]
    REPTIME,                    -- Last Change of Query Runtime Object [RSRREPTIME]
    GEN1TIME,                   -- Query Gen Time (tech. reasons, no cache invalidation needed) [RSRGEN1TIME]
    PACKFL,                     -- Key F. w/ High Prec. [RSDHIGHPRECFL]
    PACKFL_DEF,                 -- Boolean [RS_BOOL]
    NOSPBUF,                    -- SP Cannot be Permanently Buffered [RRNOSPBUF]
    CACHEMODE,                  -- Query Cache Mode [RSRCACHEMODE]
    CACHEUSAGEMODE,             -- Cache Usage Mode [RSRCACHEUSAGEMODE]
    KIDSEL,                     -- Selection of Struct. [RRKIDSEL]
    FAGGR_LATE,                 -- Commut. For. A. Ag. [RRKFAGGRLATE]
    OPT_OCCURS,                 -- Boolean [RS_BOOL]
    OPT_OCCURS_TIME,            -- UTC Time Stamp in Short Form (YYYYMMDDhhmmss) [RSTIMESTMP]
    OPT_OCCURS_MODE,            -- Optimization Mode [RSROPTMODE]
    OPT_OCCURS_PER,             -- Optimization Periods [RSROPTPER]
    SUPPRMESS,                  -- Suppress Messages [RSRSUPPRMESS]
    CACHEUSEREXIT,              -- Cache Use Desp. Char [RSCACHEUSEREXITFL]
    NOPARALLEL,                 -- No Parallel Process. [RRSNOPARALLEL]
    GENPROT,                    -- Generate Protocol [RSRGENPROT]
    INPUTABLE,                  -- Make All Basic Indicators Ready for Input [RRINPUTBASIC]
    PARTITIONMODE,              -- SP Grouping [RRSPPARTITION]
    DELTACACHE,                 -- Update Cache Objects [RRDELTACACHE]
    ACTUALDATA,                 -- Data Integrity [RRACTUALDATA]
    OLAPSTAT,                   -- Query Statistic [RSDDOLAPSTAT]
    OLAPSTATDETLEV,             -- Statistic Det. [RSDDOLAPSTATDETLEV]
    ADDNLS,                     -- NLS Usage [RRADDNLS]
    NOHPA,                      -- Do Not Use BWA [RRSNOHPA]
    READMODE_DEFT,              -- Boolean [RS_BOOL]
    ACTUALDATA_DEF,             -- Boolean [RS_BOOL]
    CACHEMODE_DEF,              -- Boolean [RS_BOOL]
    DELTACACHE_DEF,             -- Boolean [RS_BOOL]
    PARTITION_DEF,              -- Boolean [RS_BOOL]
    DIS_MODE,                   -- Disaggregation on Totals [RSZDIS]
    INFOPROV_SUPPORT,           -- Query InfoProvider [RSIPROVSUPPORT]
    NOPARALLEL_DEF,             -- Boolean [RS_BOOL]
    KIDSEL_DEF,                 -- Boolean [RS_BOOL]
    ADDNLS_DEF,                 -- Boolean [RS_BOOL]
    NOHPA_DEF,                  -- Boolean [RS_BOOL]
    CHUSEREXIT_DEF,             -- Boolean [RS_BOOL]
    TREXOPS,                    -- SAP HANA/BWA Ops [RSRTREXOPS]
    TREXOPS_DEF,                -- Boolean [RS_BOOL]
    MATERIALIZEQUERYLAYER,      -- Materialize Result [RSRMATERIALIZEQUERYLAYER]
    MATERIALIZEQUERYLAYER_DEF,  -- Boolean [RS_BOOL]
    FORCE_DB_PUSHDOWN,          -- Force Access via CS [RSR_FORCE_DB_PUSHDOWN]
    FORCE_DB_PUSHDOWN_DEF,      -- Boolean [RS_BOOL]
    IS_PLANQUERY,               -- Boolean [RS_BOOL]
    DATA_INTEGRITY_SCENARIO,    -- Data Integrity Prof. [RSR_DATA_INTEGRITY_SCENARIO]
    DI_SCENARIO_DEF,            -- Boolean [RS_BOOL]
    READ_CHILD_KIDS,            -- Read Child Members [RR_READ_CHILD_KIDS]
    READ_CHILD_KIDS_DEF,        -- Boolean [RS_BOOL]
    OLAPEFFORT,                 -- OLAP Effort [RSR_OLAPEFFORT]
    DOCUMENT_SUPPORT,           -- Document Support [RSR_DOCUMENT_SUPPORT]
    DEFAULT_DOC_APPL_ID,        -- Dflt Document Store [RSR_DEFAULT_DOC_APPL_ID]
    QMODI,                      -- Q Mode Implement. [RSR_QMODI]
    ZSMODE,                     -- ZS Mode Impl [RSR_ZSMODE]
    PRIMARY KEY (COMPUID, OBJVERS, INFOCUBE)
);

Learn More