topic Re: SAP ABAP Query in Application Development and Automation Discussions

SAP ABAP Query

Former Member — Wed, 29 Sep 2010 10:48:05 GMT

Hi All,

I need to add a where clause with constant value in SAP Query.

Example:

I joined VBAK and VBAP table to get the output. I used SQ01, SQ02 and SQ03 to build the querr and it is working fine as expected.

Now i need to restrict the VBAP-CHARG = '9953981656'. It has to be hard-coded in the query. How to achieve this?

Thanks,

Raj.

Re: SAP ABAP Query

Former Member — Wed, 29 Sep 2010 11:05:41 GMT

Hi Rajesh,

Open the code behind the SAP query, modify the SQL query and activate it.

Regards,

Amitava

Re: SAP ABAP Query

former_member214857 — Wed, 29 Sep 2010 22:49:27 GMT

You can add field VBAP-CHARG to the selection screen and pre-define it with the required value

Kind regards

Re: SAP ABAP Query

Former Member — Mon, 19 Aug 2013 15:08:17 GMT

Hi,

I Think the easiest ist to adding a little check in your code.

Directly in SQ02 open your infoset in change mode.

click on the extras button

select that you want to add a code.

insert the below line

CHECK VBAP-CHARG= '9953981656'.

Save and generate your infoset and it's done.

After some test I figured out that the mehode proposed in a post above, meaning add your field in the selection screen and fill it there is much better by performance point of view.

I do the following to handle such requestes.

Add fiield in the selection screen
create a variant setting the value and hiding the field.
create Z transaction with as default the variante create above
to the user I only handle out the transaction

Hope it helps

Best regards

Re: SAP ABAP Query

jogeswararao_kavala — Mon, 19 Aug 2013 16:37:36 GMT

As suggested by Yannick,

In SQ02

in the 'Record processing' section of the 'Code' tab of Extras, put the 'CHECK code' as shown below.

Save the code, Save and Generate the Infoset.

Run SQ01 afresh, and then see the result.

Jogeswara Rao K