Macros that I’m using for formatting reports quicker.
Theses are declared in the TOP of report.
Transport a query (SQ01)
Use program : RSAQR3TR.
Une query peut potentiellement être créée / modifiée sur tous les systemes (Dev/…/Prod) – à condition d’avoir les droits adaptés.
Pour la transporter il faut d’abord exporter son contenu dans un OT.
Il faut ensuite sur le système cible (et sur chaque mandant cible si la query n’est pas globale) réimporter la query.
SAP performance tools
SE30 : Runtime analysis
ST05 : Performance analysis (SQL trace)
https://blogs.sap.com/2007/09/05/the-sql-trace-st05-quick-and-easy/
Remove lock entries
To remove lock entries, use transaction SM12.
Search tag: supprimer entrées de blocage
READ TEXT – Code for mass extract
When needed to perform standart text mass retrieve, you can use the following code :
Read More
Transport standart text (SO10)
Use program (SE38) RSTXTRAN to put a standart text in a transport order (TO).
Search tag: OT, texte
Submit a program and write its report in your program
This post explain how to call another report in your report and how to print it SPOOL in your program.
Read More
Show progress indicator
* Show progress indicator
lw_percentage = ( sy-tabix * 100 ) / gw_nb_total.
CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
EXPORTING
percentage = lw_percentage
text = 'Message to display in SAP GUI progress bar'.
Manage Parameter ID
Get parameter in selection screen :
IF p_matnr IS INITIAL.
GET PARAMETER ID 'MAT' FIELD p_matnr.
ENDIF.
To set the entered value to parameter ID :
IF p_matnr IS NOT INITIAL.
SET PARAMETER ID 'MAT' FIELD p_matnr.
ENDIF.
Parameter ID table : TPARA (editable via SM30 transaction).
User parameter ID table : USR05.