You can select from several database tables using a database view or a join.
A secondary index for non-key fields generally works like a primary index for key fields.
A key field in a database table uniquely identifies a data record.
The client field is a selective field and should therefore always be specified in the WHERE condition for SELECT.
The OPEN SQL statements are converted into database-specific statements by the database interface.
Using the SET/GET parameters.
By passing parameters using additions in the SUBMIT statement.
Using the ABAP memory.
By declaring the data objects with the same name in both programs, using the DATA statement.
With SELECT SINGLE access, the result is one data record maximum.
The SELECT statement supports the return code (SY-SUBRC).
With SELECT...ENDSELECT access. the result is one data record maximum.
The SELECT statement always reads the data into the SAP memory first.
With SELECT...INTO TABLE access, the result is one data record maximum.
If you change the value of a field symbol, the value of the data object to which the field symbol is assigned also changed.
A field symbol always reference a data element.
You can no longer create data objects at runtime(dynamically) since the ABAP runtime system combines all the declarative statements in on processing block and executes these first.
A field symbols only references a data object after the latter has been assigned to the field symbols using the ASSIGN statement.
You can change the type of the assigned data object using the CASTING-TYPE addition for the ASSIGN statement.
Key access to an internal table of the type STANDARD generally has even less runtime consumption than index access.
Index access to an internal table of type SORTED will, in certain cases, violate the sort sequence.
Access to nested internal tables using field symbols usually increase performance.
Index access to an internal table of the type HASHED has less runtime consumption.
You can perform a binary search on internal tables of the type SORTED using the addition BINARY SEARCH only.
FORM U CHANGING VALUE(P).
FORM U CHANGING P.
FROM U USING p.
FORM U USING VALUE(P).
A MESSAGE E...statement
An AUTHORITY-CHECK statement that return code SY-SUBRC NE 0.
A MESSAGE I...statement.
A structured work area (line).
An internal table
PROCESS BEFORE OUTPUT
Implementation of methods of an interface in the respective classes (for polymorphism through interfaces).
Redifinition of methods (for polymorphism through inheritance)
Syntax check of "native" SQL commands.
Conversion of Open SQL statement from ABAP statements into the corresponding database statements.
Data consistency check with respect to foreign key relationships.
Database independence of application programs.
Usage of the SAP buffers.
SAP GUI for Windows
SAP GUI for HTML
SAP GUI for Web AS
SAP GUI for ITS
SAP GUI for Java
For input fields on screens if the input fields have been copied from the Dication into the Screen Painter.
For input fields on ABAP lists.
For input fields on selection screens.
No, Key changes are not allowed.
Yes, irrespective of whether the table already contains data or not.
Yes, However, the table must not contain any data yet.
After adding an APPEND structure to a table, you must convert the table.
You can use an APPEND structure like any other structure in ABAP programs.
An APPEND structure allow you to append field to an SAP table without having to modify the table itself.
An APPEND structure is the same as substructure.
A database view supplies the results quantity of an outer join logic.
Using a database view, you can read data from several tables.
Using a database view, you can insert data into several tables.
A database view is a special view of transparent tables.
A database view can have one or several base tables.
A search help function that is linked to the table field can return values only for the search field (field where the f4 help was triggered).
A search help function that is linked to the data element can return values only for the search field (field where the f4 help was triggered).
If the search help function is linked to the data element as well as to the field. The search help for the field is displayed.
If the search help function is linked to a table A. this search help is displayed whenever there are input field from A on the screen.
If the search help function is linked to a table A. this search help displayed whenever there are input fields on that screen that have A as the check table.
Parameters can be displayed on the result list.
Parameters must be fields from the selection method only.
Import parameters control which data can be included in the data selection.
Export parameters control which data can be returned to the input template.
A parameter is either an import or an export parameter
The primary index consists of the key fields of the database table.
An Index can be assigned to several database tables.
A database table can have more than one index.
Using an index speeds up data selection from a table.
For the purpose of data consistency: when you active the table the FKs are created in the database. You thus prevent invalid data from getting into the table.
For the propose data consistency: when you maintain data records using dialog transaction (screens).
The input values are automatically check in accordance with the FKs.
FKs are used solely for documenting table relationships.
Transparent database table.
Typing with LIKE to ABAP Dictionary types.
The definition of internal tables with header lines.
The TABLES statement.
The definition of internal tables without header lines.
Typing with TYPE to ABAP Dictionary types.