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.