SAP basis FAQs

1. How to view the number of digits in the SAP system?

System -- Status view platform ID
Platform 32-bit 64-bit

----------------------------------------------------------------
Dec-Alpha --- 288
HP-UX 272 273
Rm600 322 323
AIX 320 324
Sun 369 370
Winnnt 560

2. How can I find out if a 64-bit database is in use?
St04 --> 'detail analysis menu '--> 'v $ tables' --> 'v $ version'
The string '64-bit version' is output for 64-bit versions

3. What combinations of database software and R/3 kernel are possible?

32-bit database with 32-bit R/3 Kernel
64-bit database with 64-bit R/3 Kernel
64-bit database with 32-bit R/3 Kernel
Not supported: 32-bit database with 64-bit R/3 Kernel

4. SAP memory management (33576)

5. Where can I get a list of all transaction codes in sap?

The following tables hold all SAP transactions:
Table tstc stores all transaction codes and their respective ABAP program.
Table tstct stores the text (or description) for each transaction.
Table thstc has also documentation for all transaction. It is a copy of tstct.
Table tstcp stores the possible parameters for each transaction.

6. Where can I get a list of all tables in sap?
Table dd02l stores all tables in SAP.

7. How can I hide a client from the users?
There is no way to actually hide a client but there is a workaround: Delete the entry in Table t000 via scc4. this way, nobody will be able to log on to it. to "unhide" it, simply re-create the entry via scc4.

8. How can I lock a client?
You can use one of these two: 1) Delete the entry in Table t000 via scc4; 2) Run TP locksys/unlocksys at the OS level.

9. How can I determine the size of a client?
You can run a local client copy in "test" mode.

10. How can I see all the available icons in sap?
Execute transaction bibs and select elements-> icon overview.
You can use the code that appears on the last column in order to put icons in system messages (sm02 ).

11. What happens if I start a dialog instance but the database and SAP services are down on the central instance?
The SAP _ Xx and saposcol services will start.
However, the work processes will end soon after being started.

12. What happens if I start a dialog instance but only the database services are up on the central instance?
The SAP services will start and so will the work processes. however, because the Message Server is down on the central instance users will get the message "No Logon possible (no hardware ID sent ed by Message Server) when trying to log on. no user logins will work. the "Process List" in the sap mmc will stay in yellow.

13. Can I import transports between different R/3 releases?
Read the technical and logical problems sap reports when doing transports between different R/3 releases.
SAP notes 126776 and 330267.

14. I lost the password for SAP *. What can I do?
You can delete the record for SAP * in Table usr02 as follows:
Delete usr02 where bname = "sap *" and mandt = 'xxx ';
Commit;
Replace 'xxx' for a valid client number.

15. Can SAP be installed on fat or FAT32 partitions?
No. SAP needs to be installed on NTFS partitions only.

16. How can I quickly check if the passwords for the accounts sap *, ddic, sapcpic and earlywatch are not the default ones?
Run se38 and execute report rsusr003.

17. Can I copy just data from client to another?
No. There is no copy profile that allows you to copy just data.
For this you need to configure and use ale or buy a third-party program that has this type of functionality.

18. can query analyzer tell me if there is insufficient disk space to restore a database?
Yes. It will display message (MSG) 3257 indicating that there is not enough disk space to perform the restore.

19. Disable multiple logins in the same client

To disable multiple user logins within the same client implement this parameter in the instance profile:
Login/disable_multi_gui_login = 1
If you do not use this parameter in your system, users have the ability to ignore the warning window at the time they try to login to the same client.
Activating this parameter in your system will make you look good if you get audited!
How about exceptional logins?
In case you're wondering how to allow multiple logins for certain key users you can implement parameter login/multi_login_users. you can list the user IDs that shocould be ignored if the parameter above is active in your system

20. roles with restricted company codes and values

Do you need to find out what roles you have set up with restricted company code values for specific authorization objects?
If your company has changed its company code (Burk) and if you have limited access to a participating company code in your roles, you will have to adjust the roles to use the new company code or to use * For any code.
But, how do you quickly find out what roles you need to adjust?
Simple. query table agr_1252 and check the contents of the low and high fields. you can use your favorite query tool (query analyzer in SQL Server for example) or use transaction SE16 or SE11 within sap.
Here is a sample query:
Select mandt, agr_name, varbl, low, high
From agr_1252
Where mandt = '000000'
And (low <> 'or high <> ')
And (low <> '*' and high <> '*')
And agr_name not like 'sap %'
The above query looks for any non-SAP role in client 100 Where either low or high have anything different *.
You'll get a list of the roles you need to adjust to use the new company code.

21. View locked transactions

As you know, you can lock/unlock transaction codes via sm01.
But, how do you go about viewing the transactions that are locked in the system?
You need to look in field Cinfo, table tstc.
Within sap, you can use either SE11 or SE16 to browse the table contents.
Make sure you enter "A0" as the "hex01 Data Element for syst" starting value and "A9" as the ending value.
This will list all the transactions locked in the system.
Note: The Cinfo field description is "hex01 Data Element for syst ".

22. logging on to sap using sapshcut

You need to pass these parameters:
-Sysname = entry name in saplogon
-Client = client number
-User = user ID
-PW = PASSWORD (in plain text)
Optionally, you can pass parameter-command to execute a transaction upon logon.
See example below:
Sapshcut-sysname = sap production-client = 000-user = sap *-PW = 06071992-command = sm04
For more information, run sapshcut /?

23. Fast logon to an SAP server

You can log on to an SAP server quickly using the "sapgui" executable.
This way, you do not even need saplogon.
At the command prompt type:
Sapgui hostname instnumber
Example:
Sapgui myprd 00
The example above lets you log on to the server "myprd" with instance number 00.
The sapgui.exe is located under the "sapgui" directory. You either need to put this directory in your system's path or change to the directory to be able to log on as indicated above.

24. Saving passwords for SAP shortcuts

Passwords are not saved in shortcuts created within sapgui. In fact, when you edit a shortcut cut the password field is grayed out.
Why? Because you need to first register the sapshortcuts using:
Sapshcut-register
Sapshcut.exe is located under the sappcsapgui directory. In sapgui 4.0 it was called sapsh.exe.
Once you do the registration you need to open the Registry (regedit or regedt32) and change the value data of "enablepassword" to "1" under:
Hkcu/software/SAP/sapw.cut/security
Then, you will be able to type and save your passwords.

25. SAP table with version and Instance name

Usap r/3 stores its version, Instance name and OS platform in tables!
This is excellent as you can then query Database to get the R/3 version, Instance name and OS platform as follows:
Select * From svers
Select * From tsle4
You don't even have to log on to the application to get this info. The above query gives it to you in less than 1 second.

26. logging on to sapnet directly (bypass oss1)

You can logon to sapnet-R/3 frontend without using transaction oss1.
This way you don't have to open an SAP session just to log on to sapnet.
Here is how to do it:
A. Create the file "saproute. ini" under the % winnt % directory and add the following two entries:
[Router]
Sapservx =/h/your-saprouter-Internal-IP-address/h/sapservx-IP-address/h/
Example:
Sapserv4 =/h/200.10.10.24/h/204.79.199.2/h/
200.10.10.24 is my sap router's IP address.
204.79.199.2 is sapserv4's IP address.
B. Create the file "sapmsg. ini" under the % winnt % directory and add the following two entries:
[Message Server]
O01 = oss001.wdf.sap-ag.de
C. Open the saplogon Program (it is part of the SAP frontend software-sapgui, on your PC ).
D. Click on the "groups" button.
E. Click on the down arrow for "sap router for" and select your sapservx from the list.
F. Click on the "generate list" button.
G. Select "distinct public" from the list of groups.
H. Click on the "add and logon" button.
You're done! You can change the name of the sapnet session in saplogon if you want.
No more typing oss1!

