Exploring Data Modeling in ABAP Flashcards

1
Q

What is the primary purpose of a database table definition in the ABAP Dictionary?

A

A database table definition in the ABAP Dictionary serves as a representation of the table on the database. It is independent from the details of the underlying database and contains the field list of the table along with additional table properties.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How does the ABAP Syntax check utilize the definitions in the ABAP Dictionary when accessing a database table?

A

The ABAP Syntax check analyzes the definitions in the ABAP Dictionary to ensure that the table and its fields exist when ABAP code accesses the database table in an ABAP SQL statement.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What role does the database Interface play at runtime when accessing a database table?

A

At runtime, the database Interface translates the ABAP SQL statement into database-specific SQL syntax and sends it to the database. It also queries the table definition in the ABAP Dictionary as part of this process.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the different types of data types provided by the ABAP Dictionary for ABAP code?

A

The ABAP Dictionary provides scalar types (data elements), structure types (structures), and table types as data types for ABAP code. These types are visible throughout the entire system.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why is it generally not recommended to use database table definitions as data types in ABAP code?

A

Because they are designed primarily to define database objects. It is better to use dedicated structure types instead for better clarity and maintainability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What additional tasks did the ABAP Dictionary fulfill in classical ABAP UI technologies?

A

In classical ABAP UI technologies, the ABAP Dictionary provided semantic information such as foreign key relations and search help bindings to dictionary objects. This information was used to enhance UI elements, providing end-user texts, value helps, input checks, and more.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Why is the discussion of ABAP Dictionary features related to classical ABAP UI programming not relevant for modern UI technologies?

A

Modern UI technologies, such as the ABAP RESTful Application Programming Model, use metadata in Core Data Services (CDS) entities to provide services for the user interface. Classical ABAP UI techniques are outdated and not supported in ABAP Cloud.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What were the limitations of the dictionary views in the ABAP dictionary?

A

Dictionary views in the ABAP dictionary were limited in terms of SQL logic, supporting only inner joins, field selection (projection), and simple filter conditions.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Why did SAP introduce Core Data Services (CDS) in ABAP?

A

the demand for executing logic directly on the database. CDS views support a wide variety of SQL expressions and functions to push down logic onto the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the two types of CDS views?

A

CDS DDIC-based views (obsolete) and CDS View Entities. CDS DDIC-based views use a generated dictionary view as a technical representation for the database object, while CDS View Entities define the database object directly without generating a dictionary object first (DEFINE VIEW ENTITY).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are annotations in the context of CDS view entities?

A

Annotations are code elements that enrich the technical view definition with semantic information. They start with an at-sign (@) and can provide additional context about the CDS view entity. Some annotations are evaluated by the ABAP system, while others are passed on to consumers of the CDS entity, such as frameworks like SAP Fiori and SAP S/4HANA embedded analytics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the role of Business Objects in the ABAP RESTful Application Programming Model (RAP)?

A

Business Objects in RAP structure data and add transactional logic to applications. They define the business entities and their behavior, facilitating data management and processing. They are modeled with one or more CDS view entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are some important ABAP CDS development objects?

A

Important CDS development objects include CDS Data Definitions, CDS Access Controls, CDS Metadata Extensions, and CDS Behavior Definitions. These objects collectively define the structure, access, and behavior of CDS entities within the ABAP system.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following are tasks of the ABAP Core Data Services?

A
Define views on the database.

B
Provide services for classical ABAP user interfaces.

C
Define Business Objects in the ABAP RESTful application programming model.

D
Define tables on the database

A

A
Define views on the database.

C
Define Business Objects in the ABAP RESTful application programming model.

You are right. ABAP Core Data services are used to define semantically enriched views, and Business Objects in the ABAP RESTful application programming model. Defining database tables and providing services for classical ABAP user interfaces are tasks of the ABAP dictionary.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which of the following ABAP Dictionary objects can you use as data types in ABAP code?

A
Database Table

B
Structure

C
Domain

D
Data Element

A

A
Database Table

B
Structure

D
Data Element

How well did you know this?
1
Not at all
2
3
4
5
Perfectly