SAP Basis range of services
Migration of an SAP system to other server landscapes
For these cases, you should take a closer look at the DBACOCKPIT transaction. This transaction provides you with many other database management features, an editor that allows you to easily execute your SQL queries against your SAP system. This method displays the result in the GUI shortly after the query is sent. How to execute a SQL query To call the editor for SQL queries in DBACOCKPIT, the user must: The user needs corresponding rights to execute the transactions SM49 and SM69. STOR and SMSS must be cultivated in the S_ADMI_FCD permission object. SQL queries must maintain the database connection. To get the current status of a database connection, see the DBCONT table. Rights for calling the table(s) to be retrieved must be assigned. For more details, see the section "Further information on DBACOCKPIT" in this blog post.
Once the UPL is activated, you can access the usage data as follows: Solution Manager: BW Query 0SM_CCL_UPL_MONTH (other predefined Querys available) Managed System: Report /SDF/SHOW_UPL Based on the UPL's data collection, you can now use additional functionalities of the CCLM to depick, for example, proprietary developments that are unused for a long time. Do you know the UPL of SAP and already use it to gain more information about its existing system landscape?
Database layer: The database layer contains a database server on which all the data of the SAP ERP system is managed. This includes the database management system (DBMS for short) and the actual dataset. The dataset includes user data and data tables as well as applications and system control tables.
Projects: Your SAP Basis administrator plays a key role in planning and executing system upgrades and migrations. He is also responsible for transport management and tests software updates to ensure they are compatible with the landscape. In addition, he must ensure that they are installed in the correct order.
"Shortcut for SAP Systems" makes it easier and quicker to complete a number of SAP basis tasks.
This also applies to administrators in the area of a new technology.
The freeware Scribble Papers is a "note box" in which all kinds of data can be stored. It takes in typed texts as well as graphics and entire documents. The data is then organised in folders and pages.
The USR02 table provides a first entry point.