Guys,
Junior abaper need help here.
How do I improve the performance of this coding?

    SELECT ltap~tanum ltap~nlpla ltap~wdatu INTO (ltap-tanum, ltap-nlpla, ltap-wdatu)
      UP TO 1 ROWS
      FROM ltap INNER JOIN lagp
      ON lagp~lgnum =  ltap~lgnum
      AND lagp~lgtyp =  ltap~nltyp
      AND lagp~lgpla =  ltap~nlpla
        WHERE lagp~skzue = ' '
        AND ltap~pquit = 'X'
        AND ltap~matnr = ls_9001_scrn-matnr
        AND ltap~lgort = ls_9001_scrn-to_lgort
        AND ltap~lgnum = ls_9001_scrn-lgnum
        AND ltap~nltyp = ls_9001_scrn-nltyp
      ORDER BY tanum DESCENDING.
    ENDSELECT.

    IF sy-subrc EQ 0.
      ls_9001_scrn-nlpla = ltap-nlpla.
      EXIT.
    ENDIF.

With this conditions:

1)I only 1 to get 1 record.
2)I need to get the record by latest tanum (Transfer Order No)
2)The LTAP table has 10K records. Even u go to SE16, just click No of records button, it took about 35 secods before show the result. So SELECT INTO TABLE lt_ltap then only sort in application server actually takes longer time.
3)INNER JOIN must be used, else for sure will take longer.

The index for the table is enough for the sql.

*Splash tea to the monitor* 

It seems like SAP income is considerably higher than the average programmer C++, Java etc earning 4-5k average 3 years experience. 

The average non SAP programmer also need to work late nights and weekends chasing deadlines. Thus the income over effort ratio of SAP indicates that it is a more efficient earning vehicle.

Please correct me if I am wrong.

Chezzie, dont mislead other people on this. Your jargons are totally useless in this topic.

There is no interfacing needed for this and definately no XI or whatever e2e bridge programs.
First of all, barcodes are simply just numbers. They represent numbers of something maybe your product ID or product code. So when you do a scanning, it simply convert your barcode to some numbers/interger and that is already your input into the SAP system.  It lies with how you want to manipulate the 'input' inside your program.

Additionally, you do not need to worry about the tool that does the conversion. Barcode scanners are 'plug and play' devices. If not vendors will provide you with the drivers.

Printing barcodes are something a little bit deeper. Depending on your requirements, (different printers, different standards of barcode, etc.) it may need customizations. 3rd party tools are needed here. Oh and you will need to collaborate with some abapers. (definately not me or chezzball)

Anyone of you here doing contract or permanent role in Singapore?
Just wanted to find out the estimated standard daily rates.

So far the offers have been various depending the different headhunters.
Apparently the local SAP consultants in SG earns lower then those in MY.