SQ01 Query & Default Values

[former_member405938]

Dear All,

I have created a query in SQ01, in order to get some values from J_1IEXCHDR & J_1IEXCDTL.

Now I wish to get values ( viz. Excise Invoice type, Excise Grp etc. ) defaulted in selection fields. For this I have also maintained one variant.

Now I want this variant to appear qutomatically whenever user runs this query.(User should not feel the need to select the variant)

How can I achieve the same?

Regards

Nikhil

[Former Member]

Hi,

You can get the default values in the your query by:

First, create a t-code for your Query.

Second, Create a transaction Variant for the transaction, selecting the "with content" option.

This will make your Query defaulted with the values all the time.

Hope this will help you.

Regards,

Vijay

[kenneth_chong]

hi when u have a slection field and the default are stored as variant , you eventually have to select those variant when you run the report. This cannot be automated.

If you want to automate create a query and have some program codes attached to those fields and not making those fields as selection fields.

Cheers.