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