if initial

[Former Member]

Hi,

           i want the condition like this If S_CUST is  initial and S_VEND is intial...i  want satisfy both in single if condition.i mean what is exact statement

          for example if i am  giving value in selection scree for Customer it should go to my ELSE select statement for vendor also same.

[roberto_vacca2]

Hi.

I suppose your S_CUST and S_VEND are select-options.

In that case

IF S_CUST[] IS INITIAL AND S_VEND[] IS INITIAL.

  "Do code with empty input for Customer AND for Vendor

ELSE.

" If you're giving value in selection screen for Customer OR for Vendor

ENDIF.

Hope to help

Bye

[Former Member]

HI Roberto,

Thank for Your Reply,can i write like this in my select statement where condition

select * from ztable into it

   wher bukrs = ist_bseg-bukrs

          and kunnr IN (s_cust , s_vend).

Regards,

Ramu

[Former Member]

No of course

You should merge them in a big range

DATA: R_KUNNR TYPE RANGE OF KNA1-KUNNR.


LOOP AT S_KUNNR 
    APPEND S_KUNNR TO R_KUNNR.
ENDLOOP.

LOOP AT S_LIFNR 
    APPEND S_LIFNR TO R_KUNNR.
ENDLOOP.


SELECT * FROM ZTABLE WHERE KUNNR IN R_KUNNR
............................................

but you have to check those two select-options are not in conflict

Max

[Patrick_vN]

Or check out the APPEND LINES OF syntax

[Former Member]

Ramu,

You can use them directly in your select statement! However, you need to write like this:

select * from ztable into it

   where bukrs = ist_bseg-bukrs

          and (kunnr IN s_cust

              or kunnr IN s_vend).

Also make sure that your ranges are not empty, otherwise all the data from you ztable will be retrieved.