Week2

Submit

3. In which of the following types there is an one-to-one relationship between the table defined in ABAP dictionary and the relevant physical table in database

Structure

Cluster table

Pool table

Transparent table

4. You have defined a screen with required entries. You want the "CANCEL" function to work even if all the required entry field are not filled. How can you do this?

There is no way to do this; required entry fields must always be filled first

No special actions are required.

The "CANCEL" function must have function code "BACK"

The "CANCEL" function must be type "E" and be handled in a module with AT EXIT-COMMAND.

You must temporarily switch of the required entry of the field within LOOP at SCREEN..ENDLOOP.

5. Which statement at the time of AT SELECTION-SCREEN causes the selection screen to be displayed again and fields ready to input and message in the status line?

A MESSAGE I ... statement

An AUTHORITY-CHECK statement which returns sy-subrc NE 0

A MESSAGE E .... statement.

6. What do you get when you refer to client specific transparent table in the ABAP Dictionary , if you have data definition with DATA?

An Internal table

A Field

An Object

Structured Work Area (line)

7. If you create a variant for a report program(zrep) , and name the variant as zvar00. When you transport the report (zrep) will the variant (zvar00) also automatically transported

Yes

No

For automatic transportation customer should create the variant with naming convention CUS&xxx, for any other name for variant need to be added manually in the change request

Explanation

For automatic transportation customer should create the variant with naming convention CUS&xxx, for any other name for variant need to be added manually in the change request

8. If as a programmer or development manager, you want to check the performance of your ABAP programs, What tool does SAP provide to do this

ABAP debugger

SQL TRACE

Code Inspector

Not possible, as the tools are only available for BASIS administrators

9. In which of the following events, would you ideally write the validation code for the data entered in the selection screen by the user

PAI

AT SELECTION-SCREEN OUTPUT

AT SELECTION-SCREEN INPUT

AT SELECTION-SCREEN

AT SELECTION-SCREEN ON REQUEST

At Selection-screen should be used for all validations, as if you raise any message of type E it will stop the processing and the error field will be ready to input

Explanation

At Selection-screen should be used for all validations, as if you raise any message of type E it will stop the processing and the error field will be ready to input

10. Does a PAI occur when you switch between tab pages whose titles have function type 'P' in a tabstrip

No

Yes, if at least one PAI module exist in subscreen container

Yes, if at least one required entry field exists on one of the tab pages

Yes always

11. If Primary Key of a table is also a Foreign key to another table which of the following is the Foreign Keys characteristics

Key Fields of text table

Key Fields of Primary Table

Key Fields/Candidates

No Key Fields/Candidates

12. Changes to Active transparent table : the type for the non key field is to be changed from NUMC to CHAR. What follow up actions are to be expected?
(more than 1 correct answer)

If the table already contain data, SAP either make such changes using ALTER TABLE or using the conversion process

If the table does not contain any data, SAP drops and recreates the table with new definition

Submit

13. Which of the following statements about indexes are correct (More than 1 correct answer)

A database table can have more than one index.

A primary index consists of the primary key fields of the database table.

An Index can be assigned to several tables.

Using indexes speed up the data retrieval from table

Using Indexes speeds up the transaction process for the table.

Submit

14. Which of the following assertions are right. (More than 1 correct answer)

Field of the foreign key table to be checked is called Check field.

Field of the Primary Key Table is called check field.

For Check field and referenced key field Data Element should be exactly same.

For Check field and referenced key field Data Element can be different but domain should be exactly same.

Submit

15. Evaluate the following code snippet

data: it_sflight type table of sflight.

Authority-Check Object 'S_CARRID'
ID 'CARRID' field 'AA'
ID 'ACTVT' field '03'.
select * from sflight into table it_sflight where carrid = 'AA'.
Assuming there is no syntax error, which of the following would be valid

If the Authority-Check fails, you need to check the return code sy-subrc, else it will return all the rows

Explanation

If the Authority-Check fails, you need to check the return code sy-subrc, else it will return all the rows

16. Which conditions must be fulfilled in a programmed check so that s screen input field is made ready for input again ?
(More than 1 correct answer)

The module must output an E type message or W message

The check module must be calling using : FIELD fileldname MODULE check_module

The check module must be calling using : FIELD fileldname MODULE check_module message Exxx

An I type message must be output

