Suggestions thread for ABAP FAQ sticky

[Former Member]

See these threads for "online collections" in the ABAP Development forums =>

Edited by: Julius Bussche on Apr 21, 2009 5:22 PM

[ThomasZloch · Accepted solution]

ABAP Performance and Tuning

Are good blogs welcome as well? Just in case:

[JOINS vs. FOR ALL ENTRIES - Which Performs Better?|] by Rob Burbank <= Included in the FOR ALL ENTRIES vs. JOIN thread suggested below.

[Quickly Retrieving FI document Data from BSEG|] by Rob Burbank <= See below thread which has 3 blogs linked to it.

[The SQL Trace (ST05) u2013 Quick and Easy|] by Siegfried Boes <= See below blog added with comment to see others.

[The ABAP Runtime Trace (SE30) - Quick and Easy|] by Siegfried Boes <= I added this one and a comment to see other blogs by the same author. Will also be helpfull to introduce blogs to new folks and searching them for usefull knowledge.

[Runtimes of Reads and Loops on Internal Tables|] by Siegfried Boes <= See above blog added with comment to see others.

Another thread on Join/FAE, I know we have one already, but the discussion here is very good. Your choice.

<= Yes, much better than my suggestion. It also includes references to 3 blogs on the topic. I switched them.

ABAP Objects

(if somebody has a better example for this, please go ahead) <=there are already related references to this and the class in the DDIC section. Lets wait a day or two to see whether there is any support or an example which is a bit more colourfull.

Maybe the introductory text should point people to quote their SAP release (SAP_ABAP) when asking questions. This helps to avoid misunderstandings. <= I added that the "search first" tips are release dependent. Tick, tick, tick,... Eurika! The questions as wel!!

Will post more as time allows.

Cheers

Thomas

Edited by: Julius Bussche on Oct 7, 2008 5:10 AM

Edited by: Julius Bussche on Oct 7, 2008 5:35 AM

Edited by: Julius Bussche on Oct 7, 2008 5:39 AM

Edited by: Julius Bussche on Oct 7, 2008 5:42 AM

Edited by: Julius Bussche on Oct 9, 2008 6:06 AM

Edited by: Julius Bussche on Oct 9, 2008 6:10 AM

[Former Member · Accepted solution]

Thanks Thomas.

I added the thread (which also replaced mine and added 3 blogs at the same time (referenced in the thread).

Regarding the remaining blogs, lets wait a day or two more still to see whether there are cool threads around those blogs or mentioning them, otherwise I will add them for sure.

Cheers,

Julius

[Former Member · Accepted solution]

PS: When a thread is split like this one will be, then the second half becomes irrelevant for ponits and it is not possible to assign any to posts. Just incase anyone was wondering why I cannot assign ponits ... but I will make it up to you guys

Edited by: Julius Bussche on Oct 9, 2008 8:39 PM

Problem solved using a new thread instead of split.

[GauthamV · Accepted solution]

Data Transfers :

Guidelines for LSMW Data transfer

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90d90895-68dd-2a10-f096-bf8cf2e2f65b] <= this is very MM, PP, SD focused. Lets hang on to it for a while to see the other options.

Standard Reference for Data Transfer Conversion Assistant in LSMW

