Selection Parameters in ABAP Query

[Former Member]

Hi Experts,

I am new to ABAP Query, I had create a ABAP query using Logical database "PNM". Some default selection parameters are predefined in the logical database. but I don't want to use those selection parameters.

Can anyone please suggest me.

Regards,

Sbabu.

[Former Member · Accepted solution]

Sbabu,

Those parameters have been created as part of the LDB design. The LDB has been optimized for access using these parameters.  Using these will reduce the run time of your report, and will also reduce the possibility of inconsistencies in your report, where data items with similar names exist in several tables contained in the LDB. You can decide not to use them, but you should have a good reason for making this decision.  If you actually do not intend to use these parameters, then you probably should consider creating the report with table joins rather than LDB.

Assuming you still do not want to use these parameters, you can create a variant for this query, in which these fields are hidden.  If you then assign the variant as the default variant, the end user will not see the parameters, without taking extra steps.

Best regards,

DB49

[Former Member · Accepted solution]

Hi,

Thanks for your reply. I have tried with variant fields are hidden, but the field labels are still coming in the selection screen.

Please Guide me.

Regards,

Sbabu.

[Former Member · Accepted solution]

Sbabu,

Create the query.

Create a variant.  Hide the fields.

Selection screen, using the variant.  Key fields are now not visible.

Make this variant the standard (default) variant.

Best regards,

DB49

[Former Member · Accepted solution]

HI,

Thanks a lot for  your quick responds.

Before Variant Creation:

Creation of variant

after variant selection

  Please guide me,

Regards,

Sbabu.

[Former Member · Accepted solution]

Sbabu,

The parameters you are displaying are not standard in PNM.  If the infoset was modified (e.g. additional code, additional selections, external update program, internal code additions, etc.) you will have to approach the developer who modified the infoset and ask him to enable the parameters to be hidden.

You can review the infoset in SQ02.  Under Goto > Global Properties, check for an extermal program.  Also, on the Display infoset screen, review Extras, and Code, and Selection,.for entries.  Under Code you must check all code sections within the infoset coding for additions.

Best Regards,

DB49