Submit

17. Which of the following statements about subscreen are correct
(more than 1 correct answer)

Statement LEAVE TO SCREEN is not allowed in Subscreens PBO/PAI

You can call subscreen using screen command CALL SUBSCREEN

You can call subscreen using ABAP command CALL SUBSCREEN

Subscreens have their own OK CODE field

Submit

18. Which of the following are valid screen flow logic statements if you want the module to be executed when a single field content are not equal to initial value

Module first AT EXIT-COMMAND

Field fname Module first ON INPUT

CHAIN.FIELDS: fnames Module first on CHAIN-REQUESTENDCHAIN.

Field fname Module first ON REQUEST.

19. Evaluate the following code snippet
data: wa_spfli type spfli.
select-options : so_carr for wa_spfli-connid.

select * from spfli into wa_spfli where carrid in so_carr.
write:/ wa_spfli-carrid, wa_spfli-connid.
endselect.

When you run the above report, assuming that user do not key in any values in selection screen .Which of the following statement are true in this condition

All the records from spfli will be displayed in the list

No rows will be displayed as user haven't entered the value in selection screen

Instead of IN operator in where clause, if = operator is used it will display only one row

If the select-options is empty , then all the rows from the table is fetched.

Explanation

If the select-options is empty , then all the rows from the table is fetched.

20. Which of the following one are correct sequence mechanism for determining the input Help or search help?

Search Help for Field, Check Table, Search Help for Dataelement

Search Help for Field, Check Table, Fixed Values

Process on Value-Request,Domain Fixed Value, check table

Check Table, Search help for Field, Search Help for Dataelement, Fixed Values

21. To interrupt the processing of the current screen and branch to new screen, or sequence of screen, you can use which of the following statements
(Only 1 correct answer)

CALL SCREEN

SET SCREEN

LEAVE SCREEN .

LEAVE TO SCREEN

Call Screen will suspend(interrupt) the current call and branch to the specified screen , once all the screen sequence is over it returns to process the remaining module code.

Explanation

Call Screen will suspend(interrupt) the current call and branch to the specified screen , once all the screen sequence is over it returns to process the remaining module code.

22. Which of the following statements about field transport from ABAP to screen are correct
(more than 1 correct answers)

Field transport from screen to ABAP is delayed if you have a FIELD statement

Name equivalence is imperative for field transport between ABAP and screen

Field transport from ABAP to screen generally takes place before the first PBO module of the screen

For the screen fields from Dictionary tables or structures you need to create data object in ABAP using TABLES keyword

If you give a Field statement in PAI, the transport of the all the fields are not done,
For any transport between ABAP to Screen there should be same name data object in ABAP as well as Screen
From ABAP to screen first PBO modules gets executed then the transport takes place from ABAP to Screen.
If you have made screen fields from Dictionary table/structures then in ABAP you have to use the TABLES keyword to create the data object

Explanation

If you give a Field statement in PAI, the transport of the all the fields are not done,
For any transport between ABAP to Screen there should be same name data object in ABAP as well as Screen
From ABAP to screen first PBO modules gets executed then the transport takes place from ABAP to Screen.
If you have made screen fields from Dictionary table/structures then in ABAP you have to use the TABLES keyword to create the data object

Submit

23. Which of the following statements are true
(more than 1 correct answer)

A key field in database table uniquely identifies the data record

A secondary index for non key fields generally works like a primary index of key fields

The client field is selective field and should always be specified in WHERE condition of SELECT statement

You can select from several tables using database view or joins in your program

OPEN SQL statement are converted into database specific statements by the database interface

Submit

24. Which of the following calls will return the control back to the calling program (More than 1 correct answer)

Call Transaction

Leave Transaction

Submit

Submit ... and return

Submit

25. Which of the following view supports left outer join?
(more than 1 correct answer)

Database View

Projection View

Maintainence View

Help View

Outer Join View

Submit

26. In Program ZPROG , the submit statement is used to call a report ZREP , how can you pass the data from ZPROG to ZREP?
(more than 1 correct answer)

By declaring same name data object in ZPROG and ZREP, as the name is same value gets automatically copied.

Using ABAP memory

By passing parameters using additions in submit statement e,g submit zrep with

Using SET/GET parameter ID

