Top 22 Sap Abap Data Dictionary Interview Questions You Must Prepare 19.Mar.2024

Data Dictionary Objects:

  1. Tables
  2. Views
  3. Domain
  4. Data Element
  5. Type Groups
  6. Search Helps/Matchcode Objects
  7. Lock objects
  8. Structures
  9. Table Types.

A Match code is a tool tip to help us to search for the data records in the system. Match codes are an efficient and user friendly search where key of a record is unknown.

SORT itab.

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

Call By Value:creates a new memory location for use within the subroutine. The memory is freed once it leaves the subroutine, changes made to the variable are not affected outside the subroutine.

Call by Reference : passes a pointer to the memory location. Changes to the variable within the subroutine affects the variable outside the subroutine.

  1. AT-FIRST: This is used when we want to execute the statements before records are processed.
  2. AT-LAST: This event is used when we want to execute the statements after all records are processed.
  3. AT-NEW: This event is used when we want to execute the statement before group of records are processed.
  4. AT-END: This event is used when we want to execute the statements after processing of group of records.

Read lock (shared lock):

 Protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table.

Write lock (exclusive lock):

Protects write access to an object. The write lock allows other transactions neither read nor write access to the locked area of the table.

Enhanced write lock (exclusive lock without cumulation):

 Works like a write lock except that the enhanced write lock also protects from further accesses from the same transaction.

  1. A database interface translates SAP’s Open SQL statements into SQL commands specific to the database in use.
  2. Native SQL statements access the database directly.

LockObjects used to synchornize access of several users using same data.

The basic difference is database tables are stored in DB serverand the internal tables are virtual tables these are created run time only

Internal tables are created dynamically, the memory of internal tables is not permant memory, for internal tables the memory will be created in the application server and it is external memory and terminates after the program termination.

After executing first write statement in start-of-selection event.

There are three type of buffer:

single record->it buffers only records based on select query statement.

generic buffer->it buffers all the records which match to primary key and generic key

full buffer :Buffering is use for improve performance.

We can use TC SE93 for creating our own transaction code.

The Table attributes determine who is responsible for maintaining a table and which types of access are allowed for the table.

The most important table attributes are:

  1. Delivery class
  2. Table Maintenance allowed 
  3. Activation type.

Value table is maintained at Domain level in SAP. During domain creation, value range of the domain i defined by specifying value table.

 User can create a Database table in two ways:

  1.  Top-to-bottom approach: In this approach, first fields are defined and later domain and data element are defined.
  2.  Bottom-to-top approach: In this approach, first domain and data element are defined and later fields are defined.

  1. APPL0(Master Data) for the data frequently accessed but rarely updated/changed.
  2. APPL1(Transactional Data) for the data that is frequently changed.
  3. APPL2(organizational Data) for customizing data that is defined/ entered during system installation and rarely changed.

You use the delivery class to control the transport of table data for an installation, upgrade, or client copy and transports between customer systems. The delivery class is also used in the extended table maintenance.

There are the following development classes:

  • A- Application table (master and transaction data).
  • C- Customer table, data is only maintained by the customer.
  • L- Table for storing temporary data.
  • G- Customer table, SAP can insert new data records but cannot overwrite or delete existing ones. The customer namespace must be defined in table TRESC. To define the customer namespace use report RDDKOR5@You can start it directly from the table maintenance by choosing Maintain Customer Namespace on the Delivery and Maintenance tab.
  • E- System table with its own namespace for customer entries. The customer namespace must be defined in table TRESC. To define the customer namespace use report RDDKOR5@You can start it directly from the table maintenance by choosing Maintain Customer Namespace on the Delivery and Maintenance tab.
  • S- System table, data changes have the status of program changes.
  • W- System table (for example table of the development environment) whose data is transported with its own transport objects (such as R3TR PROG, R3TR TABL and so on).

SQL Tracer is a tool used to measure the performance of ABAP program.

Tcode :st05

A Hot spot is a list area where the mouse pointer appears as an upright hand symbol. When a user points to that area, a single click does the same thing as a double click. Hot spots are supported from R/3 release 3.0.