TAW_10_1 chapter 12, data modeling and data retrieval Flashcards

1
Q

What is SERM?

A

Structured Entity Relationship Model

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

What is the logical path to building an SERM

A

real world->ERD->Data dictionary->Database

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

What is the SAP path to view data models?

A

SE84->business engineering->data modeling->data models

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

What are the reuse components for database access?

A

Logical Databases
Function Modules
BAPIs
Methods of global classes

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

What are the four main clauses of a database read access

A

SELECT
FROM
WHERE
INTO

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

If I have 4 fields in my select clause, and 6 fields in my INTO structure. What must be true for this to work?

A

The first 4 fields of the structure must have the same types as the four fields of the select

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

If I use into corresponding fields of , what happens if the source and target fields have the same name but different types?

A

SAP will attempt to convert the data but problems such as truncation can occur. This also happens for INTO TABLE if the types don’t match

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

What types of joins are supported by ABAP?

A

INNER
LEFT OUTER
RIGHT OUTER

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

In an INNER join, what is selected?

A

Rows of data that intersect. That is a row in the left and a row in the right exist for the key (on clause).

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

In a LEFT OUTER join, what is selected

A

All rows from the left table and rows from the right table that have a matching left table.

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

In a RIGHT OUTER join, what is selected

A

All rows from the right table and rows from the left table that have a matching right table.

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

What are the 5 database actions available in ABAP

A
SELECT
INSERT
UPDATE
MODIFY
DELETE
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the menu path to authorization stuff

A

Tools->ABAP workbench->Development->Other tools->Authorization objects

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

Where are authorization objects defined. As in what do they belong to?

A

Object classes

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