Tips
Tips
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Parameters for establishing SAP password policies
Here are some tips on how to provide a SAP user ID and password to an SAP system. Continue Reading
-
Select directories and files using Object Methods
The following code uses SAP Objects to select directories and files. Continue Reading
-
RSUSR003 For Checking SAP* and DDIC in all clients + login params.
Not a tip, more of an interesting report. Continue Reading
-
See all config. tables relating to a company code, sales org, division...
A handy transaction for high-level checks of the configuration associated with certain objects like company codes or plants. Continue Reading
-
Communicating in SAP Web Services through XML markup tags and SAP SOAP
Part 3 in Jeff Marin's odyssey into SAP and Web Services... Continue Reading
-
What does the "R" stand for in SAP R/2 and R/3?
Trivia time: What does the "R" stand for in SAP R/3 Continue Reading
-
Add PATTERN for use in ABAP editor
This tip shows you how to add a PATTERN for use in the ABAP editor. Continue Reading
-
Convert time between timezones
This is shows how to complete the conversion of time between different timezones. Continue Reading
-
Writing fixed length text files
This tip shows you how to write fixed length text files. Continue Reading
-
Reporting long text
A simple way to locate the long text object you need. Continue Reading
-
Deleting unnecessary work items
The inboxes of users are often full of work items which are no longer required. Here is a tip for deleting items. Continue Reading
-
Limiting number of sessions in SAP
This tip reveals a parameter one can use to set the maximum number of sessions required. Continue Reading
-
BAPIs (RFCs) vs. IDOCs
A question often raised in the discussion forums is: "Shall I use BAPIs (RFCs) or IDOCs to interface to SAP?" Continue Reading
-
Avoid hard-coding
Avoid hardcoding without cluttering up the selection screen. Continue Reading
-
Finding the transaction code for populating a table
Finding the transaction code for populating a table. Continue Reading
-
Creating purchase orders using SAP Java Connector (JCo)
This application uses classes in JCo to call a BAPI to create purchase order in the SAP system. Continue Reading
-
ABAP/Select options
This ABAP code snippet will allow you to hide some of the select options. Continue Reading
-
Service contract technical objects
This tip tells you where the technical objects for a Service Contract (or sales order) are stored. Continue Reading
-
Recursive perform statement sample
This source is the example of Recursive Perform Statement. Continue Reading
-
Print PDF-files from SAP
Print any existing PDF-file directly from SAP (3.1I) using 'External Commands' (SM49/SM69) on Windows NT server. Continue Reading
-
Error while testing a function module
When you try to test a function module via SE37 you get runtime error, but it works fine when incorporated in a program. Why? Continue Reading
-
Creating dictionary tables and structures from an ABAP program
Do you need to create or modify tables or structures in the Workbench from an ABAP program? Continue Reading
-
Change entries in SE16 in debug mode
There is a way to change entries of a table with SE16 even if you don't have the authorization. Here's how! Continue Reading
-
SAP Web Services tutorial for beginners
A summary of Web services and how they relate to SAP Continue Reading
-
Authorization groups
Learn the basics of authorization groups in this extensive tip. Continue Reading
-
Locking/unlocking users without affecting users locked by the system
How to locking/unlock users without affecting users locked by the system. Continue Reading
-
Saving report to a PDF file
Printing Invoices, Purchase orders and Checks has always been an painful task in SAP, especially If you are using SAP forms. Continue Reading
-
Reloading archived SD/MM documents safely
So you started archiving and the next week you get calls from users who can't find sales orders. Continue Reading
-
Get the first date of a fiscal period
We can find the first and last dates of the current Fiscal Period by using two funtional modules. Continue Reading
-
Enable a particular user to multi login
How to enable a particular user to multi login. Continue Reading
-
Activity value field displayed by code instead of statement
A compilation of Activity value codes. Continue Reading
-
Fixed point arithmetic/SAPScript
In 4.6c when you create SAPScript programs, SAP does not set the "Fixed Point Arithmetic" Flag automatically. Continue Reading
-
Post a vendor invoice referencing an existing invoice
Using Transaction FBR2, an Accounts Payable user can reference an invoice accounting document number. Continue Reading
-
Users with initial password
Do you want to see a list of all users with initial password or a list of users who haven't use SAP for the last year? Continue Reading
-
Zoom in your ABAP editor
You can zoom in the Abap editor from release 4.6. Here's how! Continue Reading