Skip to Content
0
Former Member
Aug 26, 2014 at 05:25 AM

Issue with select option using NP operator

175 Views

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