Interview question for DDIC in ABAP.

 1. What is sap Abap.

  * Advanced business application programming.

* It is a technical module.

* ABAP is used to develop reports, interfaces, conversions,enhancements,forms and workflow objects.

* ABAP is the 4th generation language.

2. How many ABAP / 4 editors in sap ABAP.

* There are two types.

    - SE80 - To create package, program, function group, function module, class/interfaces etc.

    - SE38 - ABAP editor initial screen. 

3. what is sap data dictionary.

* DDIC is also called as ABAP dictionary.

* It allows us to create and maintain the repository objects related to database.

* To create table, domain, data element, types, search help and loc objects etc.

* T-code - SE11.

4. What are the data dictionary objects in sap abap.

* Tables

- First object of DDIC.

- It is used to store data.

- standard tables - a-x.

- custom tables - y & z.

* Views

* Database View

    - Database view is created by joining multiple tables.

* Maintenance View: 

    - Maintenance View used to maintain multiple table data using the table maintenance generator (SM30).

* Help View: 

    - Help view is used to provide multiple possible entries in selection method of elementary search help by combining multiple tables.

* Projection View: 

    - Projection view is used to only hide the unwanted fields from a table and create a new view to use only selected fields.

* Data types

* Data element 

    - data element contains domain and field label of fields.

or

    - It is the collection of domain with short description.

* Structure

    - Structure is used to store data in run time.

    - To define a table type we must first define structure of that table type.

* Table type 

    - 

* Domain

- To maintain the technical properties of field in table like data type, size etc.

- It is also used to maintain the value table of field to provide the search help of that field.

or

- It is the collection of data types and lengths.

* Search helps

- To provide all possible entries to the input parameters as a search help.

- There are two types

* Elementary - created by using single table.

* Collective - created by using multiple search help.

* Lock Object

- Lock object is used to lock the particular object which is using by multiple users to avoid parallel access. 

- Transaction code SM12 is used to see all locked objects list.

5. Explain the Technical properties of database table.

* Delivery class.

- Delivery class consist in Delivery and Maintenance tab of Database table object.

- Delivery class used to specify type of table and it is also used to control the transport of table data.

- Delivery class A, C, E, G, L, W, S.

- We commonly use delivery class C.

- To maintain the data in any client we will use delivery class A

* Data Browser

-  Data Browser/ Table View Maint is also consisting in Delivery and maintenance tab of Database table object.

-  3 entries “Display/ Maintenance not allowed”, 

     “Display and Maintenance allowed” and 

     “Display/ Maintenance allowed with restriction”.

* Data Class

- Data class specify the type of table; it contains 6 entries

APPL0: Mater data, Transparent table -* data we can access frequently as well as update rarely.

APPL1: Transaction data, transparent table -* data we can access frequently as well as updated frequently.

APPL2: Organization and customizing -* data we can access frequently & updated rarely...

DDIM: Dimension table in BW.

DFACT: Facts table in BW.

DODS: ODS table in BW

* Size Category

- Size category is used to define initial space of defined table in the database.

- Commonly we used ‘0’ for in size category.

* Buffering 

- It is also shown in technical settings-General Properties. 

- Commonly we used Buffering not allowed.

* Enhancement Category 

- Enhancement category shown in Extras->Enhancement Category. 

- We commonly used ‘’Can Be Enhanced”.

6. What is TMG (Table Maintenance Generator)?

- TMG is used to maintain the entries in production system. 

- By TMG you can create and delete entry directly in Table by using Transaction code SM30.

7. What is the difference between value table and check table?

* Check table is defined using foreign key concepts.

* Value table is defined to use in search help. 

* Value table defined in domain level. 

* Check table can be used to retrieve data from table in a program, but value table can’t be used in program.

8. How many types of database tables explain them?

* Transparent tables

- Transparent tables has one to one relation.

- Transparent table is used to store application data which represent master and transactional data.

- for example, master data of vendors stores in vendor master and customer data of customer stores in customer master.

* Pooled Tables

- Pooled table has many to one relationship.

- Pooled table has only primary index we can’t create secondary index in pooled table.  

- Pooled tables can be used to store control data screen sequences, program parameters or temporary data

* Cluster Tables

- Cluster tables has many to one relationship like pooled table.

- Cluster table has used when the constituent tables have a common primary key.

9. Define Include Structure.

* Include Structure is used to add fields in our table or enhance the tables.

* It is only used for standard table. 

* Include structure can add multiple tables.

10. Define Append Structure.

* Append Structure is used to add fields in our table or enhancements of the table. 

* Append structure can be used only in one table. 

* Append structure can be added only at the end of the table.

11. What is the data type of Currency field and Currency Key?

* The data type of that currency field is “CURR”, and the currency key is “CUKY”.

12. What is the data type of Quantity Field and Quantity Key?

* The data type of that quantity field is “QUAN” and the quantity key is “QUAN”.

13.  What is Hotkey?

* Hotkey is used to select the elementary search help from the collective search help.

14. What is Key field and non key field?

* Key field has unique entries in table.

* Non-Key fields are fields where key check box is unchecked.

15. What is Foreign Key?

* Key field is defined in a table is primary key and the same field is defined in another table as key field is called a foreign key of that table. 

* Check table concept is related with foreign key.

or

* Foreign key is a field in one table. 

* This is connected to another table via foreign key relationship. 

* The purpose is to validate the data being entered in one table (foreign key table) by checking against list of possible values in another table.

16.  What are the methods of modifying SAP standard tables?

* To modify standard tables, we can use “Append Structure” and” Customize Includes”.

17. In Which language SAP is Developed?

* SAP developed in ABAP/4 (Advance Business application Programming) language. 

* It is a 4th generation programing language

18. What is RICEFW in SAP ABAP?

* RICEFW stands for Reports, Interface, Conversion, Enhancements, Forms and Workflow.

19. What is text table in DDIC?

* Text table is created when we need to store explanatory data in multiple language.