Tips

Tips

• Determine when users last logged on

  Using this tip you can list users sorted by last logon date -- so you can see who still has *never* logged on, and who has not logged on in over x days or months.  Continue Reading

• Downloading Excel files

  Learn how to download a tab delimited text file with new versions of Excel.  Continue Reading

• Flat files vs. EDI

  ITKnowledge Exchange member "sillyITgirl" had a question about the difference between EDI files and flat files and fellow techies helped out. Here is a portion of the conversation.  Continue Reading

• Produce the structure of an internal table

  This tip is useful for senior ABAP developers looking to find the structure of an internal table.  Continue Reading

• Determining who executed a transport

  Have you ever wanted to produce a log of all administrator actions to determine who executed a transport? This tip will save you time and effort with this common problem.  Continue Reading

• Listing the files in the specific application server directory

  Use this tip to retrieve all files in the application server directory of your SAP system.  Continue Reading

• Display all users logged onto a server

  Use this tip to reveal a list of all users on a system.  Continue Reading

• How to generate a random number for a given number range

  Use a function module to find a random number within a given range. Read this tip to find out more.  Continue Reading

• How to pause the ABAP program execution for given number of seconds

  If you're looking for a way to pause the ABAP program, try this method.  Continue Reading

• Mass printer host change

  With this tip you can set or change the spool printing host.  Continue Reading

• Use a user-exit to download standard queries

  Learn how to use a user-exit to download the results of standard queries to the application server.  Continue Reading

• Finding the view name of a table

  Looking for the view name of the table? This tip will show you how to get the view name information from the table name.  Continue Reading

• Display vendor names with all combinations of a parameter

  This tip using a dynamic where clause will reveal a list of all vendor names with all combinations of a parameter.  Continue Reading

• Control output determination settings

  With this helpful tip you can use transaction NACE to control the output determination settings for all applications.  Continue Reading

• Avoid password change request

  Have you wanted to avoid changing a password after changing it?  Continue Reading

• List of includes in a program

  Have you ever wanted to retrieve the includes used in a SAP program? This useful tip will show you how.  Continue Reading

• Downloading to Excel in a background task

  Read advice on how develop a program to download table entries into an Excel file in SAP.  Continue Reading

• SAP authorizations

  Learn SAP advice on authorizations and transaction codes from ITKnowledge Exchange.  Continue Reading

• A new way to debug the SAP script

  Do you ever find yourself working on transaction codes that have multiple output forms and need to make changes to multiple forms simultaneously? Try these suggestions.  Continue Reading

• Debug screen timeout

  This is a helpful tip for changing the hold time parameters of your workprocessor in debug mode. It is also applicable for multiple users who are debugging at the same time.  Continue Reading

• Finding SAP table names and descriptions

  Looking for a quick way to generate an SAP tables list plus descriptions? Read on for tips from our expert.  Continue Reading

• SAP HR Learning Guide

  This SearchSAP.com learning guide will help you understand basic mySAP HR concepts and terminology.  Continue Reading

• Finding a transaction code in a table

  Forget the transaction code or the navigation for a system? This tip will help you find it in a table.  Continue Reading

• Online reorganization with BR

  Have you ever wanted to reorganize tables online while running SAP? This tip will teach you how, using Oracle 9.2 and SAP's BR*Tools 6.40.  Continue Reading

• How to use negative numbers in maintenance views

  When you create a maintenance view for a dictionary table, by default numeric fields can not hold negative values. Learn how to circumvent this problem.  Continue Reading

• SAP's forward navigation unleashed

  Learn how SAP has implemented forward navigation so that you can implement the same in your own ABAP programs.  Continue Reading

• SAP XI Learning Guide

  This SearchSAP.com learning guide will provide you with all the information you need to gain a better understanding of SAP Exchange Infrastructure.  Continue Reading

• Extract code from Smart Forms

  Have you ever tried to find coding within a Smart Form? This program will extract all the ABAP code to output the code for audit purposes.  Continue Reading

• Add pattern for use in ABAP editor

  This tip will teach you how to include your own pattern -- even transport the pattern -- in the ABAP Editor program.  Continue Reading

• Collect SAPGUI patch numbers

  Learn how to collect SAPGUI patch numbers and other logon information like hostname, userid, O/S, IP address and put it in a custom table.  Continue Reading

• Test home ABAP program

  This tip will help you test a home ABAP program without access key. NOTE- not for production!  Continue Reading

• Dynamic parallel processing in SAP Workflow

  This tip will help you with dynamic parallel processing in SAP Workflow.  Continue Reading

• Getting table information within a program

  Need to get table information within a program? This tip can help.  Continue Reading

