When is a foreign key check performed on an input/output field?
Please choose the correct answer.
Response:

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.

You can call a module for the FIELD statement to validate user entry on the input field. You can validate the entry on the input field and send an error or a warning message from an ABAP dialog module.

What does the enhancement category for a database table or structure do? Select all that apply.

You want to select data from two tables and store the result in as structure.
Table PARTNER contains the fields PARTJD and KIND.
Table CONTRACT contains the fields CONTJD, CONT_TYPE and DIVISION.
The structure is defined as follows
DATA: BEGIN OF wa_result,
Part_id type partner-partjd, cont_id type contract-cont_id,
ConMype 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 partjd from partner INTO wa_result WHERE kind = 'Residential'.
SELECT contjd 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.