Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Meaning of Variables in Query Generator?

Dear Experts,

Can any one tell me what is meaning of Variable (%0,%1,%2.....%19) in Query Generator.

if give one example or related link will more appropriated.

Thanks & regards,

Santosh.

Former Member
replied

Hi Santosh,

SAP simply provides a number of variables in the Query Generator. You can use as many or as few of them as you like.

It is like Augusto said, they are just names. However, there is a  restriction: the order in which you put them in your query. When you use more than one parameter, always use the smallest number first.

So using Augusto's example:

SELECT T0.DocNum, T0.CardName, T0.DocTotal FROM OINV T0 WHERE T0.DocDate Between [%15] and [%25]

First [%15] is used, and then the larger number [%25].

If necessary you can even use the same parameter multiple times.

Regards,

Johan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question