Skip to Content
0
Former Member
Sep 08, 2009 at 01:32 PM

User defined query parameter in query generator

509 Views

Hi All,

i am using query generator in SAP to print some records of user defined query. precisely, the details about sales employees are to be printed. now the columns which exist in the database (ie. sales employee code, name, cardcode) etc can be given as a parameter like [%0] and [%1]. but some user defined parameter such as sales commission does not show as such parameter. i want one column as


select T0.doctotal, (T0.doctotal * [%0]) / 100  as brokerage from OINV T0
--where [%0] is some commission percentage that the user will give while running this query

This query gives correct results but it gives the parameter name as 'doctotal' while showing. any idea as to how to handle it properly in SAP?

thanks in advance,

Binita

Edited by: Binita Joshi on Sep 8, 2009 3:35 PM