Useful ABAP code snippets that can be used in real life projects.
Data Class defines the space for database table where it should be stored physically on the hard drive of a database server. The setting for the Data Class is within the definition of Database Table in Techincal Settings. When you define the data class for the table that you create, the table is assigned to the...
Delivery Class defines how database table is going to be transported during installation, upgrade, and copies within landscapes, clients and customer systems. Types and use of Delivery Class: A Application table for master data and transaction data. Data is maintain by application. These tables are delivered to customer as empty tables. C Customer table used...
Lets start with explaining what are these two terms needed for. When we are defining database tables within SAP, each and every field needs to contain specific type. Lets say that we create a database table called Store. Along with other fields the store also needs to contain information when it is opened and closed. In...
Problem: When running Extended Syntax Checker, you get the following runtime error: [sociallocker id=1191] Generate manually the following programs: CL_SLIN=======================CP CL_SLIN_CHECKER_I18N==========CP CL_SLIN_CHECKER_SECURITY======CP CL_SLIN_CHECKER_DYNPROS=======CP CL_SLIN_CHECKER_MOD_ENH=======CP Detailed Procedure Go to SE38 Fill in the Program name from the list above Hit ‘Program’ from the menu Hit on ‘Generate’ or press ‘CTRL+F3’ Repeat the same procedure for all...
When you need to download records from database table into CSV file, you need to tweak a bit around to get the final file, because SAP does not provide straightforward function on how to do it. So, how to download records from database table into CSV file? Here is how you do it. [sociallocker id=1191] Go to SE16...
Sometimes you need to change specific database record but you don’t have ability to edit record in database directly using edit button, because database table has defined Delivery and Maintenance parameter to ‘Display/Maintenance Not Allowed’. In such case you can do the small hack using Debugger. How to change record in database table using debugger? [sociallocker id=1191] Go...
If you realize that index is not used in select, you need to force database to use it. For this, you need to use database hints in your code. Hints depend on database server. In the following example, here is how to force database to use index when using SAP Trial system (with MaxDB): SELECT * FROM zaa_bd_wpo_vol...
Sometimes your program may contain logic that must run long time. In such case, you can’t easily run it by pressing ‘Execute’ program, because SAP has defined maximum number of seconds that is able to run any programs this way (it’s called foreground processing). In such case, you must execute the program differently. You have...
Sometimes your program may contain logic that must run long time. In such case, you can’t easily run it by pressing ‘Execute’ program, because SAP has defined maximum number of seconds that is able to run any programs this way (it’s called foreground processing). In such case, you must execute the program differently. You have...
Do you want to create your first ABAP program? Watch this video ” Hello World in ABAP for SAP Developers” and learn it by yourself. If you need a system, where you can practice your ABAP knowledge, download instructions on how to install your free local SAP system here: http://abapacademy.com/howtoinstallsaptrial/
