Tuesday, 27 October 2009

To find a transport request

To find a transport request:
  • Run transaction SE16
  • Enter table name E070V

Definition of SAPS

The SAP Application Performance Standard (SAPS) is a hardware independent unit, which describes the performance of a system configuration in the SAP environment. It is derived from the SD Standard Application benchmark, where 100 SAPS are defined as 2,000 fully business processed order line items per hour.

In technical terms, this throughput is achieved by processing 6,000 dialog steps (screen changes), 2,000 postings per hour in the SD benchmark, or 2,400 SAP transactions.

Fully business processed in the SD Standard Application Benchmark means the full business process of an order line item: creating the order, creating a delivery note for this order, displaying the order, changing the delivery, posting a goods issue, listing orders, and creating an invoice.

(From here)

Thursday, 22 October 2009

Oracle job scheduler

To view the current schedules:
  • select * dba_scheduler_schedules;

Also:

  • select * from dba_scheduler_jobs;
To view job run histories:
  • select * from dba_scheduler_job_log;
See also SAP note 974781

Make the cancel print button active

By default the Cancel button in the print dialog is greyed out:
  • Run regedit
  • Go to: HKEY_CURRENT_USER\Software\SAP\SAPlpd\SAPLPD
  • Add character string "EnableCancelButton"
  • Enter value '1'
Change takes effect immediately


See SAP note 1449136

Creating and viewing memory snapshots in SAP

  • Run transaction S_MEMORY_INSPECTOR


  • To create a memory snapshot, enter /hmusa into the transaction field
  • Message shown in status bar:


Compare SAP config between two systems

  • Run transaction SCU0


Choose SAP Refernce IMG
Click Create


Choose Select activites
Click the green tick



Choose an area and click the green tick


Enter a description and choose and R/3 (RFC) connection
Click either Total comparison or Total comparison in background

Note: This process uses a lot of session memory, particularly from the extended memory area whether run in foregoround or background.

Running SQL statements in SAP (Oracle and DB2)

Oracle


Free-form statements:

  • SE38
  • Program name RSORADJV
  • Execute

Using drop down menu options:
  • SE38
  • Program name RSORAVDV
  • Execute



DB2

  • Run transaction ST04
  • Expand Diagnostics
  • Double-click SQL Command Line