SAP
C_TB1300_07 · Question #89
Every day my employees run a query to check how many orders we have issued on that day and what their value was. I have created a simple query using the Orders table (ORDR): Document Number…
The correct answer is A. Define a variable in the "Where" condition area of the formula: Document Date EQUAL '[%0]'. See the full explanation below for the reasoning.
Question
Every day my employees run a query to check how many orders we have issued on that day and what their value was. I have created a simple query using the Orders table (ORDR): Document Number, Document Date, Document Total Where Document Date EQUAL 01/05/07 (for example). How can I create a "general" query so I do not have to go into this query statement every day to change the date in the "Where" condition area?
Options
- ADefine a variable in the "Where" condition area of the formula: Document Date EQUAL '[%0]'
- BDelete the condition from the query.
- CDefine a variable in the "Where" condition area of the formula: Document Date NOT EQUAL
- DDefine a variable in the "Group By" condition area of the formula: Document Date EQUAL
How the community answered
(58 responses)- A74% (43)
- B7% (4)
- C14% (8)
- D5% (3)
Community Discussion
No community discussion yet for this question.