The two queries below, which is more efficient? | SAP Hana Mcqs


a. Matmoves = SELECT * FROM MSEG
FOR EACH matmove in matmoves
IF matmove.whichPlant = “I” THEN
Plant_text = SELECT plant_text FROM WERKS WHERE id = matmove.plant
ELSE
Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.
plant
END

b. If which_plant = “I” THEN

Plant_text = plant_int_text

ELSE
Plant_text = plant_ext_text


Ans: b

This entry was posted in SAP Hana MCQs. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *