How to get latest SAP news and messages by whatsapp

How to get latest SAP news, technology developments in WhatsApp ? Whatsapp is not an only messaging platform any more. More and more vendors, software providers announce their developments and last minute informations by whatsapp….

How to check and run db2 table statistics on sap system

Case You want to check and update db2 statistics of an SAP System. Solution 1) Find last statistics run of table for example T000. Execute following command as db2<sid>: db2 “select STATS_TIME from syscat.tables where…

Saposcol file owner and permissions

Case In order to be able to start saposcol successfully, you have to adapt its owner and file permissions properly Solution OS level, for example on unix/linux, change saposcol owner and file permissions after stopping…

How to lock unlock SDCCN

You want to lock or unlock SDCCN In SE38 run report /BDL/SETUP  (BDLSETUP) with the following parameters: KEY = LOCKED VALUE = space(unlock) oder X (lock) Delete = unchecked

Check sso from portal to abap

You want to check if single sign on (SSO) from sap portal to abap is working Log on to portal Try to run an abap transaction in portal by followings. Log on to portal ->…

Exporting and importing sap tables with controlfile

Exporting client In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content. EXPORT client = 500 file = export_file select * from VARI select * from VARID select * from VARIT…

Delete source systems in RSA1 after BW system copy

Case  You want to delete all source systems in BW system after a system copy Solution  1. Go to Transaction SE16 – table RSBASIDOC to determine all existing source system connections a) If entries exist:…

Language Import

The language import must always be performed in client 000. The supplementation must first be performed in client 000 and can then be scheduled in higher clients. However, only client-specific tables are supplemented. Find the…

Install non-unicode system from unicode CDs

Case You want to install a non unicode sap system ECC6. For this, you need ECC6 SR2 installation CDs, which are not available in Sapnet any more. Solution Bear in the mind that this is…