A lot of people have asked if there is a transaction or report in SAP, where developers could execute SQL queries. The answer was always a no. A new report had to be developed for each query which took a lot of time away. Now there is a tool that fills this gap: the OpenSQL …
[ Continue Reading... ]
CALL FUNCTION ‘MB_READ_RESERVATION_POS_WA’ EXPORTING rsnum = rm07m-rsnum rspos = rm07m-rspos shkzg = shkzg bwart = xrkpf-bwart kzneb = rm07m-kzneb TABLES i_iooper = oper_tab seqtab = xrbefu. Related tables: RESB,RKPF
[ Continue Reading... ]
SAP has a limited provision for retrieving deleted programs. Let us have a look into the steps for the retrieval. OPTION 1: 1. Check in table VRSD if there is an entry with OBJTYPE = ‘REPS’ and OBJNAME = name of the deleted program. Retrieve Deleted Programs 2. If yes, then create …
[ Continue Reading... ]
The code book contain the beginners level programs for new ABAPers. The book covers almost every basic aspect that a programer in this domain should know. Some of the programs that the book covers are: How to define types and data objects A Few Simple Examples Working with database tables and internal tables Designing a report …
[ Continue Reading... ]
This sample report shows the basic structure for getting the report for the Pending Purchase Requisition based on various selection options on screen. The report loops throgh the required Tables of Purchase Requisition and based on the data entered on screen, displays the desired data. The report is to be modified/tweaked as per the custom …
[ Continue Reading... ]
There have been some cases where we, as an ABAP programmer, want to take SAP table data backup. Specially for the case where Basis Team refuses to get it back-up and restore the data for us. There have been some codes available on net where data is backed-up but not restored back to SAP. It …
[ Continue Reading... ]
The okcode field is deactivated when a modal window (the technical name of popup windows) is displayed, so it seems impossible to enter the debugger (using /H okcode). In common dialogs, the okcode field is available: But it is not available in modal windows (we see it but we can’t enter anything in it): The …
[ Continue Reading... ]
ABAP get (read) STAD data log Syntax SWNC_STAD_READ_STATRECS SAPWL_READ_STATISTIC_FILES
[ Continue Reading... ]