SAP ABAP Data Dictionary Interview Questions & Answers

  1. Question 1. What Is Delivery Class?

    Answer :

    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 RDDKOR54. 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 RDDKOR54. 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).
  2. Question 2. How Many Types Of Data Classes Are There In Sap Abap?

    Answer :

    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.
  3. SAP CRM Interview Questions

  4. Question 3. What Is Value Table?

    Answer :

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

  5. Question 4. What Is Table Attribute?

    Answer :

    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.
  6. SAP CRM Tutorial

  7. Question 5. What Is Is A Match Code?

    Answer :

    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.

  8. SAP BI Interview Questions

  9. Question 6. What Is Meant By Hot Spots?

    Answer :

    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. 

  10. Question 7. Difference Between Call By Value And Call By Reference?

    Answer :

    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.

  11. SAP BI Tutorial
    SAP MM Interview Questions

  12. Question 8. What Are The Different Types Of Data Dictionary Objects?

    Answer :

    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.
  13. Question 9. What Is Lock Object ?

    Answer :

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

  14. SAP BASIS Interview Questions

  15. Question 10. How To Eliminate Duplicate Entries In Internal Tables?

    Answer :

    SORT itab.

    DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

  16. SAP MM Tutorial

  17. Question 11. What Is The Basic Difference Internal Tables And Database Tables?

    Answer :

    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.

  18. SAP ABAP Interview Questions

  19. Question 12. How Many Ways You Can Create Table?

    Answer :

     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.
  20. SAP CRM Interview Questions

  21. Question 13. What Is Sql Trace?

    Answer :

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

    Tcode :st05

  22. SAP BASIS Tutorial

  23. Question 14. How To Creat Transactions?

    Answer :

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

  24. Question 15. Open Sql Vs. Native Sql?

    Answer :

    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.
  25. SAP ABAP Web Dynpro Interview Questions

  26. Question 16. Can You Create A Table With Fields Not Referring To Data Elements?

    Answer :

     Yes.

  27. SAP ABAP Tutorial

  28. Question 17. Which Database Object Is Used For Storing The System Variables?

    Answer :

    SYST table.

  29. SAP Workflow Interview Questions

  30. Question 18. Which Transaction Code Is Used Executing A Report (type 1 Program)?

    Answer :

    SE38

  31. SAP BI Interview Questions

  32. Question 19. When Is The Top-of-page Event Triggered?

    Answer :

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

  33. SAP ABAP Web Dynpro Tutorial

  34. Question 20. How Many Types Of Buffering?

    Answer :

    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.

  35. Sap Abap Hr Interview Questions

  36. Question 21. What Are The Different Types Of Locks?

    Answer :

    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.

  37. Question 22. What Are The Control Break Events In Abap?

    Answer :

    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.