standard variant of SAP query is loaded automatically

[former_member699400]

Hi!

I have created SAP query and standard variant via SQ01.

When I run my query (via transaction) values of variant are loaded automatically in a selection screen and in my case I need empty selection screen at the beginning and values should appear in a selection screen only after choosing a variant, but not before this.

Probably it is something about attributes of variant? Any ideas?

<b><REMOVED BY MODERATOR></b>

Mindaugas.

Message was edited by:

Alvaro Tejada Galindo

[Former Member]

in SQ01 while you go with test the query...or just execut the query with out variant it will ask for the variant don't give the variant name there ... it will execute the query with blank values

[former_member699400]

yes, but let's say I am executing my query not in SQ01 but via custom tcode and I'm not asked for variant, it still fills selection screen....

Mindaugas

[ferry_lianto]

Hi,

Did you create custom transaction (report transaction) in SE93 with specifying start with variant option?

Regards,

Ferry Lianto

[former_member699400]

I have created report transaction in SE93 that calls a report ZSAP_QUERY_CALL_Q1 and this report calls my query.

By the way, report ZSAP_QUERY_CALL_Q1 is modifyed copy of SAP_QUERY_CALL.

Mindaugas

[former_member699400]

here is main part of this program:

<i>DATA:

p_ugroup type bgname VALUE 'PC', " query group

p_query type quname VALUE 'Q1', " query name

p_vari type vari VALUE ''. " variant</i>

so I do not pass variant here...

Mindaugas

[Former Member]

Just like for any normal ABAP report, you will find this info in the TRDIR table. The field SSET will be 'X' if the Query needs to be started with a Variant, where NAME = "Query name.

may be helpful for you..........

[former_member699400]

strange, but SSET is empty....

I guess in this case probably query has some settings that it is to be started with variant.

Mindaugas

[Former Member]

check this link may be further helpful for you....

[Former Member]

Check the below links :

http://www.sapfans.com/forums/viewtopic.php?t=56428&highlight=sq01variantautomatically

http://www.sapfans.com/forums/viewtopic.php?t=248188&highlight=sq01variantautomatically

Thanks

Seshu

[ferry_lianto]

Hi,

What type of custom transaction code did you create?

Was Dialog Transaction or Report Transaction?

For your purpose, you can create with dialog transaction with specifying program name and screen number. If you want to execute with specific variant then choose report transaction.

Regards,

Ferry Lianto