3. Data Dictionary

Question 1

Data Dictionary

Answer 1

Is a centralized storage location for information about the data that is stored in a database .
A data dictionary provides answers to questions such as:
-What data is contained in the database?
-What are the attributes of this data: name, length, format, etc?
-What relationships exist among different data objects?

Question 2

Enforcing Data Integrity

Answer 2

is the process of ensuring that data entered into the system is logical, complete, and consistent.

Question 3

The basic objects of the ABAP Dictionary are

Answer 3

tables, data elements and domains.

Question 4

Data Base Utility

Answer 4

provides the interface between the ABAP Dictionary and the underlying database management system (DBMS).

Question 5

Transaction Code: Database Utility

Answer 5

SE14

Question 6

Transaction Code: ABAP Dictionary

Answer 6

SE11

Question 7

Field (Columns)

Answer 7

Is not a dictionary object, but rather is a component of a table. A field cannot exist without a table and only has meaning within that particular table.

Question 8

Records

Answer 8

Rows

Question 9

Primary Key

Answer 9

Is that field or combination of fields that uniquely identifies a row in the table

Question 10

Table fields are defined by

Answer 10

Data elements which in turn are assigned to a domain

Question 11

Data element

Answer 11

Provides a meaningful description for a field. It appears beside the field in a table definition. Unlike field names these descriptions are language-dependent. It provides field headings for use on screens. Data elements can be used more than once

Question 12

Search help

Answer 12

A Search help can be assigned to a data element. A search help is an object of the ABAP Dictionary with which input helps (F4 helps) can be defined.

Question 13

Domain

Answer 13

A domain specifies the technical characteristics and the allowed values of a field.
Domains are linked to fields via data elements. In other words, fields are assigned to data elements, and data elements are assigned to domains. You cannot directly assign fields to domains.

Question 14

SELECT/END SELECT statement

Answer 14

retrieves records one at a time from the database and puts them into the work area. The SELECT-ENDSELECT syntax creates a looping structure. In other words, all statements between SELECT and ENDSELECT are executed once for each record retrieved from the database.