27. determining who executed a transport
SE11 --> tplog

28. An error occurred while installing Oracle 920 in hp11i. "error in invoking target install of make file $ ORACLE_HOME/CTX/lib/ins_ctx.mk "?

Login OS level as user root, CD/usr/lib
Ln-S/usr/lib/libx11.3 libx11.sl
Ln-S/usr/lib/libxie.2 libxie. SL
Ln-S/usr/lib/libxext.3 libxext. SL
Ln-S/usr/lib/libxhp11.3 libxhp11.sl
Ln-S/usr/lib/libxi.3 libxi. SL
Ln-S/usr/lib/libxm.4 libxm. SL
Ln-S/usr/lib/libxp.2 libxp. SL
Ln-S/usr/lib/libxt.3 libxt. SL
Ln-S/usr/lib/libxtst.2 libxtst. SL
Note: 499055,97953

29. Install sap support package, upgrade kernel (19466 )?
Notes: 447925 (old), 782140 (new), 664679 (special feature on Windows)

30. db13 database backup or check, the ORA-01031: insufficient privileges?
Download sapdba_role. SQL from SAP website and execute it

31. Install sap online help?
Sr13 (Note: 101481)

32. How can I view the host serial number in HPUX?
CSTM --> Sele Dev 1 --> il or CSTM --> selall --> info --> Il

33. How to compile the SAP system?
Sgen

34. How to generate profiles in batches?
Supc

35. How to view the develop key in SAP (you do not need to log on to the SAP website?
SE16 --> devaccess

36. Setting Early Watch Alert (EWA )?
Note: 207223,91488, 69455

37. In HPUX, what files are on the tape?
Frecover-rnsv-F/dev/RMT/0 m

38. View tape information?
Brbackup-Q check-U/
Brbackup-I show

39. How to check Unix kernel parameters and swap space?
Memlimits (SAP must be stopped first !)

40. Check sap Parameter
Sappfpar (OS) or
Se38 --> rspfpar (or rsparam)

41. Install SAP
Note: 534334 653172 (IDES) 722273 (for Linux)

42. How to save request number to local?
Se38 --> rstxscrp

43. Table (s) containing all tcode information )?
Tstc, tstct

44. Clear the Trans directory? (Notice: 41732)
TP cleanbuffer
TP check all pF =...
TP clearold all pF =...

45. saprouter related
Niping-s (server side)
Niping-c-h target_host (client side)
Saprouter-R (start saprouter)
Directly enter Niping and saprouter for help

46. Notes about failure of oss1 connection: 33135, 21477, 33261

47. How to establish an OSS service and a VPN connection? Note: 486688-000054

48. OCs (online correction supports) related note: 97620

49. ABAP programs for check and cleanup? (Notice: 16083)

50. How to create a development class?
Sm30 --> input table name v_tdevc --> maintain

51. How do I check whether the Language Pack is installed correctly?
Se38 --> rscp0018

52. How do I control the control level in permission settings?

53. Set the print environment variable lp_cmd = on frontend /Saplpd/saplpd.exe-F & F-C & C-P & P
The print process saplpd will automatically end after printing (Note: 150533)

S00033000033/i977g620
S0003572710

54. How to dump the internal structure of the database, as shown in the control file structure shown above
Common
(1) analyze data file blocks and dump data file n blocks M
Alter system dump datafile n block m
(2) analyze log files
Alter system dump logfile logfilename;
(3) analyze the Control File Content
Alter session set events 'immediate trace name controlf level 10'
(4) analyze all data file headers
Alter session set events 'immediate trace name file_hdrs level 10'
(5) analyze the Log File Header
Alter session set events 'immediate trace name redohdr level 10'
(6) analyze the system status, preferably once every 10 minutes for three comparisons
Alter session set events 'immediate trace name systemstate level 10'
(7) analyze the process status
Alter session set events 'immediate trace name processstate level 10'
(8) analyze the details of the library Cache
Alter session set events 'immediate trace name library_cache level 10'

