Skip to Content
0
Feb 27 at 06:10 AM

Sort the Prompting Parameters in SAP B1 SQL Server

122 Views

Hi

Kindly request your assistance to sort out the values in SAP B1 Query generator.

/*SELECT FROM [dbo].[ORCT] p1*/

declare @FROM as Date

declare @TO as Date

/* WHERE */

set @FROM = /* p1.docdate */ '[%0]'

set @TO = /* p1.docdate */ '[%1]'

----------------------------------------------------------------------

select ORCT.DocNum As 'Receipt Num' ,ORCT.DocDate AS 'Receipt Date'

from ORCT

where ORCT.NoDocSum<>0

AND ORCT.DocDate>=@FROM

AND ORCT.DocDate<=@TO

order by ORCT.DocNum

-------------------------------------------

Here above I have declared two parameters " @FROM as Date and @TO

The query is running OK and just need to know whether there is any method to sort these two DATES when it is being prompted in form .

Thanks