Tips

Tips

• BW debug user

  If you need to debug update, transfer rules, uploads and other BW stuff you can setup an BW user for debugging. Learn more in this tip.  Continue Reading

• SAP transaction log trace

  Use this tip if you want to view the users activity using sql command.  Continue Reading

• Set a function code by program and not by user

  To set a function code by program (without user action), you can use the function module SAPGUI_SET_FUNCTIONCODE. Learn more in this tip.  Continue Reading

• Assigning global company code to company code

  Sometimes during your IDOC/BAPI communication you will get error "No global company code is assigned to the company code. Fix it with this tip.  Continue Reading

• Create data for flight data model

  Learn how to load data into sample flight model tables in this tip.  Continue Reading

• MM Purchasing reports in ALV

  Learn how to access standard MM Purchasing reports (eg. ME2L, ME2M) in ALV instead of in the "multi-line" report.  Continue Reading

• Sending a mail on triggering a particular event (Workflow related)

  This tip will show you how to send a mail in Workflow upon triggering a particular event.  Continue Reading

• Check for parameters in function module calls

  This tip tells you how to check for the parameters in function module calls.  Continue Reading

• Create custom report for users having access to critical combination of transactions

  This tip will teach you how to create a custom report for users having access to critical combination of transactions  Continue Reading

• Adjusting Variants due to field changes

  Learn how to retrieve and save variants in new format.  Continue Reading

• Essential coaching skills for SAP consultants - part one

  This series addresses what you can do to boost your marketability as a SAP consultant.  Continue Reading

• Icon in the selection screen

  This tip will show you how to put an icon on your selection screen.  Continue Reading

• Add information to your logon screen

  Follow these steps to add information to your logon screen.  Continue Reading

• Establishing security parameters

  If you need to increase the security in SAP, you have to set the following parameter in transaction RZ10.  Continue Reading

• Finding user exits

  Need to find user exits module-wise?  Continue Reading

• Printing to PDF file

  Want to print to a PDF file?  Continue Reading

• Spool administration

  Here are step-by-step instructions for managing your spool requests.  Continue Reading

• Unlocking form PE51

  When a form in PE51 is locked by a person, then only that person is able to change the form.  Continue Reading

• Clearing the parameter screen

  When I used ABAP for interactive data entry, I had to leave then rerun the program to clear the parameters screen.  Continue Reading

• Inserting photos into SAPscripts

  Here is a simple way to display the photos of the employees in SAPscript forms.  Continue Reading

• Retrieve application server file names in F4 help

  You can retrieve application server file names in the F4 help function by submitting program rs_get_f4_dir_from_applserv.  Continue Reading

• What does this JCO Exception mean?

  This tip presents information on a specific JCO connector exception that seems to confuse many people.  Continue Reading

• View locked transactions

  As you know, you can lock/unlock transaction codes via SM01. But how do you go about viewing the transactions that are locked in the system?  Continue Reading

• Background debugging

  The best way to debug programs in the background is via transaction SM50. Here's how to use it.  Continue Reading

• Force a debug break-point

  Sometimes you set a break-point in program, but for some reason nothing happened.  Continue Reading

• Creating a strong business personal foundation

  Learn how habits and standards we live by influence our effectiveness at work.  Continue Reading

• Synchronizing SAP with an external user registry

  The ever-growing exposure of SAP to the Internet means that more and more BASIS administrators are taking an active role in extranet security.  Continue Reading

• Save content of internal tables in Excel format during debugging

  Starting in R/3 release 4.7, it is possible to save the content of an internal table during debugging.  Continue Reading

• SAP Basis transport guide

  You may be wondering if you can transport certain SAP objects, and if possible, how? Here are tips for diferent objects.  Continue Reading

• Display Material Master in MD04

  Here is the easiest and fastest way to display Material Master data.  Continue Reading

• Access to SE16 in production

  If you must give direct access to tables in production, heed this advice.  Continue Reading