55. Does the Hang remain unchanged during link pending... during Oracle installation?
You need to set the variable ld_assume_kernel = 2.4.1 (different versions have different values)

56. Install statspack in Oracle
(1). Create tablespace perfstat
(2). @ $ ORACLE_HOME/rdbms/admin/spcreate
(32.16.exe C statspack. Snap (sampling twice, optional)
(4). @ $ ORACLE_HOME/rdbms/admin/spreport

57. How to obtain the current SCN
9i or earlier versions
Select max (ktuxescnw * power (2, 32) + ktuxescnb) from x $ ktuxe;
If the version is 9i or later, you can use the following statement to obtain
Select dbms_flashback.get_system_change_number from dual;

58. How to obtain the DDL statement of an object
DBMS_METADATA of 9i or later versions
(1) obtain the DDL statement of a single object
Set heading off
Set echo off
Set feedback off
Set pages off
Sets long 90000
Select dbms_metadata.get_ddl ('table', 'tablename', 'scame') from dual;
(2) If you obtain the script of the entire user, you can use the following statement:
Select dbms_metadata.get_ddl ('table', U. table_name) from user_tables U;
Of course, if it is an index, You need to modify the relevant table to the index

59. How to Use hint prompt
Write/* + hint */After Select/delete/update */
For example, select/* + index (table_name index_name) */col1...
Note that there must be no space between/* and +.
For example, use hint to specify an index.

Select/* + index (cbotab) */col1 from cbotab;
Select/* + index (cbotab cbotab1) */col1 from cbotab;
Select/* + index (A cbotab1) */col1 from cbotab;
Where
Table_name must be written. If the table alias is used in the query, the table alias must be used in the hint instead of the table name;
Index_name does not need to be written. Oracle selects an index based on the statistical value;
If the index or table name is wrong, the hint will be ignored;

60. Install ides470x110 in RedHat Linux 9. An error occurs when dbinstance is installed. RFC connection open error!
Check dev_w * with the following records:
* ** Error => shmget (10033,0, 480) (0: Success) [shmux. c 1873] B dbtbxbuf: SHM segment 33: cannot create/attachb *** log BBB => ADM message tbx Buffer: function shmcreate1 returns rc = 2 [dbtbxbuf #9 @ 1388] [dbtbxbuf1388]
* ** Log BZL => internal error in Table buffer: Table Buf init fail [dbtbxbuf #9 @ 1647] [dbtbxbuf1647]
Dbtbxbuf: return code (sap_rc): 2, buffer tbx_single will not be available
Db_tbpinit failed
* ** Error => thcallhooks: event handler db_init for event create_shm failed [thxxtool3.c 237]
* ** Error => thipcinit: hook failed [thxxheader. c 1656]
* ** Log r19 => tskh_init, thipcinit (TSKH-IPC-000001) [thxxhead. c 1159]
In_therrhandle: 1
* ** Error => tskh_init: thipcinit (step 1, th_errno 17, Action 3, level 1) [thxxhead. c 8437]
Solution: download the latest kernel patch and lib_dbsl

61. How to install help for sqlplus
Sqlplus must be installed manually. The shell script is $ ORACLE_HOME/bin/helpins.
Before installation, you must set the system_pass environment variable, for example:
$ Setenv system_pass system/Manager
$ Helpins
If this environment variable is not set, the system prompts you to enter the environment variable when running the script.
Of course, in addition to shell scripts, you can also use SQL scripts to install them, so you do not need to set environment variables. However, you must log on to the system.
$ Sqlplus system/Manager
SQL> @? /Sqlplus/admin/help/hlpbld. SQL? /Sqlplus/admin/help/helpus. SQL

62. Install support PKG for solution manager Note: 662441

63. Client analysis tools
ABAP program: multiclient_analysis
Multiclient MANAGER: (transaction mcliman)

64. ABAP program analysis
Slin: syntax check
Se38: runtime analysis

65. After MSN is installed, you cannot log on to the SAP system. The error message "service sapdpxx unknown" is displayed"
Solution: Start ---- run ---- Regedit to modify the Registry. Modify the following values:
HKEY_LOCAL_MACHINE/system/CurrentControlSet/services/TCPIP/parameters
Set the value of "databasepath"
% SystemRoot %/system32/Drivers/etc % SystemRoot % is changed to the actual value of the variable,
For example, if Win2000 is C:/WINNT, XP or 2003 is C:/Windows

66. Analysis of SAP Buffer
Rsdbbuff

67. Delete jobs
Rsbtcdel

68. Problem description: An error occurred while backing up the database and archived log with db13 after SAP kernel is upgraded: the database is backed up successfully,
But log does not back up; when using brarchive to back up log separately, although can back up, but there is a ora-01017 error, Prompt User Name/Password
The database cannot be connected. The possible cause is that the new kernel uses the Default User/password to connect to the database.
Solution: Use sapdba/brtools The password is restored to the initial value, and the execution program permission of Br * is confirmed to be 4755.

69. Check sap Profile
Sappfpar check pF = profile_name

70. Oracle client Character Set settings
Client: nls_lang = _ . Clients characterset and,
Server: The nls_characterset must be consistent with the. Language and territory settings based on local conditions. For example, set the language
Set nls_lang = simplified chinese_china. Or modify the registry key value nls_lang.

71. Method for searching table fields
SE11, SE15 --> ABAP dictionary --> Fields

72. Methods for accessing sap over the Internet (non-VPN)
Assign a public IP address to saprouter and open port 3299 to the firewall.

73. After online help is set, a prompt is displayed during access.
"Internet Explorer cannot be linked to the webpage you requested. This page may be temporarily unavailable. "
Cause: Microsoft's security restrictions (Http://support.microsoft.com/kb/896054)
Solution:
Regedit4
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp]
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp/1.x/ itssrestrictions]
"Maxallowedzone" = DWORD: 00000003
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp]
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp/1.x/ itssrestrictions]
"Urlallowlist" = "// 192.168.99.208/docu; file: // 192.168.99.208/docu; // 192.168.99.208/docu"
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp]
[HKEY_LOCAL_MACHINE/software/Microsoft/htmlhelp/1.x/ itssrestrictions]
"Nestedprotocollist" = "http:; ftp :"
Save the preceding key value as a registry file and then import it to the Registry.

