Skip to Content
0
Former Member
Dec 04, 2006 at 12:46 PM

Use only entered parameters in query

36 Views

Hi friends I am defining 6 parameters for my sql.

  Select Trart Tbnum Nltyp Nlpla Vltyp Vlpla
    Into Corresponding Fields Of Wa_Itab
    From Ltbk
    Where Statu <> 'E'
      And Lgnum = PALGNUM
      And Nlpla = PaNlpla
      And Vltyp = PaVltyp
      And Trart = PaTrart
      And Tbnum = PaTbnum.

But when I am not entered any value for PaVltyp. But when I execute this query sql looking Vltyp = ''

Generally I am using IN operator for this. But this variable is not a range or internal table.

How can I execute my query without free parameters?

Sorry for my bad english. I wish you can understand me ? 😔