cancel
Showing results for 
Search instead for 
Did you mean: 

any T-code to check the available Queries on data targets

Former Member
0 Kudos

hi

Can any body tell me any t-code to check the available Queries on Data Targets

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Goto Rsa1 -> Transport connection -> Drag data target to right side -> Grouping option "in data flow after " and it should display all query defined on the info provider.

Still meta data repository will be short cut to find out list of queries.

Hope that helps.

Regards

Mr Kapadia

Assigning points is the way to say thanks in SDN.

Former Member
0 Kudos

HI all

is there is any Program where we can find such information

Former Member
0 Kudos

Hi,

Create View based on table

RSZCOMPIC
RSZELTTXT

Select following fields 
INFOCUBE	RSZCOMPIC	INFOCUBE
ELTUID	RSZELTTXT	ELTUID
OBJVERS	RSZELTTXT	OBJVERS
LANGU	RSZELTTXT	LANGU
TXTSH	RSZELTTXT	TXTSH
TXTLG	RSZELTTXT	TXTLG

and following selection condition
RSZCOMPIC	OBJVERS	EQ	'A'	AND
RSZELTTXT	LANGU	EQ	'E'

And it should serve your requirement.

Hope that helps.

Regards

Mr Kapadia

Assigning points is the way to say thanks in SDN.

Former Member
0 Kudos

HI,

Really thank u guys for giving such a good information.....

Regards,

sri

Former Member
0 Kudos

Priya,

Try Tcode : QF4

Program :QUERY_F4_GET

-BWQ

Former Member
0 Kudos

hi All

Thanks for giving good suggestions

But I Got my own answer it is Run The program QUERY_F4_GET

Regards

PRIYA

Answers (3)

Answers (3)

Former Member
0 Kudos

hi , Where-used-list ia normally used to find out these things initially ..

Also u can use RSRT ....

let us know if any queries .....

Regards -


Kumar Sarvepalli ... //// Honor points if helpful.

Former Member
0 Kudos

Thanks for Your immediate responce

but I know these but There is one T-Code which displays the Querys available

I had heard it long back but I did not Remember it

Former Member
0 Kudos

Hi,

check the transaction QCHECK it gives you the queries and infoprovider option.

Just give the infoprovider name there and it will give you all the queries and the status of those queries....if there is any error in any queries.

Hope it helps

Thanks

Former Member
0 Kudos

HI priya,

you can directly click double click on ur data target(cube or ods or info object)

and right side window click on <b>where used list</b> icon and drill down it.. there you can find all the querys... which are made on that particular target..

Thanks

AJAY KUMAR . N

Former Member
0 Kudos

Hi,

RSRT and Meta data reporsitory.

With rgds,

Anil Kumar Sharma .P