Archive for June, 2008

What is Constants Statement

Monday, June 30th, 2008

A constant is almost identical to a variable except that its value cannot be changed. To define one, you use the constants statement.

Use a constant when you need to include the same literal multiple times in a program. You can define a constant with the same value as the literal and use the constant in the body of the program in place of the literal. Later, if you need to change the value of the literal, you can simply change the value of the constant, causing its value to be updated wherever it is used in the program.

ABAP/4 has one pre-defined constant: SPACE. It is a constant having a value equal to spaces. You can use it in place of the literal ‘ ‘.
Syntax for the CONSTANTS Statement (more…)

Popularity: 4% [?]

What is the difference between transparent tables and pooled tables

Monday, June 30th, 2008

Transparent tables
Transparent tables in the dictionary has a one-to-one relation with the table in database. Its structure corresponds to single database field. Table in the database has the same name as in the dictionary. Transparent table holds application data.

Pooled tables
Pooled tables in the dictionary has a many-to-one relation with the table in database. Table in the database has the different name as in the dictionary. Pooled table are stored in table pool at the database level. (more…)

Popularity: 4% [?]

What are indexes?

Sunday, June 29th, 2008

Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that other fields are also read, a pointer to the associated record of the actual table are included in the index. Yhe indexes are activated along with the table and are created automatically with it in the database.

Popularity: 4% [?]

What is foreign key relationship?

Sunday, June 29th, 2008

A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against existing data to ensure that there are now contradiction. While defining foreign key relationship cardinality has to be specified. Cardinality mentions how many dependent records or how referenced records are possible.

Popularity: 4% [?]

What is an ABAP data dictionary?

Sunday, June 29th, 2008

ABAP 4 data dictionary describes the logical structures of the objects used in application development and shows how they are mapped to the underlying relational database in tables/views.

Popularity: 4% [?]