74. Import support PKG interrupted. An error occurred while re-importing. What should I do?
A. Delete the records corresponding to the SP in the patch field of the pat03 table and clear table pat01 and pat10.
B. Use TP delfrombuffer to delete the corresponding request (first view it with TP showbuffer) (STMs)
TP showbuffer PF = E:/usr/SAP/trans/bin/tp_domain_c11.pfl
TP delfrombuffer PF = E:/usr/SAP/trans/bin/tp_domain_c11.pfl
C. re-import, and then execute the next step: 75

75. Error: Background job rddimpdp cocould not be started or terminated
Abnormally.
Please check that the R/3 system is running.
Please check the system. Use transactions sm21, sm37, sm50.
10:23:22 dia 0 000 sapsys eh1 event handler: Event ###
(# Ba ### HR [### TV # PI # Z ^ ### W'> # Is Not Defined
10:24:22 dia 0 000 sapsys eh1 event handler: Event
# AK #######' # J ### 9 ### U ## O0 # Wa ## 0 is not defined
Solution: SAP note 745468
* Update E:/usr/SAP/ /Sys/EXE/run/sapevt.exe Version 3 or above

76. An export_too_much_data error occurs in the sap_collector_for_perfmonitor job of sm37.
See Notes: 580352 (collect_overflow with sap_collector_for_perfmonitor)
Solution: Notes: 580352. Import the patch.