SAP who has access?

To quickly check who has access to a particular object in an SAP system try executing program RSUSR002. I needed to find out who has access to transaction SMQ1 and managed to accomplish that by filling in the following parameters in the first screen:
Continue Reading →

ABAP cancelling an SD Billing Document

If you have access to a billing document number try executing the following function: DATA: l_rtrn TYPE bapireturn1 OCCURS 0. DATA: l_succ TYPE bapivbrksuccess OCCURS 0. CALL FUNCTION 'BAPI_BILLINGDOC_CANCEL1' EXPORTING billingdocument = * testrun = * no_commit = billingdate
Continue Reading →

ABAP: execute OS level command

There are many things that one can do to execute a command in an Operating System from an ABAP report.  I’ll explain one method that one can take to accomplish this. Using transactions SM49 and SM69 set up and test a new OS command that you wish to execute.  For the purposes of
Continue Reading →

ABAP: load file using pop-up window

When writing a program the simplest way to load a file from your client PC in to the server SAP syste is through a use of a regular text box.  But if you want to get a little fancier try using the following function: data: l_select TYPE sapb-sappfad. CALL FUNCTION 'WS_FILENAME_GE
Continue Reading →

FM: SAPGUI_PROGRESS_INDICATOR

A usefull little function that will allow you to display a status update on the bottom left corner of the screen when running your reports. call function 'SAPGUI_PROGRESS_INDICATOR' EXPORTING percentage = 0 text = STATUS_TEXT. Note: anything lower then 0 will be rounded up t
Continue Reading →

When was the last System Refresh done in an SAP system?

To quickly check when your DEV/QA system was refreshed from a production box perform the following steps: Execute the transaction SCCL Fill in the Source Clinet filed [ie: 001] Select <Goto> <Log display> from the main menu You should see a screen with a list of dates of w
Continue Reading →

The sales order … is currently being processed by user …

An inbound IDOC was failing due to the error [described in the title].  Some research resulted in the following results: TR: SM12 displayed a list of locked elements in the system. TR: SM04 displayed a list of logged in users in the local system. TR: SM08 displayed a list of logged in
Continue Reading →

Get a list of all transactino in SAP

Transactions, transactions, transactions. One of many things that make programming in SAP so much more complicated. Quite often I find my self in a situation when I need to do a particular task and have no idea which transaction to use. Trivially one could ask a fellow co worker who&#
Continue Reading →

Usful SAP system tables.

ADCP Person/Address assignment (central address administration) ADIRACCESS Table to store keys for TADIR objects ADR2 Telephone numbers (central address admin.) ADRP Persons (central address administration) APQD DATA DEFINITION Queue APQI Queue info definition D010SINF ABAP- Informati
Continue Reading →

Connect to SAP through Java

This example will focus on exploring the ability to connect to an SAP application through the use of a remote Java client. The internal SAP arcitecture is designed in such a way that it does not matter if you connect through C, perl, .NET or Java the results will always be the same &#
Continue Reading →