Abap-2

Database tables and open SQL

Add a single record to a database table

insert into values

Inserting all lines from an internal table into a database table:

insert from table

Delete all records

Select * from zmellemtab.
delete zmellemtab.
endselect.

Deleting records using records from an internal table

delete employees from table itab.


Q & A

BASIS LAYER

What are the central interfaces of the R/3 system ?
- Presentation interface
Database interface
Operating system interface

Which interface controls what is shown on the p.c. ?
- Presentation interface

Which interface converts SQL requirements in the SAP development system to those of the database ?
- Database interface

What is SAP dispatcher ?
- SAP dispatcher is the control agent which manages the
resources for the R/3 applications.

What are the functions of dispatcher ?
- Equal distribution of transaction load to the work processes
Management of buffer areas in main memory
Integration of the presentation levels
Organization of communication activies

What is a work process ?
- A work process is where individual dialog steps are actually processed and the work is done. Each work process handles one type of request.

Name various work processes of R/3 system ?
1) Dialog or Online ( processes only one request at a time )
2) Background ( started at a specified time )
3) Update ( primary or secondary )
4) Enque( lock mechanism )
5) Spool ( generated online or during back ground processing For printing )