topic Re: Issue with select option using NP operator in Application Development and Automation Discussions

Issue with select option using NP operator

Former Member — Tue, 26 Aug 2014 05:25:00 GMT

Hi all,

there is a issue with select option having NP operator.

It does not excludes all the value , instead it includes all the value.

the issue happens if we have 2 line item of NP operator.

Below is the sample code.

Kindly suggest.

DATA: lt_user1 TYPE grac_rt_user,

ls_user1 TYPE grac_rs_user.

DATA:it_user_group TYPE grac_rt_user_group.

DATA: lt_conn_range TYPE grac_rt_connector,

ls_conn_range TYPE grac_rs_connector.

DATA lt_temp_user TYPE grac_t_user.

ls_user1-sign = 'I'.

ls_user1-option = 'NP'.

ls_user1-low = 'FF*'.

APPEND ls_user1 TO lt_user1.

ls_user1-sign = 'I'.

ls_user1-option = 'NP'.

ls_user1-low = 'KB*'.

APPEND ls_user1 TO lt_user1.

ls_conn_range-sign = 'I'.

ls_conn_range-option = 'EQ'.

ls_conn_range-low = 'GI7CLNT600'.

APPEND ls_conn_range TO lt_conn_range.

SELECT * FROM gracuserconn

INTO CORRESPONDING FIELDS OF TABLE lt_temp_user ##too_many_itab_fields

* FOR ALL ENTRIES IN lt_user1

WHERE user_id in lt_user1 "it_user

AND user_group IN it_user_group

AND connector IN lt_conn_range.

Regards

Aravindan

Re: Issue with select option using NP operator

former_member249399 — Tue, 26 Aug 2014 06:13:34 GMT

please try with

ls_user1-sign = 'E'.

ls_user1-option = 'CP'.

ls_user1-low = 'FF*'.

APPEND ls_user1 TO lt_user1.

ls_user1-sign = 'E'.

ls_user1-option = 'CP'.

ls_user1-low = 'KB*'.

APPEND ls_user1 TO lt_user1.

Re: Issue with select option using NP operator

Former Member — Tue, 26 Aug 2014 06:24:01 GMT

Hi Ranjana,

It works if i use with SIGN E and Option CP.

I just want to know why its not working with NP , if its having 2 line items.

In case of 1 line item it works.

Or any other work around in select query.

Best Regards

Aravindan M

Re: Issue with select option using NP operator

Former Member — Tue, 26 Aug 2014 07:01:14 GMT

The reason I think is you have included two values with NP in lt_user1, which indicates an OR condition. so it selects any record which does not have pattern as FF* OR KB* with AND condition for the GI7CLNT600.

If you want to exclude all the records which have FF*/KB* then try

ls_user1-sign = 'I'.

ls_user1-option = 'NP'.

ls_user1-low = 'FF*'.

APPEND ls_user1 TO lt_user1.

ls_user1-sign = 'I'.

ls_user1-option = 'NP'.

ls_user1-low = 'KB*'.

APPEND ls_user1 TO lt_user2.

SELECT * FROM gracuserconn

INTO CORRESPONDING FIELDS OF TABLE lt_temp_user ##too_many_itab_fields

* FOR ALL ENTRIES IN lt_user1

WHERE user_id in lt_user1 "it_user

and user_id in lt_user2

AND user_group IN it_user_group

AND connector IN lt_conn_range.

Hope it helps.

Regards

Re: Issue with select option using NP operator

Former Member — Tue, 26 Aug 2014 08:01:23 GMT

Hi Abhijit,

Thanks for you reply.

In my case the input parameter comes dynamically.

the line item in lt_user1(select option) may be 1 , 2 or 3 .

as it depends on how user provides input.

Best Regards

Aravindan M

Re: Issue with select option using NP operator

Former Member — Tue, 26 Aug 2014 08:30:05 GMT

What I am trying to put across is, if your internal table it_user1 contains multiple line conditions they are treated as OR condition rather than AND condition which possibly brings in more values.

Re: Issue with select option using NP operator

pasumpon_karuppaiah — Fri, 07 Nov 2014 14:41:10 GMT

Hi ,

I had the same issue ,

As suggested by ranju , you can use below set of code.

which solved my issue..

ls_user1-sign = 'E'.

ls_user1-option = 'CP'.

ls_user1-low = 'FF*'.

APPEND ls_user1 TO lt_user1.

ls_user1-sign = 'E'.

ls_user1-option = 'CP'.

ls_user1-low = 'KB*'.

APPEND ls_user1 TO lt_user1.