Program or table to get query elements

[Former Member]

Hi All,

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

Thanks,

Anshul

[Former Member · Accepted solution]

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]

Program name is RSRQ_QUERYDEFINITION.

[Former Member]

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

[ananya_bhattacharya]

Dear Anshul,

Please check -

http://wiki.sdn.sap.com/wiki/display/BI/Tables+in+SAP+BW+which+give+information+related+to+Queries,+...

Regards Ananya..