SAP C_TAW12_750 Quiz 53 Topic 4 Questions 261-265

Question: 1

Which of the following are valid control level changes within a loop over an internal table? There are 2 correct answers to this question.

ALAST

BSUM

CEND of <f>

DCOLLECT

Show Answer

Question: 2

The USER has the following fields: ID, FIRSTJMAME, LAST_NAME. FIRST_NAME, LAST_NAME have the same basic type and length. You want to compare fields FIRST_NAME, LAST_NAME to each other.

Which of the following SELECT statements can you use?

There are 2 correct answers to this question.

Response:

(1/1 Points)

ASELECT*FROM users INTO TABLE lt_users WHERE first_name = users last_name

BSELECT*FROM users AS a INTO TABLE lt_users WHERE afirst_name = alast_name

CSELECT*FROM users INTO TABLE lt_users WHERE first name = users last_name.

DSELECT*FROM users AS a INTO TABLE lt_users WHERE a first_name = last_name.

Show Answer

Question: 3

What is the root class in the RTTS inheritance tree? Please choose the correct answer.

ACL_ABAP_TYPEDESCR

BCL_ABAP_ELEMDESCR

CCL_ABAP_DATADESCR

DCL_ABAP_COMPLEXDESCR

Show Answer

Question: 4

A structure has enhancement category 3, can be enhanced (character-type). Which set of elementary types is allowed for the new fields? Please choose the correct answer.

AF,I,P,X

BC,D,N,T

CC,D,N,X

DD,I,string, T

Show Answer

Question: 5

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.

ASELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjdAND b-division EQ 'Water' INTO TABLEIt_result WHERE kind = 'Residential'

BSELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd AND partner-kind EQ 'Residential' INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE division eq 'Water'.

CSELECT partjdcontjd from partner AS A LEFT JOIN contract AS b ON a-partjd = b-partjd INTO CORRESPONDING FIELDS OF TABLE lt_result WHERE kind = 'Residential' and AND division EQ 'Water'.

DSELECT partjdcontjd from partner LEFT JOIN contract on partner-partjd = contract-partjd AND contract-division EQ 'Water' INTO TABLE It result WHERE kind EQ 'Residential'.

Show Answer

SAP C_TAW12_750 Quiz:53 Topic:4 Questions:261-265