Skip to Content
0
Former Member
Sep 23, 2005 at 10:14 AM

SQL in SAP

19 Views

I have this query:

-


SELECT T0.LineTotal,T0.Commission,T1.SlpName,(T0.LineTotal*T0.Commission)/100 AS 'Cantidad' FROM INV1 T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode WHERE T1.SlpName = '[%0]' AND T0.DocDate >='[%1]' and T0.DocDate <= '[%2]'

-


The query is Ok but I have three questions:

1) When the customer executes the query, always views all the code, in SAP is " Display Query Structure". Why? . I don`t wish that the customer views the structure.

2) When the customer exucutes the query, I wish that the variables [%1] and [%2] don`t show "Posting date" but that showed another value by screen. How???

3)I have a report related to the query, as I show the values [%1] and [%2] in the report.???

Thanks.