• ABAP Geek 5 - In memory of ...

  This tip describes which types of memory an ABAP program can access and what kind of data can be addressed there.  Continue Reading

• ABAP Geek 4 -- The mystery of SUBMIT unveiled

  This tip is the fourth in the 'ABAP Geek' series of weblogs from SDN. Learn more about program execution here.  Continue Reading

• OSS Note Assistant

  If you are involved in OSS Note administration, this tip explains the advantages of using the OSS Note Assistant.  Continue Reading

• Tables of Transport request

  This may be helpful when you forget your request number or want to see the technical detail.  Continue Reading

• ABAP Geek 3 -- About transactions

  Horst Keller of SAP examines the details of ABAP program executions and transactions.  Continue Reading

• Determine the client where a transport request has been imported

  This tip will show you how to find the clients where a particular transport request has been imported.  Continue Reading

• Transaction analysis for ABAP, database, and SAP R/3

  With this tip, you can analyze transaction performance in ABAP, Database and SAP R/3.  Continue Reading

• Exclude user assignments when transporting roles/activity groups

  This tip will show you how to prevent user assignments from being imported into a target system when you perform a transport of roles/activity groups.  Continue Reading

• ABAP Geek 2 -- ABAP program types

  The most important ABAP program attribute is the program type. This article discusses the program type in detail.  Continue Reading

• More on ABAP Objects instanceOf commands

  Holger Janz of SAP offers advice and code samples related to the ABAP Objects instanceOf-operator command.  Continue Reading

• ABAP Geek 1 - ABAP program attributes

  An ABAP program is more than source code. This first installment in a tip series for the ABAP geek delves into some important facts about ABAP programming attributes.  Continue Reading

• Suspending batch jobs

  This tip provides the programs to use to suspend all batch jobs from running when you don't want them to.  Continue Reading

• 4.6 C IDES installation procedure

  This tip presents the 4.6 C IDES installation procedure.  Continue Reading

• Working with ABAP

  Learn what aspects you need to consider when implementing with ABAP with SAP.  Continue Reading

• A quick guide to ROI with mySAP CRM

  CIOs share tips on how to make sure mySAP CRM produces for you.  Continue Reading

• Icons on ALV grid

  This tip presents two ways for an ALV grid to display icons in a column.  Continue Reading

• Retrieving the user IP address and logon ID

  In order to retrieve the end users terminal ID and IP address, the function module TERMINAL_ID_GET can be used. This module will retrieve both the IP address and the logon ID.  Continue Reading

• Changing the deadline attributes of a work item

  This tip provides the function module for changing the attributes of the deadline monitoring for a particular work item.  Continue Reading

• Update queue issue

  This tip is a discussion thread from SearchSAP's new SAP FAQ lists. This thread discusses issues when updating the queue.  Continue Reading

• ABAP Objects instanceOf command

  This code sample by Charles Folwell creates an instanceOf command in ABAP Objects.  Continue Reading

• Retrieving the current contents of the selection screen

  This tip from SearchSAP.com member Ramakrishna Chary explains how to retrieve the current contents of the selection screen.  Continue Reading

• Annotations in Java

  Need an excellent overview of annotations in Java? Try this tip.  Continue Reading

• An introduction to SAP Basis administration: Smart Forms

  In this tip, SAP Education Consultant Marilyn Pratt presents an introduction to Smart Forms.  Continue Reading

• Wizard builder

  This tip provides the code for an easy transaction that allows you to create a wizard.  Continue Reading

• RE: Link to URL

  This is an alternative to the Link to URL tip.  Continue Reading

• Are ABAP Objects the only way to use Web Dynpro?

  A reader responds to the idea that ABAP objects are the only way into Web Dynpro. They're not the only way, but they might be the best way.  Continue Reading

• Getting around RFC_READ_TABLE limitations

  This tip provides code to help developers get around RFC_READ_TABLE limitations.  Continue Reading

• Link to URL

  We can give a link to any of the URL's through ABAP Programming.  Continue Reading

• SNOTE -- Cool transaction to apply OSS notes

  Use the transaction SNOTE to apply OSS notes, we don't need access key to apply oss note and it checks if the note is valid for the current version.  Continue Reading

• Did ABAP Objects fail as a whole?

  ABAP Objects did not 'fail,' says the author of this article. To say so is to misunderstand the purpose of this SAP technology.  Continue Reading

• My version of 'XI 3.0 for Dummies'

  This tip presents an example of 'Process Integration' based on SAP Exchange Infrastructure. For well versed developers, it's nothing but a standard NameOut and NameIn example.  Continue Reading

• Week difference

  This tip provides a function module that helps you calculate the number of weeks between two dates.  Continue Reading

• A note on wsdl and xsd imports

  This tip is printed with the permission of The SAP Developer Network.  Continue Reading

