Data Dictionary Questions and Answers in 2015

1.What is foreign key ? how many types of foreign key in DDIC?

Ans.
     It accepts duplicate values as well as null value for a table field in data dictionary,we use foreign key to make relation ship between two tables with primary key.


there are three types of foreign key:

1.Full foreign key
2.Generic Foreign Key
3.Constant Foreign key

Full foreign Key- As you know foreign key is based on two tables,in this case we used all primary key in this type.


Generic Foreign Key-In this type you have a option to select which primary key you want to use among all the primary keys.


Constant Foreign Key-In this type you have a option to fixed a constant value.

2. What is conversion Routine?

Ans.Conversion routines are identified by a five-place name and are stored as a group of two function modules. The function modules have a fixed naming convention. The following function modules are assigned to conversion routine xxxxx:

• CONVERSION_EXIT_xxxxx_INPUT
• CONVERSION_EXIT_xxxxx_OUTPUT

the INPUT module converts from display format to internal format, and the OUTPUT module converts from internal format to display format.

Example: suppose you have create a custom table and there is field name Empid




3. Is it possible to create a table without using data element and domain? if yes support your answer and if no then support your answer?

Ans.yes it is possible to create a table without using data element and domain.

to create goto SE11-put a table name like Z**** then clik on create

Step-2-click on predefined ,then you saw some editable part on the screen to put datatype and size

Step-3-on that part you put your data type and size then activate

in this way you create a table without using data element and domain.


4.what is type group,what is the naming convention of type group structure,how you create a type group?


Type Group:-

It is the container of group of structures,it is 5 digits/character maximum ..

to create the type group use tcode SE11 and the structure name should start with the type group name.
it is mandatory to start the structure name with the type group name.

To create:

Step-1

Goto SE11 check the radio button type group and put name with Z or Y. then click on create

then you get a popup screen on that part you put the short description of type group and save in a package then you get a editor like this

then declare structure in your editor but you have to start the structure with the type group name

then activate the type group.

there are some type groups in standard like SLIS .KKBLO etc just check .