SAP Info Blog

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.

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:

TMS_BCI_START_SERVICE

Just schedule that every 15 minutes or so.

# posted by Robert : 2:06 PM

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)

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>
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)

# posted by Robert : 11:59 AM

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.

SCPL3

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

RSORADLD

Expensive SQL ABAP, reports data in Moni.

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