Here I have the following select statement which is posing a performance issue. I just need a single field record from this table
hence the query goes like this..
select name_org1 INto adname from
but000 where partner = adnumber.
If I do not include endselect statement the query poses an error, and select .... endselect poses performance issue.
How can i improve this query without using the internal table. Because I have to create another internaltable just to get one field of data. Is there a better way of doing it?