Pages

SAP ABAP Dictionary Interview Questions With Answers-1

There are two types of SQL being used in SAP ABAP programming language. They are

Native SQL

Open SQL

Open SQL allows to access the database tables declared in the ABAP dictionary regardless of the database platform that the SAP R/3 system is using.

Native SQL allows to use database-specific SQL statements in a SAP ABAP program. This means that one can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the SAP R/3 system.

Open SQL is not confined to any particular type of database while a Native SQL is confined to a particular type.

ABAP programs that uses only Open SQL statements will work in any R/3 system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP dictionary.

2) What Is ABAP Dictionary Or Data Dictionary? What Is The Transaction To Access ABAP Dictionary?

A data dictionary is a centralized storage location for information about the data that is stored in a database. It is basically an interface which helps us to understand like what kind of data is stored in database, what are the properties and attributes of the data and the relation between different data objects available in database.

3) What Are The Objects Of the ABAP Dictionary Or What Types Of Objects Can Be Created In The ABAP Dictionary?

The basic objects of the ABAP Dictionary are tables, data elements and domains. Objects that can be created in the ABAP Dictionary or via SE11 transaction are:

Tables

Data Elements

Structures

Table Types

Type Groups

Domains

Views

Search Helps

Lock Objects

4) What Are The 3 Types Of Tables In SAP?

There are 3 types of tables in SAP Dictionary (DDIC). They are:

Transparent Table

Pooled Table

Cluster Table

5) What Do You Mean By Transparent Tables In SAP ABAP?

Whenever a table is created and defined through ABAP Dictionary, then it is called a transparent table. When the table is activated in ABAP Dictionary, a table automatically gets created in the underlying database with the same name as was defined in ABAP Dictionary.

So generally we say, transparent tables has one to one relationship with underlying database which means there will be only one physical table on the database for each transparent table created and defined through ABAP Dictionary.

The names of the table and fields in underlying database will correspond or have the same names as the logical table definition in the ABAP Dictionary.

Transparent tables can be used to store application data which include master data as well as transaction data. Transparent tables are probably the only type of table that you will ever create as a developer.