SAP
C_TAW12_750 · Question #243
C_TAW12_750 Question #243: Real Exam Question with Answer & Explanation
Sign in or unlock C_TAW12_750 to reveal the answer and full explanation for question #243. The question stem and answer options stay visible for context.
Question
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.
Options
- ASELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjdAND b-
- BSELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd AND
- CSELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjd INTO
- DSELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd AND
Unlock C_TAW12_750 to see the answer
You've previewed enough free C_TAW12_750 questions. Unlock C_TAW12_750 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.