TAW_10_1 chapter 12, data modeling and data retrieval Flashcards
What is SERM?
Structured Entity Relationship Model
What is the logical path to building an SERM
real world->ERD->Data dictionary->Database
What is the SAP path to view data models?
SE84->business engineering->data modeling->data models
What are the reuse components for database access?
Logical Databases
Function Modules
BAPIs
Methods of global classes
What are the four main clauses of a database read access
SELECT
FROM
WHERE
INTO
If I have 4 fields in my select clause, and 6 fields in my INTO structure. What must be true for this to work?
The first 4 fields of the structure must have the same types as the four fields of the select
If I use into corresponding fields of , what happens if the source and target fields have the same name but different types?
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
What types of joins are supported by ABAP?
INNER
LEFT OUTER
RIGHT OUTER
In an INNER join, what is selected?
Rows of data that intersect. That is a row in the left and a row in the right exist for the key (on clause).
In a LEFT OUTER join, what is selected
All rows from the left table and rows from the right table that have a matching left table.
In a RIGHT OUTER join, what is selected
All rows from the right table and rows from the left table that have a matching right table.
What are the 5 database actions available in ABAP
SELECT INSERT UPDATE MODIFY DELETE
What is the menu path to authorization stuff
Tools->ABAP workbench->Development->Other tools->Authorization objects
Where are authorization objects defined. As in what do they belong to?
Object classes