Tips

Tips

• Creating a program from an SHDB recording made in another client

  Creating a program from a recording is sometimes difficult as data is in one client and ability to create the program is in another.  Continue Reading

• Extended transport control

  In releases prior to R/3 4.5 it was only possible to configure the transport route to go from system to system.  Continue Reading

• Do an SAP user switch from a Web application

  Using the procedure described in this tip, you can actually perform a user switch within any ABAP program.  Continue Reading

• Dynamic internal table structure and selection

  Many ABAP developers are looking for ways to dynamically populate data from the database into a dynamic work area and dynamic internal table structure.  Continue Reading

• Avoid RFC data loss during refresh

  This process saves you from re-entering data manually in SM59 after a system refresh.  Continue Reading

• Dynamic internal tables

  Here is how to create a dynamic internal table in a program.  Continue Reading

• System/user-specific ActiveX settings

  Whether an input-help is displayed as search help control or an R/3 dialog box is determined by the F4 help system/user-specific ActiveX settings.  Continue Reading

• Quick variant lookup

  Sometimes if a program has a lot of variants, it might be difficult to look them up one by one.  Continue Reading

• Get variant contents at run-time

  This code is helpful when you want to fill your screen values with values selected by a user and stored as a variant.  Continue Reading

• Long text retrieval in HR

  If you need to retrieve long texts for a particular infotype, this is the way to go.  Continue Reading

• Exporting a list to memory

  Here's how to get the output of a standard report into an internal table without Import/Export.  Continue Reading

• Restarting a hanging transport

  If you were doing a transport and had to kill it halfway, you may have a problem. Here's how to restart the transport.  Continue Reading

• Dynamic load for customer tables

  This report uploads the contents to any customer table (Z*) from an excel source file.  Continue Reading

• Modify/insert/delete any table in SE16

  You can do the table manipulations in SE16.  Continue Reading

• Evaluating customer Ok-codes in screen exits

  Customer Ok-codes should always be evaluated during PAI of the main-screen.  Continue Reading

• A better way to unpack SAR or CAR file

  Use the context menu under right button to unpack with SAPCAR.EXE.  Continue Reading

• Unit conversions made easy

  Sometimes there comes a situation where the conversion from one unit to another may become necessary.  Continue Reading

• Hit list defaults

  In drop-down lists or possible entry-lists, the SAP default number of listed hits is set to 500. Go higher and you need this to do this.  Continue Reading

• An introduction to the JCo server

  I am often asked for information as to how to call Java objects from within an ABAP application.  Continue Reading

• Using secondary indexes

  It's a well-known fact that the efficient way of retrieving data from the database tables is by using secondary indexes.  Continue Reading

• A better way to list users currently logged on

  When you want to list the users currently logged onto your SAP Production System, don't use AL08. Here's a better option.  Continue Reading

• Uncompress CAR/SAR files from Windows explorer

  Here's a trick for uncompressing SAR and CAR files on the fly from Windows explorer.  Continue Reading

• Shortcut to downloading a file from SAP

  If you wish to download data or information in SAP from a particular screen or table, this tip is for you.  Continue Reading

• Implementing single sign-on in the J2EE server engine

  As of SAP Web AS 6.20, SAP has implemented a J2EE Engine that allows Java code to be executed directly in the application server.  Continue Reading

• Exclude a table from Client Copy

  If you determine that some tables should not be copied during a client copy, you may exclude them.  Continue Reading

• Hold all batch jobs

  If you are doing maintenance on a system, this tip will help.  Continue Reading

• Multiple selections for screen fields

  Here's a tip if you use dialog programming and you want to use a multiple selection button for one of your screen field.  Continue Reading

• Determine first workday using factory calendar

  SAP has a range of (released) calendar functions to be found in function group 'SCAL'. Here's how to use them.  Continue Reading

• Using connection pooling in JCo

  In the world of database connectivity, creating individual connections to a database system is expensive.  Continue Reading

• User lock code

  If you want to find the locked users in your system, here's how to do it.  Continue Reading

• List executable transactions by user

  Here's how to get a list of all transactions executable by a user.  Continue Reading

• Get the full name of a user

  Sometimes we need to present a welcome message to the users.  Continue Reading

• Exclude/include objects from authority checks - clarification

  Some clarification on the issue of SU24.  Continue Reading

• Move Excel data into an SAP internal table

  By using the standard function ALSM_EXCEL_TO_INTERNAL_TABLE, you can import most Excel documents into an SAP internal table.  Continue Reading

