Skip to Content
0
Former Member
Nov 02, 2009 at 08:25 AM

selec option

27 Views

HI all

Is it possible to use parameter like select option.

Scenario : I have customer number as parameter. When user chose one number select is performed.If customer number is inital select must provide all customers. OR situation I can use select-option and suppress p_kunnr-high.

1. SELECT-OPTIONS : p_kunnr FOR kna1-kunnr obligatory.

or

2. PARAMETERS : p_kunnr type kna1.kunnr.

slect * from kna1 into ls_kna1 where kunnr in p_kunnr.

....

endselect.

OR slect * from kna1 into ls_knaa where kunnr = p_kunnr.

....

endselect.