topic Re: ABAP QUERY in Application Development and Automation Discussions

ABAP QUERY

Former Member — Mon, 12 May 2008 09:41:38 GMT

Hi,

I have a developed ABAP Query by the name "YCOPM_Bill_PUR".

In this query, I have an additional field "indicator". For this field, there is some code written, wherein either of the values "N" or "O" are assigned to this "indiactor" field. Now, the query should generate the output, only when indicator = N i.e. only those records should be displayed in the output for which the indicator field has value 'N'.

Records having indicator field value as "O", should not be displayed.

I want to know the place where I can write this condition and keep a control on the records displayed in the output.

Currently, the query output displays all records (irrespective of whether indicator = 'N' or 'O').

Please help me out.

Thanks & Regards,

Tejas Savla

Re: ABAP QUERY

former_member188827 — Mon, 12 May 2008 09:46:35 GMT

the simplest way to achieve dis is to use dis indicator field in selection sceen and hence when 'N' is given as selection criteria only dose records will be selected..

Re: ABAP QUERY

former_member188827 — Mon, 12 May 2008 09:48:04 GMT

also u can make use of filters

Re: ABAP QUERY

Former Member — Mon, 12 May 2008 09:56:55 GMT

Hi abapuser,

Thanks for your quick reply.

Yes, I have added the field indicator on the selection screen.

But, I want to know where can I write the condition :

if indicator = 'N'.

...............................

endif.

In "SQ02", there would be some place where i can write the above condition so that the output is trigerred only for those particular records. If possible, please do let me know.

Thanks in advance.

Regards,

Tejas Savla