• Changing the title of the standard SAP screen

  Here's how to change the title of the standard SAP screen.  Continue Reading

• Logon load balancing for NAT datacenters

  Have problems of implementing SAP logon load balancing for SAP servers across a firewall and router with NAT implemented?  Continue Reading

• Page numbers in report output lists

  This is an old tip which is used for showing the total page number in all the pages, say in the format Page X of Y.  Continue Reading

• Debugging contents of internal tables

  Here's how to save the contents of an internal table as an MS Excel Worksheet when debugging code in SAP R/3 Enterprise.  Continue Reading

• Automatic transport of variants

  If you always make transport-request between clients to copy variants, use this tip to save time.  Continue Reading

• Show your screen flow to another user

  This tip gives you the opportunity to show your SAP screen flow on the screen of another user.  Continue Reading

• Add icons to report selection screen

  Would you like to have icons appear with parameters or select-options on the selection screen of a report?  Continue Reading

• What is the maximum depth of nested includes?

  What is the maximum length of a path of nested includes in a table or structure?  Continue Reading

• Make each SAP system a different color

  Make each SAP system a different color for easy identification.  Continue Reading

• Debug pop-up screen

  Many times we would like to start debugging from a Pop-up screen, but the editor doesn't allow us to do that.  Continue Reading

• Managing multi-part form data

  When building a Web application for SAP, you may need to allow the user to upload and store a file on a remote file system.  Continue Reading

• Run SAPlogon with different SAPlogon.ini files each time

  Here's how to run SAPlogon so that it reads the configuration from different files each time.  Continue Reading

• A tool for downloading an idoc structure and data to Excel

  Here's a program/tool to download an idoc structure and its data in MS-Excel format.  Continue Reading

• Putting +/- signs in front of numbers on reports

  If you wish to print the sign in front of a number, here is one way to do it.  Continue Reading

• How to hide/show ABAP selection screen fields

  Learn how to hide or show various fields on your SAP screen in this quick and simple tip.  Continue Reading

• Display file attachments

  Do you have any requirements to print the filenames of the attached files from a document? This tip explains how.  Continue Reading

• Debug any background process

  Here is a tip that will solve all your background debugging problems.  Continue Reading

• Use inheritance to extend local classes

  If you use ABAP Objects and writing local classes, you can extend their functionality with inheritance and global classes.  Continue Reading

• Read an area from an Excel sheet and write out a diagnostic

  Here's how to open an Excel file, activate a sheet, read in a rectangular area from it and write out a diagnostic.  Continue Reading

• Send background job failure alerts to users by e-mail

  The following code will scan for any failure in background jobs and send a email to the respective users with the job logs.  Continue Reading

• Go to your URL using ABAP

  Here is an example of how to go directly to your URL from SAP.  Continue Reading

• OLE from SAP

  Here is an example of how to do OLE from SAP.  Continue Reading

• Dynamically count fields in an internal table

  The code in this tip enables you to check how many fields there are in an itab in runtime.  Continue Reading

• Auto refresh a report and get real-time data

  The following example should give an idea about how you can get real-time data every 10 seconds without manual refreshing.  Continue Reading

• Dynamic structure reading

  Here's how to dynamically loop through the fields in a structure in an ABAP program.  Continue Reading

• Restricting use of certain passwords

  Some words, such as company name, are unsuitable as passwords. Here's how to make sure they are not used.  Continue Reading

• Determining TVARV variables in batch jobs

  Have you ever wondered where your TVARV variables are being used in your batch jobs? This tips tells you how to find out!  Continue Reading

• Copy your SAP favorites to another SAP user

  Here's how to Copy your SAP favorites to another SAP user or another server.  Continue Reading

• Checking Input values

  Suppose we need to check the validity of parameter p_carrid, then usually we write a SELECT statement.  Continue Reading

• How to recover a user-lost GUI session

  Sometimes a user loses a session, either because his/her PC froze, lost power, sometimes even timed-out.  Continue Reading

• Timed-out SAP sessions

  Here's a tip on how to eliminate those annoying time-outs that occur when idle.  Continue Reading

• Send output of ABAP query as attachment

  Sometimes you may need to send the output of ABAP Queries as mail attachments.  Continue Reading

• Displaying logos on screen

  You can display logo(s) on your screen using the custom control function. This tip explains how.  Continue Reading

• Looping through a structure

  This tip is an efficient way to get the needed info by period from tables like COSB, COSS etc.  Continue Reading

