Unit 1: Data Dictionary
1)Domain
2)Data element
3)Table creation
4)Structure creation
5)Table type creation
6)Search help creation
6.a) Search help exit
7)Table maintenance generator – One step, Two step
8)Transparent, pooled & Cluster tables
9)Append & Include structures
10)Lock objects
11)Type group
12)Views – Database view, Projection view, Maintenance view, Help view
13)Events in TMG
14)Conversion routine
15)Text table
16)Secondary Index
17)Primary key & Foreign key relation ship
18)Check table & Value table
19)Working with currency & Quantity fields
20)Buffering
21)Data class, Delivery class & Size category
Lower case check box: If we select this check box, then data will be stored in either lower case or upper
case or mixed case as entered by user. If we unselect this check box, then data will be stored in mixed
case.
Value Table: The contents of value table will not be used in F4 help.
Interview Questions:
1)What is domain?
2)What is data element?
3)What is primary key & Foreign key relationship?
4)Explain difference between include and append structure?
5)Can we use same append structure in more than one database table?
6)How to handle currency & quantity fields in database table?
7)Explain secondary index in DDIC?
8)what is table maintenance generator?
9)What is one step and two step in TMG?
10)What is type group?
11)what is search help and types of search helps?
12)Explain these terms – Table maintenance, Data class, Delivery class, Size category?
13)Explain buffering and types of buffering?
14)What is view and types of view and explain each view?
15)What are different types of database tables?
16)What are the maximum number of structures that can be included in a table?
17)If a table that is to be extended contains a long field, we can not use append
18)What are the ways for restricting a value range for domain?
19)What are conversion exits?
20)What are lock objects and explain the FM’s in lock objects?
21)What is the difference between check table and value table?
22)What are events in TMG?
23)What is the difference between table and view?
24)Can I use all the views in ABAP program?
25)How do you adjust the database table (Delete or change field after having data of it) after making
changes to it?
26)In which table, programs, database tables etc. are stored?
27)When I create new entries in table, field values are always in upper case. How do I get mixed case
data?
28)what is the difference between structure and table type?
29)What is text table?
30)What is match code object? Have you ever used in program?
31)How to get domain fixed values programmatically in an ABAP program?
32)Tell me some of ABAP system variables and how they are filled?
33)Explain about version management in reports
34) Hot key concept, Search help exit ,?
35)What is LPOS, SPOS in search help creation?
36) How to move table entries from one system to other system?