SAP Exam C_TB1200_93 Topic 3 Question 10 Discussion

Actual exam question for SAP's C_TB1200_93 exam

Question #: 10
Topic #: 3

You create a query for an approval process to check for service purchase orders over 3000 in value. When you test the approval process you get an error from the query. What is wrong with this query?

SELECT distinct 'true' FROM OPOR T0 WHERE $[3.0.0] = 'S' AND $[29.0.number] > 3000

Please choose the correct answer.

Response:

AYou need to add the table name OPOR to the condition to reference the fields.

BTo refer to a field in the active window, an additional '$' character is required before the index values.

CThe service type 'S' is not part of the purchase order table therefore you need to refer to it using the table and field name.

DYou should not use the 'distinct true' clause in this type of query since only a single value is returned.

Show Suggested Answer

Suggested Answer: B

by Kiley at May 08, 2022, 12:09 AM

Limited Time Offer

25%

Off

Get Premium C_TB1200_93 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!