• Opening workbooks with BEx analyzer

  How to open workbooks with BEx analyzer.  Continue Reading

• Finding transaction codes

  Perhaps you know some keywords about a transaction, but not the transaction code?  Continue Reading

• Retrieving missing data from user exit functions

  Have you been in a user exit function and the data you need wasn't passed on to you? You can easily grab the data from the memory stack using this little trick.  Continue Reading

• BDC session submission/triggering in background

  This 'Submit' can be used to submit a BDC session in background and trigger it automatically to be processed.  Continue Reading

• Quick search for authority checks

  Here is a quick way to check a program for authority check statements.  Continue Reading

• Translation in SAPscript

  Here is how to call ABAP programs to translate headings and similar.  Continue Reading

• Debugging a background job

  How to debug background jobs? Here's how!  Continue Reading

• Suppressing messages using the call function

  You can suppress information messages if you call a function module by adding this parameter.  Continue Reading

• Why build a custom JCo repository?

  What is a custom repository and why should I care about it? Find out here!  Continue Reading

• Simple report variant viewer

  Sometimes it is nice to do a quick analysis of the defined variants for an arbitrary ABAP report.  Continue Reading

• Get SAPScript output as PDF and launch Acrobat inside SAPGUI itself

  A very common requirement for programmers writing ABAP code for printing using SAPScript Forms is to redirect output to a PDF (Adobe Acrobat) file.  Continue Reading

• Log out without confirmation

  Close all active sessions at once and log out at the same time.  Continue Reading

• Simplify your searches

  Are you tired of searching for all those hidden asterisks? Here's a better way!  Continue Reading

• Assigning Tcodes to new roles from a text file

  Creating a new role from scratch can be tedious and SAP hasn't provided a user friendly way of assigning a large number of Tcodes to a new role.  Continue Reading

• Creating variants for default values

  You can automatically use an existing variant to fill your report parameters and selections during the event initialization.  Continue Reading

• Measuring the value of HR solutions

  Are you looking to calculate a ROI on an investment in HR systems? Our ROI expert, Tom Pisello, is here to help.  Continue Reading

• Announcing the new MiniSAP 6.20

  With the introduction of SAP MiniBasis, all of us diehard SAP developers could finally build and test code from a local SAP instance.  Continue Reading

• Dynamically assign search help-functionality to a field

  You can dynamically assign a Search Help name to a field.  Continue Reading

• Getting status texts for transaction CO03/COOIS

  You can get the status of transaction CO03 or COOIS for a given production order. Here's how!  Continue Reading

• Tracking the maintenance view transaction

  Sometimes you get a maintenance view (SE11) and you want to know which transaction called it.  Continue Reading

• Show nesting in ABAP code

  Copy and paste the attached function module-code to create a utility to show you how your ABAP is nested.  Continue Reading

• Find out when the SAP system restarted

  If you need to know how long your SAP system has been running since the last restart, there are two possibilities.  Continue Reading

• Scramble sensitive HR data in test-environments

  In the event of a restore of production data into your Test / QA environment, you need scramble your sensitive HR data.  Continue Reading

• Determine if a system is in development, test or production mode

  If you need to determine if a system is in development, test or production mode, you can check the category field in table T000 to base your logic.  Continue Reading

• Personalized system message with icons

  Sometimes an icon or a picture could make your system messages more effective.  Continue Reading

• Dos and don'ts of ROI/TCO analysis

  ROI expert, Scott McCready, explains why learning to stop at a child's lemonade stand will teach you the same lessons you need to understand and appreciate ROI and TCO analysis.  Continue Reading

• Deleting BDC sessions

  There are two simple steps to deleting specific BDC session(s) created in a program.  Continue Reading

• How to modify multiple items in the SAP menu

  How do you add/remove/modify several items in the SAP menu for particular/all users?  Continue Reading

