11-02-2009 8:25 AM
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.
11-02-2009 8:29 AM
Hello,
When user chose one number select is performed.If customer number is inital select must provide all customers
You can try like this:
SELECT-OPTIONS: s_kunnr FOR kna1-kunnr NO INTERVALS NO-EXTENSION
BR,
Suhas
11-02-2009 8:29 AM
Hello,
When user chose one number select is performed.If customer number is inital select must provide all customers
You can try like this:
SELECT-OPTIONS: s_kunnr FOR kna1-kunnr NO INTERVALS NO-EXTENSION
BR,
Suhas
11-02-2009 8:29 AM
Hi,
It is not possible to use parameter as select option.
There is no HIGH Field for a parameter.Select option is a range table and paramter is just a single value.
You cannot get all entries when its intial in a paramater.
But you can suppress HIGH Value of select option by using the option NO-INTERVALS.
Regards,
Subhashini
Edited by: Subhashini K on Nov 2, 2009 2:00 PM