Question Re: Program or table to get query elements in Technology Q&A

Program or table to get query elements

Former Member — Thu, 17 May 2012 04:57:16 GMT

Hi All,

Is there any program or table which gives query elements like RKF, CKF, Filters etc

Thanks,

Anshul

ananya_bhattacharya — Thu, 17 May 2012 05:02:27 GMT

Dear Anshul,

Please check -

Regards Ananya..

Former Member — Thu, 17 May 2012 05:36:36 GMT

Hi Anshul,

Below is the list of tables for query and its elements. Hope it will be useful.

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
RSZCHANGES	Change history of reporting components

Regards

Bhushan

Former Member — Thu, 17 May 2012 08:59:03 GMT

Hi,

You can use FM RSZ_X_COMPONENT_GET with following input parameters:

I_COMPID = Technical Name of the Query

I_TEMPLATE_TYPE = <Type>

I_LANGUAGE = EN

I_DESIGNTIME_CALL = R

I_OBJVERS = A

<type> meaning

SOB Filter

VAR Variable

SEL Restricted Key Figure

CKF Calculated key figure

FML Formula

After executing this FM with above selections you will get list of selected type in following output table: C_T_ELTDIR

Former Member — Thu, 17 May 2012 09:29:22 GMT

Program name is RSRQ_QUERYDEFINITION.