I thought that company specialise in CRM only?

Theres no guarantee you can get a job in sap even if u have the IQ to pass the exam(ABAP, and SD module is easy, anybody can pass the exam easily).
Starting Salary? rm1800 - rm2500 for freshies. But if u already have non sap working exp plus attended the certification, should be getting around rm3000 to rm3800.
I have a friend who took FI Certification from Genovate but failed the exam. He paid rm30K++ (im not sure) for the certification last year.
Till now jobless.

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.

This post has been edited by castelloz: Jul 2 2009, 02:30 PM

Nope, I cant read based on keys and then filter them out. Tried it and the performace was slower than the current inner join.

As I mentioned, I have created the secondary index only for the sql.
Creating a view not going to solve my problem, and I dont think its needed as only this program using this sql statement.
So not worth it to create a view just to improve readability.

Hey! Correct I need to get the latest transfer order no.
Yes, problem with the ORDER BY, If I removed that statement performance will be much much faster. But I need that ORDER BY statement.
MAX aggr. function? Hmm.. u just gave me a good idea. Will try that.
Yes, SELECT ENDSELECT is slower than SELECT statement only, but the where clause cant produce unique record, so have no choice, UP TO 1 ROWS needs to be added. Otherwise my senior wont approve the coding.
Yes the EXIT is to exit from the subroutine, ok I will use RETURN instead.
Buffer? Hmm that I err... I dont know
I tried to find but theres no suitable function module just to get the LTAP data.
Ah! Yeah actually all this while they use archiving for temporary solution. I need to improve the coding so that they do not have to do the archiving.

---

Added on July 5, 2009, 1:05 amI cant use this solution as I need the latest transfer order number. Thanks anyway.

---

Added on July 5, 2009, 1:12 amYes, but for this case if I use internal table I need to select atlaest 10K records or more (which already takes much time), tried that and I had compare with current inner join sql. Checked in ST05, and the performance was a bit slower actually.

This post has been edited by castelloz: Jul 5 2009, 01:13 AM

Functional folks normally VERY busy with their work.

How long u been in sap? 6,7 Months?

Crazy 2,3 months can do what?
SD/MM,FI simple reports display in alv, some conversion programs, and sapscript layout changes can la!
Some functional folks sometimes so stupid to think abaper just do coding in abap.

There are lot of stuffs la in abap, function modules, conversion programs using badi or bdc, sapscripts, smartforms, adobe form,
BSP, webdynpro, screen programing, badi, function module exit, data dictonary objects; tables,
data elements, structures, lsmw, workflow, idocs, and alot more la.
And the hardest i think is doing coding in object oriented because the design is the most important!
If ur design fail, everything will fail especially for complex requirements or to follow specific design
patterns eg: MVC. For simple program is sup sup sui.

And i havent talk bout performance tuning, sometimes this part is the most difficult one. Even to improve
1 sql statement also can takes a lot of time, need to try a lot of ways, views, inner join, subqueries, buffer, and ect..
And if everything fails the no choice; data archiving.

And do coding in abap also u need to code in the most efficient way, u need to know when to use local structures,
when to use field symbol, when to use CHECK statement, when to use IF Statement, when to use binary search, before use
binary search what u should do first, before use FOR ALL ENTRIES statement what u should do first to avoid the sql select all records
in the table, when u should use HASHED table and what are the do's n donts when coding abap and ect..
U think all these can cover in months meh?

And sometimes, being abaper u need to know some BW basic stuffs oso, because sometimes BW people needs abaper to do complex coding
for them. Eg: u need to know Start routine, end routine, routines in the transformation, need to learn to create
cubes, infoobjects, ods, load the cube, ods, master data, schedule them in process chain, do codings in ADP, do some variable
exit in CMOD to be used in query desginer, sometimes need to code in javascript for WAD,
and blablablablabla... Zzz..Zz....

Btw, u hardly can find good abapers in sap consulting firm la, because consulting firm dont really need a good abaper
escpecially the small sap consulting firm. They just need 2,3 seniors and the rest juniors and teach them the basics
like sapscript, do reports in alv, smartforms, conversion program, some stuffs in data dictionary, and
some badi or function module exit.
Thats all. And repeat again and again for different projects.


Some functionals(not all) are so stupid to think being abaper is so easy. Try to be one la before talk so much.
Thats why some abaper can easily tapau functional folks salary if they really good in what they doing.
Ceh.

Guys,
Anybody knows bout Change Document?

....

This post has been edited by castelloz: Dec 7 2010, 08:15 PM

...

This post has been edited by castelloz: Dec 7 2010, 08:15 PM

Bro oil n gas which company?

...

This post has been edited by castelloz: Dec 7 2010, 08:14 PM

No la, im not doing bw, im doing abap r3 onli, but sometimes the bw guys ask me to do abap for bw also.. but i know nothing bout BW.
Yeah d problem with this end user company is, they dun want to have a lot of customize objects to be created. They want us to fully use sap standard stuffs only.
Otherwise it takes a lot of time n effor to get the approval..

---

Added on June 1, 2010, 12:57 pmBro, u just work for 3 months bro, nothing much u can learn n do. Wait la
for 1 year or 2, when u get ur hands on stuff like webdynpro, some part of bw, portal, idoc, interactive online adobe form, xi, then only u realize abap is soooo funnn! Ahaks!

This post has been edited by castelloz: Jun 1 2010, 12:57 PM