• Sending SAPscript through e-mail

  How to modify the standard print program RFKORD11, enabling script output send as e-mail.  Continue Reading

• Locking and unlocking of tables

  With this method, any table can be locked/unlocked using these function modules.  Continue Reading

• Find the parameters used in a background job

  Have you ever been asked to look at a faulty report that was executed as a background job with no variant?  Continue Reading

• Icon display on list with description

  It might be difficult for the end user to understand the significance of a particular icon. This tip explains why.  Continue Reading

• Authorization checking in transactions and programs

  SAP programs utilize authorization checks to protect business data and functions against unauthorized access.  Continue Reading

• Benefits of object methods as subroutines

  In version 4.6 there is an advantage to using object methods rather than the classical form subroutines or function modules.  Continue Reading

• The SAP Java Connector (JCo) and SQL

  Wouldn't it be nice if you could use SQL operations on BAPI tables? Here's how to do it!  Continue Reading

• Using FM's to create, change and delete HR Infotypes

  SAP makes maintance of HR infotypes very simple by using three FUNCTION MODULES.  Continue Reading

• New option for SU53 (authorizations)

  Here's a quick and easy method for running an authorization check/SU53 on a particular user.  Continue Reading

• Convert SAPScript or ABAP lists to PDF format

  SAP has provided a standard program in 4.6C which you can use to convert any Spool request or ABAP Lists to a PDF File.  Continue Reading

• Synchronize your SAP account passwords

  This program will copy the password for a nominated user account.  Continue Reading

• Commit and rollback

  Excerpted with permission from Wolfgang G. Propfe's book titled "ABAP with Style."  Continue Reading

• Downloading a table structure into .txt or .xls file

  Sometimes we may need to download the structure of a SAP database table in .txt or .xls format with all details.  Continue Reading

• How to find out User's workstation IP address

  Sometimes administrators need to know the IP address from where the user is logged on.  Continue Reading

• SAP Brbackup using DD option

  Under certain circumstances backups using "dd" in BRBackup utility had shown better results as compared to SAP backups.  Continue Reading

• Fixing missing status objects in sales orders

  Sometimes inconsistency in the status update causes a sales order's status profile to simply not exist on header/item level.  Continue Reading

• Loop and select in one statement

  If you want a select on each record in an internal table, avoid doing a loop with a single select using this statment.  Continue Reading

• Refresh Report list by one command without going back Report selection criteria

  We could have requirement to refresh report list without going back to selection parameters of report.  Continue Reading

• Printing logos using Smartforms

  To print logos using the SMARTFORMS, there are a few steps you need to take. This tip walks through the process.  Continue Reading

• Search for specific text(s)

  The standard program RPR_ABAP_SOURCE_SCAN can be used to search ABAP program code/screen logic for specific texts (strings.)  Continue Reading

• Read TAB delimited text file in ABAP

  Here's a tip showing how to do batch input with an Excel file into SAP.  Continue Reading

• Loading an internal table using dynamic data names

  Sometimes we have different variables with homogenius contentthat should be in an internal table. Here's how to do it.  Continue Reading

• User-specified dynamic sorting

  This code allows the user to numerically specify the sort order of a report from the selection screen.  Continue Reading

• Creating Purchase Order through BAPI using VB

  The following code gives the code for creating Purchase Order in the SAP using BAPI_PO_CREATE RFC Function from Visual Basic.  Continue Reading

• How to maintain SAP TABLES

  Sometimes it becomes necessary to update that table without writing any report program. Here's how to do it!  Continue Reading

• Hardcoding

  Hardcoding is considered a shortcut, but it comes with a price tag. This excerpt from Wolfgang Propfe's book explains more.  Continue Reading

• Printing bold, italic, small and big letter from SAP

  Here is an example of how to print bold, italic, small and big letter from SAP.  Continue Reading

• Changing character format from a ABAP report

  You can change the font, size or color of the output characters from a normal ABAP report program.  Continue Reading

• Printing barcodes from an ABAP report program without SAPscript

  Printing barcodes from a SAP script is quite easy, but how can we print it with a WRITE statement? Find out here!  Continue Reading

• How to check if your Application Server need more physical memory

  Check if your application server is hitting the performance-ceiling.  Continue Reading

• Report output formatting tips using the write statement

  This tip outlines a couple of methods that can be used to display your report output.  Continue Reading

• Saving passwords for SAP shortcuts

  Passwords are not saved in shortcuts created within SAPGUI. Here's how to get it to work!  Continue Reading