If you are calling a report (and if that report has selection screen) you can use submit with parameters =
You can also use ABAP memory (EXPORT /IMPORT)
You can use SAP memory (SET/GET Parameter)

Explanation

If you are calling a report (and if that report has selection screen) you can use submit with parameters =
You can also use ABAP memory (EXPORT /IMPORT)
You can use SAP memory (SET/GET Parameter)

Submit

27. In the PAI of screen 100 following flow logic statements are written, assuming you have 4 fields in the screen named f1,f2,f3 and f4 Module setStatus.
Field f1 module pai_f1_100.
Field f3 module pai_f3_100.
Module pai_4_100.
When module setStatus is executed which of the following fields are already transported to ABAP.

F1

F2

F3

F4

Submit

28. For Search Help you should have

Atleast one import parameter

Atleast one export parameter

One import and one export parameter minimum

Both import and export parameters are optional

29. Which of the following statements are true about push buttons
(More than 1 correct answer)

With Function Code 'E' causes program termination

On a screen always have a corresponding function key

In application toolbar always have corresponding function key

In application toolbar always have function code

Every Push button created in Application toolbar(GUI Status) should have a function key and Function Code.
Every Push button created in screen only have function code, function key is not required.
Function Code of type E is only used if you have a module AT EXIT-COMMAND in the PAI

Explanation

Every Push button created in Application toolbar(GUI Status) should have a function key and Function Code.
Every Push button created in screen only have function code, function key is not required.
Function Code of type E is only used if you have a module AT EXIT-COMMAND in the PAI

Submit

30. Authorization concept in SAP System is used for (More than 1 correct answer)

SAP System uses this Authorization concept for individual Database to provide access security.

Each application in SAP System is protected by Authorization.

Using Authorization critical data and parts of functional scope of the SAP system can be protected from unauthorized access

Authorizations are combined into profiles

Submit

31. If the following Open SQL select statement gives only one row as the output what could be possible reasons.
Select * from tab into wa where col = pa_col.
write: wa-col1, wa-col2, wa-col3.
EndSelect. (More than 1 correct answer)

Select statement retrieves only one row from database

Select statement syntax is wrong, Select single should have been used

New line statement should be added to the write

In the where clause in operator should be used instead of =.

Submit

32. Is it possible to increase number of key fields in the transparent table that is active?

Yes, however the table must be empty

Yes, irrespective of whether table has data or not

No, key changes are not allowed once activated

33. Which of the following statements about SELECT statement are correct?
(More than 1 correct answer)

With SELECT .... ENDSELECT access,at any particular time you have one data record maximum.

With SELECT .... INTO TABLE access, the result is 1 data record maximum.

With SELECT SINGLE * access, the result is 1 data record maximum

SELECT statement will always load data into SAP memory

SELECT statement supports the return code (sy-subrc)

Submit

34. Which of the following syntax are correct for open SQL statement Select (More than 1 correct answer)
Assuming that transparent table tab exists in ABAP dictionary and following declarations are done in the program already
data: wa type tab.
data: it_tab type standard table of tab.

Select single * into wa from tab. ……….EndSelect.

Select * from tab into it_tab.

Select * from tab into corresponding fields of wa..........EndSelect.

Select * from tab into table it_tab.

Select single * into corresponding fields of wa from tab

For storing values in work area you can use
1) Select single * from tab into wa
2) Select single * from tab into corresponding fields of wa.
3) Select * from tab into wa. EndSelect.
4) Select * from tab into correspoding fields of wa. EndSelect.

For Storing data in internal table you can use
1) Select * from tab into table it_tab.
2) Select * from tab into corresponding fields of table it_tab.

Explanation

For storing values in work area you can use
1) Select single * from tab into wa
2) Select single * from tab into corresponding fields of wa.
3) Select * from tab into wa. EndSelect.
4) Select * from tab into correspoding fields of wa. EndSelect.

For Storing data in internal table you can use
1) Select * from tab into table it_tab.
2) Select * from tab into corresponding fields of table it_tab.

Submit

35. Which of the following are true about Generic Buffering. (More than 1 correct answer)

Generic Buffering is always done using generic keys

Generic keys can be any columns of the table

All fully buffered client dependent tables are generically buffered on mandt

All Fully buffered tables are generically buffered by primary key.

Generic keys for Generic buffering should be less than number of Primary Keys

Submit