tables with query definition

[#1]

Hello,

does anyone know in which tables the definition of a query is stored?

Thanks a lot in advance!

[Former Member · Accepted solution]

Hi dennis,

Go to se38 -> RSRQ_QUERYDEFINITION -> give the query tech name -> you will get complete details of the query

Hope this helps you

REgards

Sunil

[Former Member]

Below tables will give all required details.

Queries

RSZELTDIR

Directory of the reporting component elements

RSZELTTXT Texts of reporting component elements

RSZELTXREF Directory of query element references

RSRREPDIR

Directory of all reports (Query GENUNIID)

RSZCOMPDIR Directory of reporting components

RSZRANGE Selection specification for an element

RSZSELECT

Selection properties of an element

RSZELTDIR

Directory of the reporting component elements

RSZCOMPIC

Assignment reuseable component <-> InfoCube

RSZELTPRIO Priorities with element collisions

RSZELTPROP Element properties (settings)

RSZELTATTR

Attribute selection per dimension element

RSZCALC Definition of a formula element

RSZCEL

Query Designer: Directory of Cells

RSZGLOBV

Global Variables in Reporting

and RSRTQ tcode will give you all details relates to individual query details.

[Former Member]

is there another table in which all characteristics and key figures of a single query is stored?

[Former Member]

try the tcode RSRTQ , will give characteristics and key figures of a single query used details

[Former Member]

but I need to change the definition of a query e.g. with the help a abap-program

[dennis_scoville4]

The table where all of the queries and query elements (e.g. CKF, RKF, etc) are stored is RSZELTDIR. The key to this table is the 25 character generated id for the query or elements, along with the version (A = Active, M = Modified, D = Delivered).

Here are the element type definitions:

REP = Query

SOB = Filter

VAR = Variable

STR = Structure

SEL = Restricted Key Figure

CFK = Calculated Key Figure

FML = Formula