5. ABAP Dictionary Tables

Question 1

3 different table types in the SAP ABAP Dictionary

Answer 1

1. Transparent tables
2. Cluster Tables
3. Pool Tables

Question 2

Master Data

Answer 2

Refers to control tables and the traditional files that are necessary to run a business such as personnel files, general ledger accounts, customer files, etc.

There is a 1:1 correlation between the master data tables in the Dictionary and the tables in the physical database. For each master data table in the Dictionary, the same master data table exists in the physical database.

Large amounts of data which do not change often. It is often read, but
rarely updated. An example of master data is the data contained in an address file,
such as the name, address and telephone number. (APPL0)

Question 3

Commercial Data or transaction data

Answer 3

Is another SAP term used to refer to data created as a result of performing SAP business transactions such as creating: invoices, orders, production schedules, purchase requisitions, stock transfers, etc.

Question 4

Transparent Tables

Answer 4

Have a 1:1 correlation between the ABAP Dictionary and the physical database. For each TRANSP table in the dictionary, the same table name exists in the physical database

Question 5

Pooled Tables

Answer 5

Can be used to store control data, (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool

Question 6

Cluster Tables

Answer 6

May contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access

Question 7

Technical settings-Data class

Answer 7

Designates the table to an area in the physical database where similar tables are grouped

Question 8

Data class

Answer 8

Designates the table to an area in the physical database where similar tables are grouped

Question 9

Size Category

Answer 9

Identifies the amount of disk space that will be required to hold the data records for a table in the database

Question 10

Buffering

Answer 10

Determines whether table records will be accessed directly from the database server or from global memory.

Question 11

Loggin

Answer 11

Creates before and after images of changes to the table of contents. Logging must be activated by the profile when the system is started

Question 12

3 Classes of data

Answer 12

Master Data, Transaction Data, Organization and Customizing data

Question 13

Transaction Data

Answer 13

Data with temporary lifecycle, not stored long. Frequently
updated. An example of transaction data is the goods in a warehouse, which change
after each purchase order. (APPL1)

Question 14

Organization and cutomizing data

Answer 14

Specified when the system is configured and

then not often changed. An example is the table with country codes. (APPL2)

Question 15

3 Buffering Types

Answer 15

Single record, generic, full

Question 16

Single record-buffering type

Answer 16

Only a single record actually being processed is moved into the buffer. This type of buffering preserves buffer space but requires more database hits in order to load the table. Recommended for large tables when only a few records need to be accessed.

Question 17

Generic-buffering type

Answer 17

A subset of the table records are loaded based on part of the primary key. Recommended if only certain “generic” areas of the table will be needed.

Question 18

Full-buffering type

Answer 18

Results in either all of the table or none of it being loaded into the buffer. Recommended for a) tables up to 30 K in size, b) larger tables where access is needed to many records, and c) tables against which attempts to access data will frequently yield a “no record found” result.

Question 19

SCU3

Answer 19

Displays existing logs of a table

Question 20

Database utility is used to

Answer 20

Convert Data, Activate Objects, Create Tables and perform all standard table operations

Question 21

Index

Answer 21

An index is a set of fields from a table that is sorted and then stored in a location separate from the table itself. Each record in the index contains a pointer to matching record(s) in the actual database table.