topic Re: Dynamic Select in Application Development and Automation Discussions

Dynamic Select

Former Member — Sun, 16 Nov 2008 16:44:48 GMT

Hi Experts

I want to write a dynamic select , with a dynamic where clause that get the data from a reange table.

the ranges table looks like :

sign    option    low    high
   I         NE      103     
   I         BT       100    105
   I         EQ      100

I try select with IN in the where clause but it doesn't work :

SELECT * FROM pa0003
  INTO TABLE pernr_table
  WHERE pernr IN range_emp.

Where range_emp is the name of the ranges table .

any help pls

Re: Dynamic Select

RaymondGiuseppi — Sun, 16 Nov 2008 16:58:51 GMT

Did you declare range_emp as ([DATA - RANGE OF |http://help.sap.com/abapdocu/en/ABAPDATA_RANGES.htm])

DATA: range_emp TYPE RANGE OF pernr_d.

Else, did you declare and fill (internal format) the sub fields of your internal table correctly.

Regards

Re: Dynamic Select

Former Member — Sun, 16 Nov 2008 17:06:57 GMT

Yes I do

Re: Dynamic Select

matt — Sun, 16 Nov 2008 17:18:16 GMT

The third entry isn't necessary - there is a logical OR between entries in a range. Assuming the data actually exists, chances are you need to convert to leading zeros.

look at function modules

CONVERSION_EXIT_ALPHA_INPUT

CONVERSION_EXIT_ALPHA_OUTPUT

matt

Re: Dynamic Select

Former Member — Sun, 23 Nov 2008 08:08:24 GMT

Thanks