[http://help.sap.com/saphelp_nw04/helpdata/en/ff/03683ce9e7572ae10000000a11405a/frameset.htm] <= I added the root mode of the Data Transfer Workbench to introduce SAPHelp to those who don't know it. I hope very much that this is a usefull introduction to the whole of [help.sap.com]...

Reference for errors related to Data transfers in LSMW

[; <= As agreed I will wait for more suggestions.

Data migration through Ale/idocs

[https://forums.sdn.sap.com/click.jspa?searchID=17144905&messageID=5165027] <= I dont think this one can be saved by cleaning it up Generally I think a few interesting discussions and solutions are better examples than just a step-by-step procedure to follow.

Edited by: Julius Bussche on Oct 9, 2008 5:45 AM

Edited by: Julius Bussche on Oct 9, 2008 5:48 AM

Edited by: Julius Bussche on Oct 9, 2008 5:51 AM

[Former Member · Accepted solution]

Hi Gautham,

There are a few copy&paste, link-farms and "plzzzzz rwrd ponits" in those threads.

Would you like me to "clean" them and then we reconsider inclusion in this sticky thread?

Re:Blogs and Articles... yes, we can include them, but preferably included as an appropriate link in a thread or as an additional comment to the linked thread. Adding 1 or 2 blogs or links directly is also okay though.

We want to give examples of the quality expected and encourage searching.

Please confirm that I should include these (i.e. that there is no interesting forum thread on the topic which might lead to them...)

Cheers,

Julius

[GauthamV · Accepted solution]

julius,

ok, you can make the required changes and consider them into inclusion of sticky thread.

Also i will try to collect some more quality stuff related to data transfers and post as early as possible.

Cheers.

[ThomasZloch · Accepted solution]

Just found this ABAP FAQ in "Articles", seems to be good content at first glance.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/840ad679-0601-0010-cd8e-9989fd65... <= Lets wait to find out what that link is and who maintains it first.

Maybe something to put somewhere near the link to the Wiki?

Thomas

Edited by: Julius Bussche on Oct 9, 2008 5:51 AM

[Former Member]

The Enhancements section needs some more meat on the bone.

I recently was involved in this thread about the switch framework (which as you can see is very usefull to know about...).

<= added .

Does anyone know a better one, or others to add for the next round of updates?

Cheers,

Julius

Edited by: Julius Bussche on Nov 19, 2008 3:05 PM

[suresh_datti]

Julius,

Thanks for the info... this was just the ammunition I needed..

~Suresh

[Former Member]

Wow! The sticky thread is even helping the über-gurus!

I assume you are refering to the Switch Framework thread. I did not know this until recently either - or at least I knew about the Switch Framework but not about the "small print" advantages...

This no doubt makes those who contributed to it very proud of the efforts put in so far! Thanks again for the feedback to the usefullness of the sticky thread.

Cheers,

Julius

[Former Member]

The sticky thread from ABAP General needed to be split into own respective forum threads due to size limitations per post.

Probably a good idea anyway, and now there is lots of space in each thread to add more. Actually, they look a bit empty now...

The folks who have contributed to the threads are also listed here now in this thread.

Cheers,

Julius

[ThomasZloch]

Just stumbled into this old gem here, for section "ABAP performance". I gets especially interesting at about half way through.

<= Added

Edit: more discussion on , especially good statements by YukonKid and Siegfried. <= Added and cleaned the formatting

Thomas

Edited by: Julius Bussche on Nov 8, 2008 10:34 PM

[Former Member]

Thanks Thomas!

I have added them and cleaned up the formatting a little bit.

Unfortunately I have run out of points-per-thread here and don't want to close the thread...

I will make it up to you with a beer oneday (or a tea)!

Sames goes for any other further contributions.

Cheers,

Julius

[ThomasZloch]

I can live with that, maybe Vienna 2009? ...beer please

Cheers

Thomas

[Former Member]

This might discourage people from asking ill thought out questions:

[Sticky Thread: Funny threads? |;

Rob

[Former Member]

>

> This might discourage people from asking ill thought out questions:
> 
> [Sticky Thread: Funny threads? |;
> 
> Rob

but should it be a part of it. most of the people watch this in cc daily. but still they are asking...

[Former Member]

I added an Other Threads section for a link to it, and included "The Rules" as well.

Cheers,

Julius

[Former Member]

>

> but should it be a part of it. most of the people watch this in cc daily. but still they are asking...

I somehow get the feeling that a lot of people (particularly tyros and also posters that ask hundred of questions) never see this.

Rob

[Former Member]

>

> I somehow get the feeling that a lot of people (particularly tyros and also posters that ask hundred of questions) never see this.
> 
> Rob

yes thats true. julius already added that in other links part.

[Former Member]

Moved to Suggestions and Comments forum...

[Former Member]

>

> Moved to Suggestions and Comments forum...

and the first part you moved to ABAP General forum , but now it is not a sticky , any reason..?

Edited by: Vijay Babu Dudla on Oct 9, 2008 3:09 PM

[Former Member]

I forgot (but now added) the sticky flag to the thread in ABAP General.

[Former Member]

now i checked it and corrected my message. many many thanks for taking this initiative. if we find some more useful stuff, are you going to add them to it...

[Former Member]

and who is responsible for this FAQ ???

When I read the discussion SELECT SINGLE versus SELECT UP TO 1 ROWS ...

then I must say: 'Not recommended!'.

The 2 commands are simply identcial for the database.

Siegfried

[Former Member]

Hi Siegfried,

>

> and who is responsible for this FAQ ???

It is a bit of a team effort between those who contribute to it. Any inputs (or outputs are welcome.

> When I read the discussion SELECT SINGLE versus SELECT UP TO 1 ROWS ...

> then I must say: 'Not recommended!'.

>

> The 2 commands are simply identcial for the database.

Which thread are you refering to? Is it included above?

Cheers,

Julius

[ThomasZloch]

Hi Siegfried,

I assume you're referring to the link I provided. Good question, I cannot see an author's name anywhere.

If there is serious doubts about the accuracy of some of the information, we should probably not reference it. Or better, have it corrected and then reference it. It's not a Wiki, so I'm not sure about the process.

Thomas

[Former Member]

Ahhhh... now I see it as well. Siegfried was refering to the FAQ "thing".

I agree that there is no traceability to who maintains it or created the entries. It is neither a wiki nor an article.... I will ask Marylin whether she knows about it and what it is.

I also found in it:

> Usually the best way to do it is using a SELECT... FOR ALL ENTRIES IN... instead.

Julius

[GauthamV]

unicode upgrade details

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/efd1dd90-0201-0010-e1b0-8437c998cd79] <= link already included in below thread, so not added again.

[https://forums.sdn.sap.com/click.jspa?searchID=15241219&messageID=5930564] <= okay, added

[] <= this thread is a link-farm with points begging... not added

Alv printpreview problem

[https://forums.sdn.sap.com/click.jspa?searchID=16997725&messageID=5874162] <= Contains sms-speak and a guest ... are you sure you want this?

Alv grid control

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e8a1d690-0201-0010-b7ad-d9719a415907] <= okay, added, but lets try to focus on threads from the forum

Alv grid refresh problem

[https://forums.sdn.sap.com/click.jspa?searchID=16997725&messageID=6117154] <= okay, moved to UI programming and added

Icons in Alv grid

[https://forums.sdn.sap.com/click.jspa?searchID=16998099&messageID=6054143] <= added after deleting a link-farm

Color and icon in alv top of page

[https://wiki.sdn.sap.com/wiki/display/Snippets/UseiconandcolorinALV%28list%29topof+page] <= I already have a link to the ABAP Wikis in the top of the post. I think that is sufficient to cover the wikis generically?

Edited by: Julius Bussche on Oct 2, 2008 12:09 PM

Edited by: Julius Bussche on Oct 2, 2008 12:10 PM

Edited by: Julius Bussche on Oct 2, 2008 12:51 PM

Edited by: Julius Bussche on Oct 2, 2008 12:54 PM

[Former Member]

I think we have an excellent basis for building the thread further now over time.

Any objections if we now split the top post into a new thread, add a link in it to this thread here and move it into ABAP General for a "maiden voyage"?

Cheers,

Julius

[ThomasZloch]

I wish we had more items for Performance and Data Transfers. I did not have much time yet to scan for good ones, but as you said we can always add stuff later on. So I would go ahead as planned.

Cheers

Thomas

[GauthamV]

julius,

some more threads related to performance and data transfers.

Data migration procedure and guidelines.

[https://forums.sdn.sap.com/click.jspa?searchID=17264016&messageID=1905444] <= Added.

Bdc call transaction Vs Session method

[https://forums.sdn.sap.com/click.jspa?searchID=17265020&messageID=1870243] <= Added, but will need some serious cleaning out of a few copy&pasters first....

performance issues

[https://forums.sdn.sap.com/click.jspa?searchID=17264799&messageID=707802] <= Topic already included above.

quick retrive fi data from bseg by rob burbank

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7692] [original link is broken] [original link is broken] [original link is broken]; <= Topic already included in an earlier suggestion.

Ecatt solutions

[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/u/37984] [original link is broken] [original link is broken]; <= The first blog of the series is added, with a note to read the others.

Some basic problems in bdc data transfer

[https://forums.sdn.sap.com/click.jspa?searchID=17265349&messageID=117150] <= Added.

[https://forums.sdn.sap.com/click.jspa?searchID=17265349&messageID=2760462] <= Ahhh.... lets leave this one where it is.

Debug bdc in background process

[https://forums.sdn.sap.com/click.jspa?searchID=17265349&messageID=3521566] <= I am sure I have seen a few better ones on debugging background jobs. I will try to find one of them.

If you feel any of these threads require modifications ,you can do them and add to the sticky thread.

Cheers.

Edited by: Gautham chakraverthi on Oct 9, 2008 6:09 PM

Edited by: Julius Bussche on Oct 9, 2008 7:45 PM

Edited by: Julius Bussche on Oct 9, 2008 7:52 PM

Edited by: Julius Bussche on Oct 9, 2008 8:29 PM

[Former Member]

(This is just a stump post to be split later when the first post moves to ABAP General.)

Please make suggestions by posting SDN links with a brief explanation to this thread which can be included in the FAQ and Memorable threads sticky in ABAP General.

The first suggested posts are ones known to me to give new folks an impression of the discussions... feel free to suggest removing them as well

I am sure that you ABAP gurus will know much better examples of threads which would be of great value to this sticky thread.

Cheers,

Julius

Edited by: Julius Bussche on Oct 9, 2008 8:38 PM

[Former Member]

see subsequent post

Edited by: Julius Bussche on Oct 3, 2008 1:29 AM

[Former Member]

Hi Vijay,

As agreed, I will wait for your second post.

Anyone else with suggestions of "gems" in the forums worth adding here?

We dont want to document the whole ABAP language here, such some memorable threads to show poeple the sort of quality which can be expected (and they should also uphold), and of course some cool stuff which has happened in the ABAP forums.

Cheers,

Julius

[Former Member]

ABAP General

=> Subtotals in ALV <= Added and moved to UI programming

=> Subtotals text in ALV /Modification of Subtotals in ALV <= Moved down to new thread.

=> ALV OM Save layout option <= Moved down to new thread.

=> ALV Report with page break. <= Moved down to new thread.

=> ALV Sorting and Group Functionality working with Checkbox <= Moved down to new thread.

=> Calculating Total with Checkbox in ALV Grid <= Moved down to new thread.

=> General Fieldcatalog error. <= Moved down to new thread.

=>Problems with REUSE_ALV_FIELDCATALOG_MERGE <= Moved down to new thread.

=> Converting SLIS fieldcatalog to LVC fieldcatalog <= Moved down to new thread.

=> Capturing the editable fields values in ALV <= Moved down to new thread.

=> Refreshing the ALV Display <= Moved down to new thread.

=> Reading the editable values for ALV LVC function <= Moved down to new thread.

=> Radio buttons in ALV report <= Moved down to new thread.

=> Usage of Styles in ALV for disable/enable input option <= Moved down to new thread.

=> executing Unix commands <= Hmmm... c-calling the 'system' does not work in my systems during normal operations. See system param 'rdisp/call_system' which can be disabled, then the code dumps. Is there a different thread with DATASET commands? SXPG?

=> ABAP char Utilities CR_LF use , replace '##' in a application server <= Ahhh yes, I remember this series. This is one of the nicer threads from it... Added.

=> ABAP char Utilities Horizontal_tab use , replace '#' in application server file <= Sufficiently covered by the next thread.

=> ABAP char utilites Newline, replace '#' in application server in end of line <= Added.

=>sending mails to outlook <= Added.

=> upload image to mime repository <= Added.

=> use of Import and export refer Rich Heilman's code <= Added.

=> Selection parameter password behaviour <= Added.

ABAP Dictionary

=>

Form Printing

=>Download Logo from SE78 <= Okay, added... but the thread is rather old and ws_download is obsolete now, isn't it?

=> Upload Logo programatically <= Hmmm... external performs and guests. I would like more opinions on this one before adding.

UI Programming

[Top of page in OO ALV| ]=> Top of page in OO ALV <= I understand that this blog was very helpfull, but it is full of email addresses. Hmmm.. tough call Is there another example (thread) without any "here is my mail address" comments. We want to avoid those.

[Top of page Alignments in Normal ALV|] => Top of page in normal ALV <= this is more wiki material in a blog, but again often asked... Hmm.. lets go through the others first and come back to this one.

=> URL display using HTML Viewer <= Added.

=> Select-options usage in Module pool programming <= Added.

New! =>

Enhancements and Modifications

=>

ABAP Performance and Tuning

=>

Data Transfers

=>

ABAP Objects

=>

Edited by: Julius Bussche on Oct 3, 2008 10:31 PM

Edited by: Julius Bussche on Oct 3, 2008 10:34 PM

Edited by: Julius Bussche on Oct 3, 2008 10:38 PM

Edited by: Julius Bussche on Oct 3, 2008 10:43 PM

Edited by: Julius Bussche on Oct 3, 2008 10:55 PM

Edited by: Julius Bussche on Oct 4, 2008 12:06 AM

Edited by: Julius Bussche on Oct 4, 2008 12:40 AM

Edited by: Julius Bussche on Oct 4, 2008 12:57 AM

Edited by: Julius Bussche on Oct 4, 2008 1:23 AM

Edited by: Julius Bussche on Oct 4, 2008 3:27 PM

Edited by: Julius Bussche on Oct 4, 2008 3:39 PM

Edited by: Julius Bussche on Oct 4, 2008 5:40 PM

Edited by: Julius Bussche on Oct 4, 2008 5:59 PM

Edited by: Julius Bussche on Oct 4, 2008 7:17 PM

[Former Member]

Thank you Vijay!

I went through some of them (also great stuff!), but it is late already here (long meeting) so I will go through them tomorrow in more detail and add them to the sticky.

I might also move some from one ABAP forum to another, but will check it with you first.

1000 thanks,

Julius

[Former Member]

I will be adding some more, I am collecting all in one document and post it once,

Best Regards

Vijay

[Former Member]

Please find some more threads ..

ABAP General

<= added with comment

<= added with comment

<= Yes, this does work, but do we want to encourage it by adding it to this sticky? Just asking...

<= Pity about the guest ... I added it and removed the name but perhaps we can find one without a guest in it :-). Also moved it to DDIC - we need a few there as well.

<= Hmmmm... assign ('(dirty_trick) to <sticky_tread>)')... done

=> Dynamic Table Reference <= Added and moved to DDIC to balance the threads a bit...

Form Printing

<= rather blunt question... but good answers. Added and moved to correct forum.

UI Programming

=> Two ALV Grids <= Iadded this one and moved it to correct forum.

=> Two ALV Grids <= see above which covers the topic without guests.

Edited by: Julius Bussche on Oct 4, 2008 1:36 AM

Edited by: Julius Bussche on Oct 4, 2008 1:02 PM

Edited by: Julius Bussche on Oct 4, 2008 1:18 PM

Edited by: Julius Bussche on Oct 4, 2008 1:27 PM

Edited by: Julius Bussche on Oct 4, 2008 1:56 PM

Edited by: Julius Bussche on Oct 4, 2008 2:11 PM

Edited by: Julius Bussche on Oct 4, 2008 2:26 PM

Edited by: Julius Bussche on Oct 4, 2008 2:31 PM

[Former Member]

Hi Vijay,

I have added more and will continue further tomorrow.

There are some (particularly older threads) where the coding does work, but I am uncertain about whether it is the right stuff for this sticky. (I am a bit biased as you know

Cheers and thanks again for the great inputs!

Cheers,

Julius

[former_member184657]

This is going to be an awesome collection. Im licking my lips already. Some of my memorable discussions have already made their way in. Will keep looking in case something pops up.

pk

[Former Member]

>but I am uncertain about whether it is the right stuff for this >sticky. (I am a bit biased as you know

you are the best to take decision in this case.

I will try to get some more and add a new one.

>Exporting Graphics from SAP =>Download Logo from SE78 ><= Okay, added... but the thread is rather old and >ws_download is obsolete now, isn't it?

we can give some comment and ask to use GUI_DOWNLOAD <= Good idea! Done and added.

>Top of page in OO ALV=> Top of page in OO ALV <= I >understand that this blog was very helpfull, but it is full of >email addresses. Hmmm.. tough call Is there >another .example (thread) without any "here is my mail >address" comments. We want to avoid those.

=> Logo and Top of page in OO ALV <= I added this one and the blog as well to cover the topic. (and the huge friendly smile

=> just check this too <= See above.

>BDC for SE78 Transaction => Upload Logo programatically ><= Hmmm... external performs and guests. I would like more >opinions on this one before adding.

I don't think there is a replacement for this..

>Reading/Writing source code programmatically <= Yes, this >does work, but do we want to encourage it by adding it to this >sticky? Just asking...

I think it is not required. in some case i saw it repeated.

you can add this also..

=> Logo upload for ALV reports using OAER transaction <= See above.

PS: The threads so beautiful and colorful. it definitely turns out to be a good one.

Edited by: Vijay Babu Dudla on Oct 4, 2008 5:43 AM

Edited by: Julius Bussche on Oct 4, 2008 1:07 PM

Edited by: Julius Bussche on Oct 4, 2008 2:56 PM

[Former Member]

Okay, I have gone through all except these ones below which are all ALV related:

=> Subtotals text in ALV /Modification of Subtotals in ALV

=> ALV OM Save layout option

=> ALV Report with page break.

=> ALV Sorting and Group Functionality working with Checkbox

=> Calculating Total with Checkbox in ALV Grid

=> General Fieldcatalog error.

=>Problems with REUSE_ALV_FIELDCATALOG_MERGE

=> Converting SLIS fieldcatalog to LVC fieldcatalog <= Added and moved to DDIC, as that is where the final solution was.

=> Capturing the editable fields values in ALV

=> Refreshing the ALV Display

=> Reading the editable values for ALV LVC function

=> Radio buttons in ALV report

=> Usage of Styles in ALV for disable/enable input option

We already have an number of ALV threads and the wiki and the ABAP General list is quite a bit longer than the others. Shall we add most of these, or can we cut it down a bit to a shorter list?

What we also still need are some Modification and Enhancements threads (anyone remember a really cool discussion on enhancement frameworks or a tricky enhancement spot or user-exit? I know one, which I will add, but I am sure there are more?

Data Transfers?

A few more DDIC threads?

PS: A few of the threads which I added also had some minor cleaning done to them. Delete a few meaningless guest posts where possible, corrected the point assignment in some cases where it was too inaccurate.

Cheers and thanks for this great help!!

Julius

Edited by: Julius Bussche on Oct 5, 2008 10:52 AM

[Former Member]

I started with General, and UI, now i will go for enhancements, datatransfers and DDIC threads. i am some what busy today, so i will start my collection now onwards..

you are making this sticky very colorful. this thread will be a role model to the other forums....

Thanks

Vijay

[Former Member]

It must be getting late already in India, so we can carry on tomorrow.

Another option for all the ALV stuff is to create a special heading just for ALV?

I think a "Tips&Tricks or Other stuff" heading might as well be cool (later on) if there threads for it.

I also think that we should not add too many threads to each heading, otherwise people wont read it anymore (remember the huge link-farms from the past?

Cheers,

JUlius

Edited by: Julius Bussche on Oct 4, 2008 9:34 PM

[Former Member]

>I also think that we should not add too many threads to each heading, otherwise people wont read it >anymore (remember the huge link-farms from the past?

yes we have to place best of what we have.