SAP ABAP Interview Questions and Answers - 8

31. In a Logical Database, one can define input fields on the selection screen with Select-
Options and Parameters statements.
32. Suppose a logical database program contains the following lines:
SELECT-OPTIONS CONNID FOR SPFLI-CONNID.
PARAMETERS CARRID LIKE SFLIGHT-CARRID FOR TABLE SFLIGHT.
What will be the output, for the above two statements?
Only select-options connid for spfli-carrid will be displayed on the screen.
33. Consider a report with F1S attribute, what will be the output for the following code.
Whether you will get the data from spfli and sflight or not, with corresponding tables
statement,
GET SPFLI.
GET SFLIGHT.
Write:/ spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid.
Yes, you will get the data from spfli and sflight.
34. Consider a report with F1S attribute, what will be the output of the following code.
Whether you will get the data from sbook or not, with corresponding tables statement.
GET SPFLI.
GET SFLIGHT.
Write:/ spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid.
You cannot extract data from sbook.
35. Identify any errors in the following code and correct the same, and what will be the
output.
If there exists corresponding tables statement, for spfli, sflight, sbook.
GET SPFLI.
GET SBOOK.
Write:/ spfli-carrid, spfli-connid, sflight-fldate, sbook-bookid, sbook-class.
No syntax errors. You will get data from all the three tables.
36. Does the following two statements do the same task?
If so which one takes less time and which one is recommended.
Select * from spfli where spfli-carrid = 'LH' and spfli-connid = '400'.
Endselect.
Select * from spfli. Check: spfli-carrid = 'LH' and spflid-connid = '400'.
Endselect.
-Yes they will do the same task. Second Select statement takes less time and is
recommended.

37. If you want to improve the response time (time to access data) Logical Databases
permits you to achieve this using VIEWS.
38. Is there any upper limit (max) to the possible number of nodes in a logical database
structure? If so what is the limit?
Yes, there is an upper limit for defining number of nodes in a Logical Database Structure.
Maximum nodes = 1200 / length where length = max. Length of name in the structure.
39. In the structure of Logical Database nodes at different levels are displayed in the same
columns. (T/F)
If false what types of nodes are displayed in the same columns. If true what type of nodes
are not displayed in the same columns.
False. Nodes at same levels are displayed in the same columns.
40. What are the advantages of Logical Databases?
It offers an easy-to-use selection screens. You can modify the pre-generated selection screen
to your needs. It offers check functions to check whether user input is complete, correct,
and plausible. It offers reasonable data selections. It contains central authorization checks
for data base accesses. Enhancements such as improved performance immediately apply to
all report programs that use the logical database.
41. Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB,
being defined in Database Program, we are defining the Dictionary Structures in the
Report. What is the reason for such declaration?
By declaring so we are providing work areas for data passing between Logical Database



Finance  economy  finance & insurance money derivatives wall street young money  got money cash money  get money

and Report. In addition, the logical database configures the selection screen depending on
the selection of database tables.
42. Is it mandatory to declare all the tables in Report by the key word tables for all the
tables that exist in the structure of LDB, and are being defined in the Database part of
LDB.
No, It is not mandatory to declare all tables in report.
43. If one wants to access data using Logical Database, the use of events is unavoidable.
(T/F).
True.