Native SQL
Sometimes ABAP SQL doesn’t allow you to do something you’d be able to do using the database’s native SQL. It can still be done.
Sometimes ABAP SQL doesn’t allow you to do something you’d be able to do using the database’s native SQL. It can still be done.
You just found a bug in a standard FORM (or FM or METHDO):
FORM EQUAL_VALUE CHANGING W_DATE TYPE SYDATUM.
W_DATE = SY-DATUM - 1.
ENDFORM.You report the error to SAP but you know it will take them several days, weeks or months to publish a correction. And you need it corrected right now.
You decide to act.
So you use the implicit enhancement at the start of the FORM to replace the standard code with your own (just until the correction arrives, of course):
SapGUI usually keeps a history of the last values entered on each field. This is usually a good thing. But you may very well not want it to happen (in case you’re entering pornographic values in a specific field for example). You could always turn it off globally in the SapGUI settings.
But what if you just want to disable it in one particular field? Abapinho tells you how to do it.
We are all aware of SAP implicit enhancements which allow you to add code to the top or bottom of any block of standard code (methods, functions, etc). We’ve all used it to make a change to a BAPI or other standard piece of code.
But only recently did I find that you can also use these implicit enhancements to add parameters to standard methods and functions.
Toad is a very famous SQL tool which allows you to build and execute SQL queries in an easy and interactive way. And now, thanks to Mr. Sébastien HERMANN, SAP has a simplified version of this wonderful tool.
Thank you Sérgio Fraga for spotting this.
Greetings from Abapinho.
One of the few things that separates us humans from all the other animals is our ability to think about thoughts.
A sparrow may think I’m scared, I’ll say chirp chirp chirp and, as a direct consequence, whoever stands close to it will hear chirp chirp chirp.
The “where used” tool is very dear to any ABAP developer. Through it one can find out where a given object is used. Doesn’t look like much but we all know how important this is.
Class CL_GUI_FRONTEND_SERVICES is commonly used to upload and download files from and to the user’s local computer. But it can do many more good things. For example:
I just found out that SAP can take selfies. I still don’t see why one would need it. But that’s understandable because I never really understood the need for selfies anyway.
Here’s how SAP can take a selfie:
I don’t.
And I don’t want to. Why waste memory on stuff like that?
And I don’t need to because ABAP has a class just for that.