What do you define in the Data element and Domain?
For Data Element
The information includes the field's representation on the screen in the form of FIELD TEXTS, COLUMN CAPTIONS in list outputs of the table contents and the format of the output via PARAMETER IDS and Online field documentation.
For Domain
Data Type,Field Length and the allowed data values are defined .
What is the difference between a pool table and a transparent table?
Transparent Table :
A tran table has a one to one relataionship in the database. The table in the dictionary has the same name, same no of fields, and the fields have the same name as in the R3 table defn. A transparent tabel has application data (Master and Transaction).
Pooled Table :
A pool table has many to one relation with the table in the database. For one table in the database there r many tables in the dictionary. Tha table in the database has a diff name than in the table in the data dict, it has diff no of fields and field names are different. A pooled table is stored in the pool at the database level. A table poo is a databse table with a special struct that enables the data of many R3 tables to be stored in it. It can hold only pooled tables.
What are field symbols and field groups? Have you used component idx of structure with field groups?
A field symbol does not physically reserve space for a field, but points to a field which is not known until runtime of the program. Field symbols are comparable to the concept of pointers as used in the programming language C.
An extract dataset consists of a sequence of records. These records may have different structures. All records with the same structure form a record type. You must define each record type of an extract dataset as a field group, using the FIELD-GROUPS statement.
What is the step by step process to create a table in data dictionary?
1. Selecting the table fields
2. Maintaining foreign keys
3. Creating secondary indexes (optional)
4. Maintaining technical settings
5. Activating a table
What is the advantage of structures and how do you use them in Abap/4 programs?
A structure is defined in the ABAP/4 Dictionary like a table and can be accessed from ABAP/4 programs. Any change to the definition of the structure in the ABAP/4 Dictionary is automatically implemented in all programs.
While data in tables is stored permanently in the database, structures contain data only during the runtime of a program.
Structures are used in abap/4 programs to transfer data between programs as it is globally defined.Structures are used in particular for defining data at the interface between module pools and screens and for standardizing parameters for function modules.
What does an extract statement do in the Abap/4 program?
With the first EXTRACT statement of a report, the system creates the extract dataset and adds the first extract record. With each subsequent EXTRACT statement, the system adds another extract record to the extract dataset.
What is a collect statement and how is it different from the append statement?
To fill an internal table with lines which have unique standard keys, we use the COLLECT statement.
If an entry with the same key already exists, the COLLECT statement does not append a new line as APPEND statement, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.
What is an open SQL vs Native SQL.
Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program.
To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP.
A database interface translates SAP's Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly.
What does an EXEC SQL statement do in ABAP? What is the disadvantage of using it?
To use a Native SQL statement, it must be preceded by an EXEC SQL statement and concluded by an ENDEXEC statement.
An ABAP/4 program with Native SQL statements does not generally run with different databases.
