Skip to Content

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

How to use a query in the Print Layout Designer?

I created a query with the query generator:

SELECT T0.[Discount], T0.[NumOfDays], T2.[DocNum] FROM CDC1 T0, OQUT T2 INNER JOIN OCTG T3 ON T2.GroupNum = T3.GroupNum WHERE T2.[GroupNum]=T3.[GroupNum] AND T0.[CdcCode] = T3.[DiscCode]

The result shows the cash discout (the days and the percentage) of every record.

I need this query, because I want to design a sales order report.

To show the payment conditions with cash discount I need to have the table CDC1 but when I create a new database field in the report I can't see that table.

So I queried the table CDC1....

Then I created a new database field and in the list box "table" I made the following steps:

extras\customizing tools\user defined values - definition\search for saved query in user defined values

But the problem is that I don't get the result of the query into my report.

What's the problem? I don't know what I've done wrong...

please help me

Former Member replied

Is it $http://ORDR.GroupNum or

$[ORDR.GroupNum]

?

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