• Editing ABAP workbench objects without developer key

  Need to edit an ABAP Workbench Object in a system where you do not have a Developer Key?  Continue Reading

• Get variables/internal tables from a report while in a function

  You can get variables or internal tables of a report when you are in a function. This can be very useful for user exits.  Continue Reading

• Managing critical transport objects

  As of R/3 Release 4.5 you can define an authorization profile as a critical object and keep it from being transported to another system.  Continue Reading

• Taking instances out of the TMS landscape

  An instance cannot be taken out of the TMS landscape if it has been copied over by another instance. Here is how to do it after the fact.  Continue Reading

• Select a particular line in ALV

  To select a particular line in ALV (class method) this piece of code will help.  Continue Reading

• Update USR05 parameters

  Ever had the need to change every users' GJR parameter to the new year? Rather than go through all users one at a time, use this code.  Continue Reading

• Prevent multiple program submissions

  You may want to prevent users to submit the same program twice for performance reasons. Here is a code snippet to prevent this.  Continue Reading

• Use field symbols for better performance in internal tables

  Do you want to squeeze more performance out of your Internal Table processing? Here's how!  Continue Reading

• List users by department/cost center

  To get a list of users by department or cost center, follow these steps.  Continue Reading

• Building an SAP interface lookup tool with JCo

  Have you ever wanted to do a quick lookup on an RFC or BAPI interface in SAP without going through the SAP GUI? Here's how!  Continue Reading

• Learn to use the ABAP code inspector

  The static code inspector (transaction SCI) is an enhancement SAP included for the Web Application Server based releases of R/3. Here's information on how to use it!  Continue Reading

• Limit your Max Extent size

  Want to limit your Max Extent size? Here's how!  Continue Reading

• Create dynamic internal tables

  You can create a dynamic table using this piece of code.  Continue Reading

• ABAP performance tip

  Here's a method for cutting down runtime of ABAP programs with more efficient use of nested loops.  Continue Reading

• Quick VBFA-table access

  Get a VBFA table shortlist of all the relating document numbers from supplying Order, Delivery, Invoice etc.  Continue Reading

• Installing LSMW onto mini Basis

  Here are the details on how to install LSMW onto a mini Basis system, and hopefully avoid any heartache.  Continue Reading

• Maintain local work directory

  How to change the local Work Directory of SAP GUI.  Continue Reading

• 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

• Plan for the desktop-to-laptop migration wave

  As laptops replace more PCs, companies must have a support program. This tip delves into various issues a company must consider when switching to laptops.  Continue Reading

• Spell checker for SAP GUI fields

  This tip works like the MS Word spell checker.  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

• Local data field history

  This will help you quickly re-enter previously used data in fields by keeping a local history for most of the fields that you usually use.  Continue Reading

• Logging on to SAPNet directly

  You can logon to SAPNet -R/3 FrontEnd without using transaction OSS1. This way you don't have to open an SAP session just to log on to SAPNet.  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

• Freeze transport system

  You can freeze transports by simply creating a file in the bin directory called T_OFF.ALL.  Continue Reading

• View active internal tables during debugging

  There are times when we need a list of active internal tables while we are debugging a standard SAP program, or any ABAP code for that matter.  Continue Reading

• Mass transport imports

  Occassionally your developers will want you to import a lot of transports back into your QA.  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

• Avoiding the yellow lights when adding transactions via PFCG

  Are you tired of those same authorization objects showing up as yellow lights every time you enter a new transaction code?  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 name determination of an ODS table

  Here's a way to determine the technical name of any table of an ODS Object.  Continue Reading

• Program generation from SHDB

  Sometimes you're not permitted to create a program in a client where all data is present. Here's how to get around it.  Continue Reading

• Dynamic load for customer tables

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

• Client BEx version for BW

  You can view the BEx details on all clients who ever connects to a BW system by using viewing this table.  Continue Reading