SAP ABAP-DDIC OBJECT TWO IN SAP ABAP.

SAP ABAP DDIC DETAILS

37) What are Workbench objects/tools?

Ans: It is a collection of tools which can be used to develop the applications, change the existing applications & implement the customer specific business requirements.

38) What is Object Navigator?

Ans: It is the central point of entry to work with any kind of work bench objects such as Programs,DDIC objects, Function groups etc. The T-code is: SE80.

39)  What is Foreign Key?

Ans: A key field is defined as a table field & is primary key of another table is called foreign key.

Ø  The Check table field should be a primary key.

Ø  The Domain name of the Check table & foreign key table should be same but field name is different.

Ø  A search help is displayed to see the possible entries of a check table on the foreign key field when the foreign key table is executed.

40) What is a Client Dependent & Client Independent table?

Ans: The table which have the field MANDT field (Client no) is called Client Dependent table.The table which don’t have the MANDT field (Client no) is called Client Independent table.

41)  What are Key field & Non-key fields?

Ans: The key fields don’t allow duplicates. It contains unique data. The key field check boxes are  checked to make the fields as primary key.

The non-key fields may/mayn’t allow duplicates. The key field check boxes are unchecked.

42)  What is Initial Value Check box?

Ans: The Initial Value Check box is checked to take the default field values of the key fields for the 1^st time.

43) Differences between the tables created using Data elements & Pre-defined types?

Data elements	Pre-defined types
1. Data elements can be reused	1.Reusabilty is not possible
2. Foreign key relationship can be created since     it contains domains.	2. Foreign key relationship in not be created.
3. Field labels(Headings) are displayed while      maintain the table.	3. ‘+’ symbols are appeared while maintaining the table instead of field labels.

44)  What is a Logical Database?

Ans: Logical Databases are ABAP programs that retrieve data and make it available to application programs. Use of LDB – is used to read data from database tables by linking  them to executable ABAP programs.

45) What is Hotkey?

Ø  This is used to select the elementary search help from the collective search help.

Ø  To enter the restrictions in the dialog box for restricting values directly from the entry field.

Advantage: If the user often searches for values using the same search help, this procedure can save time.

46) What are the Important Tables to store the Definitions of DDIC?

Table	Short Text
DD01L	Domains
DD01T	Domain Texts
DD02L	SAP Tables
DD02T	SAP Table Texts – To find table names using Short Description
DD03L	Table Fields
DD03T	Texts for fields
DD04L	Data Elements
DD04T	Data Element Texts
DD05S	Foreign Key Fields
TSTC	Transaction Codes
TFDIR	Function Modules

47) Explain about Currency or Quantity fields in DDIC?

Ø  In SAP the currency & quantity fields are required currency key & quantity unit. Hence, the reference table & the reference field must be specified for currency & quantity fields.

Ø  The data type for the currency field is ‘CURR’ & the data type for the currency key is ‘CUKY’.

Ø  The data type for the quantity field is ‘QUAN’ & the data type for the quantity key is ‘QUAN’.

Ø  The reference table could be any table which has the currency key & quantity unit fields.

Ø  The same table can also be used as a reference table if it has the currency key or quantity unit fields

48) What are different types of Data Dictionary Objects?

1.    Database Tables

2.    Domains

3.    Data types

a.    Data element

b.    Structure

c.    Table type

4.    Search helps

a.    Elementary search help

b.    Collective search help

5.    Views

a.    Database view

b.    Maintenance view

c.    Help view

d.    Projection view

6.    Lock objects

a.    Write/Exclusive Lock

b.    Read/Shared Lock

c.    Exclusive But not Cumulative

7.    Type groups

Ø  The Objects Views, Match Code and Lock objects are called Aggregate Objects because they are formed from several related table.

49) What is Client & Server?

Ø  Client: It is a software/hardware combination which can send the requests for services from  the central system.

Ø     Server: It is a software/hardware combination which can provide the services to a group of clients.