ABAP QUERY

[Former Member]

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

[former_member188827]

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..

[former_member188827]

also u can make use of filters

[Former Member]

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