Program
SBAL_DELETE (SLG2)
Purpose
You can use the selection options to define which logs are deleted.
Selection
Expiration date
All logs have an expiration date (field ALDATE_DEL in the table BALHDR) after which they can be deleted and a flag (field DEL_BEFORE in the table BALHDR), which specified whether the log can be deleted before the expiration date:
• DEL_BEFORE has the value “X”: The log cannot be deleted before the expiration date.
• DEL_BEFORE is empty: The log can be deleted before the expiration date.
Selected Options and Selection Conditions
• Only logs that have reached the expiration date:
No logs are deleted that have not yet reached the expiration date on today’s date.
• Also logs that can be deleted before the expiration date:
Logs with an empty DEL_BEFORE flag are deleted even if they have not reached the expiration date on today’s date.
• From (Date/Time), To (Date/Time):
Logs created in this period are deleted (the relevant fields are ALDATE and ALTIME in the table BALHDR). You can use variables for these fields (such as logs older than three months) in the variant definition (for example, for background processing).
The change date and time (fields ALCHDATE and ALCHTIME in the table BALHDR) are ignored.
• Get number only:
The program determines the number of logs that match the selection options and aggregates them using the object and subobject. Alongside the number of logs per object and subobject, you can also see the percentage of all logs affected in the current client.
If you do not make any restrictions, all deletable logs are displayed.
If you choose this option in background processing, an overview of logs by expiration date is also displayed.
• Create list:
Up to 100 logs that match the selection options are displayed in a list.
• Delete now:
All logs that match the selection options are deleted directly.
• Schedule background jobs:
All logs that match the selection options are deleted using parallel background jobs whose name matches the pattern DEL_APP_LOGS_
Options in Expert Mode
These options are shown if you switch to expert mode by choosing “Program” -> “Expert Mode”. We do no recommend that you change these default values.
• Number of Logs per Job:
specifies the amount of logs processed in a single background job.
• COMMIT Counter:
Determines the amount of logs deleted before a database commit is performed.
Example: You want to delete 1000 logs and the COMMIT counter is 100. This means that the logs are grouped into 10 packages of 100 logs that are processed consecutively. A database commit is performed for each package.
Activities
See also, SAP Note 195157.