• ALE interface for BAPI

  This tip provides the transaction code to generate the required function modules and message types, IDoc type, etc.  Continue Reading

• Preventing multiple dialog user logons

  Read this tip to learn how to block a user from maintaining multiple logins within the same client using the same user ID.  Continue Reading

• Custom login screen info

  Use this tip to add a custom message on the login screen.  Continue Reading

• Tracking database growth

  A nice little sqlplus script that can extract the database growth by month over a two-year period from an SAP/Oracle database.  Continue Reading

• How to handle time zones in ABAP

  Time zone management can be tough when you've got a project spanning multiple zones. This tip will help.  Continue Reading

• Non-expiring password

  If you want, you can make it so some users don't have to change their password by following these steps.  Continue Reading

• Generating a worldwide unique ID

  How to create a unique ID for identifying objects.  Continue Reading

• Important function modules regarding workflow

  Tips for important function modules regarding workflow.  Continue Reading

• How to find column names in a statically defined internal table

  Here is the sample code with which you can find out the fields and other properties of your statically defined internal table dynamically.  Continue Reading

• Business add-in (enhancement)

  This tip provides the definition of a business add-in, SAP's new enhancement concept.  Continue Reading

• Memory-buffering in selection screen

  When dealing with a very big selection screen, which contains check boxes, radio buttons and parameters, tracking the selection screen values for each execution is difficult.  Continue Reading

• Pushbuttons with selection screens

  Creating pushbuttons with tool tips on a selection screen or assign a tooltip to the pushbuttons created with SLECTION-SCREEN FUCTIONKEY in the GUI status of a selection screen.  Continue Reading

• Tool to check ABAP Code

  The SCI tool makes it so that any developer can easily check ABAP code in SAP.  Continue Reading

• Introduction to the SAP XI (Exchange Infrastructure) - part one

  This is the first in a two part series on the SAP XI (Exchange Infrastructure). The basic conceptual framework of SAP XI is covered here.  Continue Reading

• Free Book Excerpt: Mastering the SAP Business Information Warehouse (BW)

  Download this free book chapter and read how you can strategically plan for your company's future by mastering the SAP Business Information Warehouse.  Continue Reading

• Free Book Excerpt -- Business Scenario and SAP BW

  -  Continue Reading

• Uploading transport files from Windows to UNIX on IBM

  How to upload transport files and support packages from Windows to UNIX System Services on IBM mainframe.  Continue Reading

• Modify search help behavior at runtime

  Modify search help behavior at runtime for transporting different fields or changing the SELOPT structure without writing field exits with this function module.  Continue Reading

• Find out what roles have restricted company codes and values

  Do you need to find out what roles you have set up with restricted company code values for specific authorization objects? Read this tip to find out how.  Continue Reading

• 20 Performance hints for OPEN-SQL

  20 performance hints for OPEN-SQL  Continue Reading

• How to locate details of a program (Environmental Analysis)

  Use these steps to locate the details of a program (Environmental Analysis).  Continue Reading

• Customizing the SAP text

  Here are some simple steps to follow if you want to customize the SAP text in your computer.  Continue Reading

• Validation using field exits

  If for a particular transaction you want the error message, then its the time to go for FIELD EXIT.  Continue Reading

• Activity value codes for authorization

  A complete list of activity values and their meanings can be found in SAP Table TACT.  Continue Reading

• Netweaver Web Application Server administration

  SAP Netweaver is based on three integration layers and an application platform. The application platform,which is provided through the SAP Web Application Server (Web AS),is the foundation of Netweaver and is the application platform for the mySAP ...  Continue Reading

• Errors when using large range table

  It is important to understand what happens when you use IN operator to avoid database errors.  Continue Reading

• Notify users to exit transaction from a batch job

  The following subroutine will determine what users are currently logged in transaction ZTRANS and then notify them to signed off by means of a popup window.  Continue Reading

• Learning how to create a BDC program

  For a BDC upload you need to write a program which created BDC sessions.  Continue Reading

• Configuring the system for extended IDocs

  Configuration settings for outbound process and inbound process.  Continue Reading

• How to copy tables to another system using R3trans

  Use these steps to copy tables to another system with R3trans.  Continue Reading

• Upload & download file from app.

  This tip will show you how to upload and download files from an application server.  Continue Reading

• View files on application servers

  This tips tells you how to use transaction code AL11.  Continue Reading

• Download internal table data into Excel

  This tip will teach you how to download an internal table data into Excel.  Continue Reading

• Accessibility for icons in ALV Grid Cell

  This tip will help you with development for handicap accessibility. Specifically,this tip show you how to force tooltip to appear in Web GUI.  Continue Reading