In this step-by-step guide I’d like to show you how to create an application log which can be easily extended with your extra fields containing additional information. Continue reading
Author Archives: Spider
How to display a popup with items for selection in ABAP
In case you’d like to display a popup with list of values where user can select one or more values than follow the code snippet
Continue reading
Events in database table maintenance view
I needed to create a database table where there will be no key fields (all fields to be editable during table maintenance) but at the same time I needed some easy way how to identify each table row with unique key. And I found a solution using automatically generated GUID during row addition handled by maintenance view events. Continue reading
How to find transaction for a maintenance view
Sometimes I have a maintenance view and I need to find out if a transaction is assigned to it. It is usually not possible to find it with “where-used” list. So another approach needs to be used Continue reading
Row level locking of database table
The default behavior is if a person opens table maintenance generator and tries to maintain the table, the table is locked and no one else can maintain the same table at the same time.
This is because there is a “table-level lock” by default in SAP. This means only one user can maintain any table at a time through SM30 or any transaction that calls table maintenance generator. In the tutorial below you will find out how to replace table level lock with row level lock.
By row-level lock you ensure any number of users can modify the table at same time, but any particular row can be modified by only one user at a time (the first one who accessed the row for maintenance). We will create a transaction for this purpose. This transaction will call our custom report where at first the table lock is deleted and subsequently the table maintenance generator will be called. Continue reading
How to transport standard texts created in SO10
Standard texts created using TCode SO10 are not transported by default. But if you would like to add standard texts or their modifications to transport, you can use the following guide Continue reading
SAPScript: different column headers for different lists
Once I needed to have several lists in MAIN window output and each of these lists needed to have different column headers. As usually, there are several ways how to achieve this and I’ll try to present two possible ways:
MySQL Master Slave replication
Sometimes it might be usefull or even needed to replicate data from one place to another. If you have data you want to replicate in MySQL database, you are lucky, because replication is integrated in MySQL by default and you just have to set it up. Continue reading
SAP: How to create Data Source based on InfoSet
If you want to create a new datasource based on InfoSet where data is retrieved by your own Z-program, then walk through this tutorial and use it as an example or guide during creation of your own data source. Continue reading
SAP Business Transaction Events (BTE)
There are several scenarios in SAP where there are pre-defined places where you can influence the program flow. One of the approaches how to do this is technique called Business Transaction Events (BTE) Continue reading