Monday, October 10, 2005

OCS_GET_INSTALLED_COMPS - run in SM37, select a predefined RFC destination, and look at the table of results.

This'll tell you all the version numbers of the installed components in the SAP system.

(0) comments

Wednesday, September 28, 2005

I tried setting up a job to do this, using a call to the OS like this:

"tp import all pf="

It's really not that nice, and caused more problems than it was worth.

Then I found a standard ABAP that does it properly:


Just schedule that every 15 minutes or so.

(0) comments

Monday, May 23, 2005

It's not easy finding your SAP version these days, there are kernel versions, application versions, add-ins versions etc.

SAP R3 4.7 Enterprise comes with two Extension Sets 110 and 200.

To check which one you have, the only way I've discovered so far is from these notes.

538887: SAP R/3 Enterprise 47x110: Software Architecture/Maintenance Tracks
658351: SAP R/3 Enterprise 47x200: Software Architecture/Maintenance Tracks

So - for example, the second note says

"SAP R/3 Enterprise Extension Set 2.00 consists of the following software components EA-HR 200, EA-APPL 200, EA-IPPE 200, EA-RETAIL 200, EA-GLTRADE 200, EA-PS 200, EA-FINSERV 200, EA-DFPS 200 and ABA_PLUS 100."

and checking in System - Status, I discover that I have all these components, so am on Extension set 2 at this site.

(route to find this was http://service.sap.com/patches - then My Company's Application Components. SAP R/3 Enterprise)

(1) comments

Monday, March 14, 2005

With newer SAP and Oracle, svrmgrl has gone - RIP.

To do a select from the underlying tables, you need to use sqlplus.

sqlplus "/as sysdba"

SQL>Select * from sapr3.t000;

might work, but since R3 version 6.1 the schema owner is supposed to have changed from sapr3 to sap

So on my system I tried this:

SQL> select * from sappst.t000;
*ERROR at line 1:
ORA-00942: table or view does not exist

Some headscratching led me to ST04 - detailed analysis - oracle session, where I notice the user is actually SAPDAT.

select * from sapdat.t000;

actually works.

(thanks to http://sap.ittoolbox.com/groups/groups.asp?v=sap-r3-basis&i=659870 for some of this information)

(0) comments

Thursday, February 17, 2005

In SPRO you can search the IMG. Today this short dumped on me with:

Error when attempting to IMPORT object "P_STRUCTURE_TEXTS".

The answer was surprisingly simple - I needed to refresh the text index. This is simply a refresh button on the search dialog box.

Only took a couple of minutes too.

(0) comments

Wednesday, January 26, 2005


BC Sets are a way of saving IMG configuration , saving a whole set of data at a point in time, ready for transporting.

BC stands for Business Component, and this functionality has been available since 4.6C

(0) comments

Monday, July 12, 2004


Expensive SQL ABAP, reports data in Moni.

I've not used it, just making a note here

(2) comments

This page is powered by Blogger. Isn't yours?