You want to select data from two tables and store the result in as structure.
Table PARTNER contains the fields PART_ID and KIND.
Table CONTRACT contains the fields CONT_ID, CONT_TYPE and DIVISION.
The structure is defined as follows
DATA: BEGIN OF wa_result,
Part_id type partner-part_id, cont_id type contract-cont_id,
Cont_type TYPE contract-cont_type,
END of wa_result,
Lt_result type table of wa_result.
How can you replace the following SELECT statement with an outer join?
SELECT part_id from partner INTO wa_result WHERE kind = ‘Residential’.
SELECT cont_id from CONTRACT into wa_result-cont_id WHERE part EQ
wa_partner-part_id And DIVISION eq ‘Water’.
Append wa_result to lt_result.
ENDSELECT.
If sy-subrc<>0. CLEAR wa_result-cont_id
APPEND wa_result TO lt_result. ENDIF.
ENDSELECT.
Please choose the correct answer.
Response:

A.

SELECT part_idcont_id from partner LEFT JOIN contract on partner-part_id = contract-part_id AND
partner-kind EQ ‘Residential’ INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE division eq
‘Water’.

B.

SELECT part_idcont_id from partner AS A LEFT JOIN contract AS b ON a~part_id = b~part_id INTO
CORRESPONDING FIELDS OF TABLE lt_result WHERE kind = ‘Residential’ and AND division EQ ‘Water’.

C.

SELECT part_idcont_id from partner AS A LEFT JOIN contract AS b ON a~part_id = b~part_id AND
b~division EQ ‘Water’ INTO TABLElt_result WHERE kind = ‘Residential’

D.

SELECT part_idcont_id from partner LEFT JOIN contract on partner-part_id = contract-part_id AND
contract-division EQ ‘Water’ INTO TABLE lt_result WHERE kind EQ ‘Residential’.

Which of the following are valid combinations of event visibility and handler method visibility?
There are 2 correct answers to this question.
Response:

A.

Public event and protected handler

B.

Protected event and public handler

C.

Private event and public handler

D.

Private event and private handler

Which of the following is a true statement?
There are 3 correct answers to this question.
Response:

A.

All customer repository objects have to be assigned to a package.

B.

Packages use interfaces and visibility to make their elements visible to other packages.

C.

The transport layer is a mandatory input fD. A package can be nested.

D.

A package can be nested.

What is the best order to provide an event handler for an ALV?
Please choose the correct answer.
Response:

A.

Create the ALV, write the handler, register for the event, display the ALV

B.

Register for the event, write the handler, create the ALV, display the ALV

C.

Write the handler, register for the event, create the ALV, display the ALV

D.

Write the handler, create the ALV, register for the event, display the ALV

E.

Write the handler, create the ALV, display the ALV, register for the event

A transport company keeps track of this availability in two tables, table VEHICLES and table
TRANSPORT. To accept a new transport of a certain capacity must be found in table VEHICLES. If a
record is found, a record is created in table TRANSPORT. The capacity is then adjusted in table
VEHICLES.\
You have four function modules at your disposal.
UPD_VEHI_A and UPD_VEHI_B update a matching report in table VEHICLES. If an error occurs both
issue a message of type X. If no error occurs only UPD_VEHI_A issues a message of type X. If no error
occurs UPD_VEHI_A issues a message of type I.
UPD_TRAN_A and UPD_TRAN_B create a single record in table TRANSPORT. If an error occurs both
issues a message of type X. If no error occurs only UPD_TRAN_A issues a message of type I.
Which of the following function module calls ensures a single logical unit of work?
Please choose the correct answer.
Response:

A.

1.UPD_VEHI_A
2.UPD_TRAN_B

B.

1.UPD_VEHI_A
2.UPD_TRAN_A

C.

1. UPD_TRAN_A
2. UPD_VEHI_B

D.

1. UPD_TRAN_B
2. UPD_VEHI_B

What are the declarative statements used to define the selection?
There are 3 correct answers to this question.
Response:

A.

PARAMETERS

B.

SELECT-OPTIONS

C.

SELECTION-SCREEN

D.

None of the above

What is the default length of the type C data type?

A.

1

B.

10

C.

1–65535

D.

100

In which sequence are the following ABAP Events triggered?
Please choose the correct answer.
Response:

A.

START-OF-SELECTION
AT SELECTION-SCREEN
3. INITIALIZATION

B.

AT SELECTION-SCREEN
INITIALIZATION
3. START-OF-SELECTION

C.

INITIALIZATION
AT SELECTION-SCREEN
3. START-OF-SELECTION

D.

INITIALIZATION
AT SELECTION-SCREEN
3. START-OF-SELECTION

E.

INITIALIZATION
START-OF-SELECTION
3. AT SELECTION-SCREEN

What do you need to consider when creating a secondary index on a table?
There are 2 correct answers to this question
Response:

A.

The index must always be unique

B.

The table will be updated more quickly if you create more indexes

C.

The most frequently selected fields should be at the first positions in the index

D.

The index can be created for specific database systems only

Which of the following rules must you follow when creating subscreens?
There are 2 correct answers to this question.
Response:

A.

Subscreens CANNOT have a field of type OK.

B.

Subscreens can have a dialog module containing SET PF-STATUS.

C.

Subscreens can call other subscreens.

D.

Subscreens CANNOT have an AT EXIT-COMMAND module