Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

 

The purpose of this document is list all relevant tables used by Queries, Query Views, Enterprise Reports, Templates 3.x /7.0, Workbooks and Broadcast Settings in order to help a better analysis of issues and its root-causes. 

1. Query:

Table Name

Shot DescriptionFieldsNote
RSRREPDIRDirectory of all reportsCOMPUID, OBJVERS, INFOCUBE, GENUNIID, COMPTYPE, COMPID, OBJSTAT, AUTHOR ...* Important query table.
COMPID = Query Technical nam
RSZCALCDefinition of a formula elementELTUID, OBJVERS, STEPNR ,OPERA, O1FLG, OPER1, O2FLG OPER2 ...Definition of all formulas.It is complicated to analyze using this table, since the formulas could be complex, but it is possible.
RSZCELQuery Designer: Directory of CellsELTUID, OBJVERS, MEMUID1, MEMUID2 and CELLTP 
RSZCHANGESChange history of reporting componentsCOMPUID, OBJVERS, MODCODE, TIMESTMPTime stamp of all BW reports and components. For queries, it is still relevant to check on RSZCOMPDIR
RSZCOMPDIRDirectory of reporting componentsCOMPUID, OBJVERS, COMPID, VERSION, COMPDIM, OBJSTAT, OWNER, TIMESTMP ...

* Important query table.
Last change on fields:TSTPDAT and TSTPTIM 
Last used:

LASTUSED

RSZCOMPICAssignment reuseable component      <-> InfoCubeCOMPUID, OBJVERS, INFOCUBE and IS_MASTER 
RSZELTATTRAttribute selection per dimension elementELTUID, OBJVERS, IOBJNM, ATTRINM, IOBJPRSNT, POSIT, HIDDEN, ATTRUID, MA_ACTIVE, MA_IOBJPRSNT, MA_POSIT 
RSZELTDIRDirectory of the reporting component elementsELTUID, OBJVERS, DEFTP, SUBDEFTP, REUSABLE, ISCELL, DEFAULTTEXT, MAPNAME, SOURCE_ELTUID, ... 
RSZELTPRIOPriorities with element collisionsCOMPUID, OBJVERS, ELTUID, NUM_SCALE_CNT, NUM_PREC_CNT, TCUR_CNT, CTTNM_CNT ...Table treat element collisions. For details, check our help documentation:
Session: Formula Collision

Selection/Formula Properties - Business Intelligence - SAP Library

RSZELTPROPElement properties (settings)ELTUID, OBJVERS, NOMULTTXT, SHOWFORMATS, SUMPOSIT, NOSTYLES... 
RSZELTTXTTexts of reporting component elementsELTUID, OBJVERS, LANGU, LINE_COUNT,TXTSH and TXTLGImportant table to check Short/Long texts (description) of Query elements.
Use in combination with table RSZELTXREF or RSZSELECT.

e.g.:

RSZELTXREF.TELTUID  = RSZELTTXT.ELTUID
RSZELTXREFDirectory of query element referenceSELTUID, OBJVERS, TELTUID, LAYTP, POSN, INFOCUBE, OPTIONAL and FLAT_POSN.Field LAYTP. Shows all query elements (like filter, sheet, row, column, variable..)
RSZGLOBVGlobal Variables in ReportingVARUNIID, OBJVERS, VNAM, COMPID, TIMESTMP, VARTYP, VPROCTP, IOBJNM, ..Can check the variables used by specific query.
RSZRANGESelection specification for an elementELTUID, OBJVERS, IOBJNM, ENUM, SOTP, FACIOBJNM, ATTRINM ... 
RSZSELECTSelection properties of an elementELTUID, OBJVERS, IOBJNM, CONIOBJNM, SOTP, SORT, SORT_SELSTATE... 
  • No labels