Apply filtering on Model to fetch filtered data in ABAP

When working with ABAP models, a simple change can sort the filtering problem out. Just replace the read call with an object notation rather than the current one which is based on position.

Understanding Object Notation vs Position-Based Reading

In ABAP, when fetching filtered data from models, using object notation provides better performance and clearer code structure compared to position-based reading. Object notation allows you to specify field names directly, making your code more maintainable and less prone to errors.

Position-Based Reading (Avoid This)

The traditional position-based approach relies on field positions ?

READ TABLE lt_data INTO ls_data INDEX 1.
IF sy-subrc = 0.
  lv_value = ls_data-field1.
ENDIF.

Object Notation Approach (Recommended)

Instead, use object notation with filtering conditions for better results ?

READ TABLE lt_data INTO ls_data WITH KEY field_name = 'VALUE'.
IF sy-subrc = 0.
  lv_value = ls_data-field_name.
ENDIF.

* Or using table expressions (more modern approach)
TRY.
    ls_data = lt_data[ field_name = 'VALUE' ].
    lv_value = ls_data-field_name.
  CATCH cx_sy_itab_line_not_found.
    " Handle case when no data found
ENDTRY.

Filtering Model Data Example

Here's how to apply filtering on model data using the improved approach ?

DATA: lt_filtered_data TYPE TABLE OF your_model_type,
      ls_filter        TYPE your_model_type,
      lv_status        TYPE string VALUE 'ACTIVE'.

* Apply filter using WHERE condition
SELECT * FROM your_model
  INTO TABLE lt_filtered_data
  WHERE status = lv_status
  AND   created_date >= sy-datum.

* Use object notation to read specific records
READ TABLE lt_filtered_data INTO ls_filter 
     WITH KEY status = 'ACTIVE'
              type   = 'STANDARD'.

Conclusion

Using object notation instead of position-based reading improves code readability and performance when filtering ABAP model data. This approach makes your filtering logic more explicit and reduces the risk of errors when table structures change.