SAP Data Management Guide

Administration data for background job

Program:                                  RSBTCDEL

Re-organized tables:                 BTC*

Path for accessing files: /usr/sap/SID/SYS/global/<client>JOBLG

Job scheduling:             Daily (with variants)

Recommended job name:          SAP_REORG_JOBS

 

Spool Data and Administration Data for Spool Jobs

Program:                                  RSPO0041

Re-organized tables:                 TSP*

Path for accessing files: /usr/sap/SID/<instance>/data

Job scheduling:             Daily (with variants)

Recommended job name:          SAP_REORG_SPOOL

 

Administration Data for Batch Input

Program:                                  RSBDCREO (see SAP Note 18307, SAP R/3 Release 3.00 – 4.6B)

Re-organized tables:                 BDC* and APQ*

Path for accessing files:                         /usr/sap/SID/SYS/global

Job scheduling:                         Daily (with variants)

Recommended job name:          SAP_REORG_BATCHINPUT

 

Runtime Statistics for Background Jobs

Program:                                  RSBPSTDE

Re-organized tables:                 BTCJSTAT*

Path for accessing files:             Not specified

Job scheduling:                         Weekly (with variants)

Recommended job name:          SAP_REORG_JOBSTATISTIC

 

 

Note: The above explanation is a part of Data Management Guide For mySAP Business Suite documentation (© copyright by SAP AG).

I own the PDF file

Can we print SAP spool into PDF format?

Yes, you can print SAP spool into PDF format by using report RSTXPDFT4.  Just create a spool request for any printer, even if it is dummy.

Now do the following:
1. Go to transaction SE38, fill with RSTXPDFT4 then execute.
2. In the first screen give the spool request number, you will get the spool request number in transaction SP01. And then enter the filename of the pdf you want it to be downloaded as.
3. Save it to your desktop and view it as a pdf. 

Error code-8- when release transport request

Error log in export step:
invalid value ‘E’ in E071.LANG (as4pos = 000013)
R3TRTABUPPFTFLTVAT
Incorrect export. Request not imported.

Solution:
1. Make sure you have the updated R3trans and tp program from SAP Marketplace.
2. Create new report ZRSWBO_CLEANUP_LANGFLAGS and run it.
3. Try to release your transport request.

Source code of ZRSWBO_CLEANUP_LANGFLAGS:

How to update your SAP Router license

1. Go to SAPRouter directory (i.e. /usr/sap/saprouter

2. For security reason, please copy your current certreq, srcert, local.pse, and cred_v2 files.

3. Delete current file local.pse
     command: rm local.pse

4. Create new certificate request’s and new local PSE’s file
     command: sapgenpse get_pse -v -r certreq -p local.pse “CN=SAProuter, OU=<ou_number>, OU=SAProuter, O=SAP, C=DE”
just press Enter for the PIN

we will get new certreq file.

5. Open browser and go to address https://service.sap.com/saprouter-sncadd.

     Choose “Apply Now”

6. Choose “SAProuter” and click “Continue”

7. Copy-paste the content of file certreq into text area, and click “Request Certificate”.

The web page will create the certificate response (inside text area).

8. Delete the current srcert file. Create the new srcert file, and fill with the above certificate response.

9. Import the response into the local PSE.

     command: sapgenpse import_own_cert -c srcert -p local.pse

10. Creating the credential for <sid>adm user

       command: sapgenpse seclogin -p local.pse -O <sid>adm

11. Registering with the local PSE

       command: sapgenpse get_my_name -v -n Issuer

12. Finally, just restart your SAP Router application.

Monitoring SAP work processes via OS command

Have you ever experience the condition where all SAP dialog work processes are in used? Then we can just do nothing except to restart the SAP system

I found an interesting tool, binary executed, provided by SAP, that can manage the above condition.It’s called dpmon.

With dpmon, we can still monitor the SAP work processes in OS level environment. No need to logon to SAPGUI.
Just logon at the OS level as user <sid>adm and go to SAP profile directory.

These are examples using Solaris and windows environment.

On Windows:
E:
cd E:\usr\sap\CRD\sys\profile
dpmon pf=CRD_DVEBMGS01_JKTGRHXSAPC1

On Solaris:
cd /sapmnt/EXX/profile
dpmon pf=EXX_DVEBMGS01_sapprod

Dpmon has several functionalities the same as transaction SM50 via SAPGUI.

With dpmon we can stop workprocess, kill workprocess, or enable restart flag.

There’s an online video of e-learning, explaining on this dpmon tool:
http://www.youtube.com/watch?v=EvkgPPMBVkc