SAP Basis Virtualization of your SAP system landscape - NW Admin

Direkt zum Seiteninhalt
Virtualization of your SAP system landscape
Clear authorization concept
In order to provide individual SAP or non-SAP developments and to link them to your SAP ERP system, we provide you with the necessary SAP NetWeaver application servers. We offer the following services in this area:

Do you know how to execute SQL commands on the tables in your SAP system? In the past, I asked myself the same question when I wanted to run prepared Querys on a table without converting it to a query over the SE16N with appropriate filters. After my research, I came across a simple way to have your SQL statements resolved transaction-based by an editor. This is the approach I'll describe to you in the following post. You may know the situation that you want to quickly put a short SQL statement on your SAP system without having to invest much effort in ABAP programming. You may not have the ABAP knowledge to extract data from a table, but you are familiar with SQL.
SAP Business Application Programming Interface (BAPI) is an interface that allows developers of customer and third-party code to access ... View full definition
After your user has the necessary permissions for the SQL Editor, perform the following steps: Call the DBACOCKPIT transaction. Open the following folder structure in Database Administration: Performance -> Additional Functions -> SQL Command Editor Enter your first query in the input query. Then click Run or alternatively press F8 View of the DBA Cockpit Invoke the input query and drop the first SQL query View the results of a query to query the users of a system.

If you want to get more information about SAP basis, visit the website www.sap-corner.de.


SAP Basis is structured as a classic three-tier model. It contains the following components: Database layer (relational database management system) / Application layer (application server and message server) / Presentation layer (graphical user interface).

Use "Shortcut for SAP Systems" to accomplish many tasks in the SAP basis more easily and quickly.

This is also done with the tool "SUM" (Software Update Manager) via the so-called "DMO" (Database Migration Option).

A note box in which data of all kinds can be quickly filed and retrieved. This is what Scribble Papers promises. At first, the program looks very spartan. But once a small structure is in place, you realise the great flexibility of this little helper.

IMPORT_PROPER In this step, the repository and table entries are recorded.
NW BASIS
Zurück zum Seiteninhalt