Filtering a dynamic table

mpj — Fri, 29 Jul 2016 12:07:01 GMT

Hi all,

I have a scenario where I need to filter a dynamic table (say, a data table) based on another ID table (say, key table). Is this possible?

The following code snippet is an example of what I am trying to do.

DATA: lt_flight TYPE STANDARD TABLE OF sflight,

lt_carr TYPE STANDARD TABLE OF scarr,

lt_data TYPE REF TO DATA.

FIELD-SYMBOLS: <lt_data> TYPE ANY TABLE.

SELECT * FROM sflight INTO TABLE lt_flight.

SELECT * FROM scarr INTO TABLE lt_carr.

CREATE DATA lt_data TYPE sfligt.

ASSIGN lt_data->* TO <lt_data>.

MOVE-CORRESPONDING lt_flight TO lt_data.

DATA(lt_temp_data) = FILTER #( <lt_data> IN mt_carr WHERE ('CARRID') = carrid ).

<lt_data> can take any table data and the filtering needs to be done on the same. Also please note that 'lt_data' is also another generic table.

Right now, I am getting a syntax error: "The type or field "%_ANY_TABLE" is generic. The access types "ANY TABLE" or "INDEX TABLE" can only be used for parameters" pointing to the last line.

Is there anyway we can make this filtering possible?

Re: Filtering a dynamic table

SuhaSaha — Fri, 29 Jul 2016 13:52:11 GMT

Hi,

You cannot use generic table types(in your case <lt_data> TYPE ANY TABLE ) with FILTER.

Refer : ABAP Keyword Documentation

BR,

Suhas

topic Re: Filtering a dynamic table in Application Development and Automation Discussions

Filtering a dynamic table

Re: Filtering a dynamic table