Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance issues in select from table HRV1222A

Hi all,

We have a custom FM with this select in the code:

SELECT otype objid

         FROM hrv1222a

         INTO TABLE lt_hrv1222a

         WHERE plvar EQ '01'

           AND begda LE sy-datum

           AND endda GE sy-datum

           AND istat EQ '1'

           AND attrib EQ lv_attrib

AND low EQ lv_value.

We use this FM a lot of times and we're having a lot of performance problems due this select.

Do you know how can I improve this code?
Is there any FM to get the data we want without doing a select to this table? Actually it is a view of two tables.

May be we need to create secondary indexes to the tables of the view...

Thanks in advance,


Not what you were looking for? View more on this topic or Ask a question