Skip to Content

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

A question about sorted table...

Hello experts,

Recently I have been trying to optimize a certain report. On a certain part of a report the original programmer made this statement:

sort it_vendor by lifnr akont.

Now, I tried to experiment using sorted table so I can hopefully cut the response time of the report. Below is what I did:

TYPES: BEGIN OF s_vendor,

lifnr LIKE lfb1-lifnr,

akont LIKE lfb1-akont,

END OF s_vendor.

DATA: it_vendor TYPE SORTED TABLE OF s_vendor WITH NON-UNIQUE KEY lifnr

akont.

My question is, is my sorted table have the same effect as the statement the original programmer did?T^hanks guys!

Tags:
replied

The biggest bang you will get for improving performance is making your select statements efficient. Make sure that your program is not spending too much time retrieving the data. Make sure that the select statements are using the keys of the table the WHERE clause(or the keys of an index). I would start there first.

Regards,

Rich Heilman

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