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.
Wähle eine der folgenden: