SAP ABAP Dictionary Interview Questions With Answers-1



1) What Is The Difference Between Native SQL & Open SQL?

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.

SAP’s data dictionary is called the ABAP Dictionary. ABAP Dictionary is accessed via transaction code SE11.


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.