SAP Query Generator code to run SQL syntax.

/* SELECT * FROM [dbo].[OJDT] T0 */

DECLARE @FDT DATE

/* WHERE */

SET @FDT =/* T0.RefDate */'[%0]'

/* SELECT * FROM [dbo].[OJDT] T1 */

DECLARE @TDT DATE

/* WHERE */

SET @TDT =/* T1.DueDate */'[%1]'

/* SELECT * FROM [dbo].[OCRD] T2 */

DECLARE @CRD VARCHAR(20)

/* WHERE */

SET @CRD =/* T2.CardCode */'[%2]'

/* SELECT * FROM [dbo].[OACT] T3 */

DECLARE @ACT VARCHAR(20)

/* WHERE */

SET @ACT =/* T3.AcctCode */'[%3]' 

EXEC <SP_NAME> @FDT,@TDT,@CRD,@ACT

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

/* SELECT * FROM [DBO].[ORDR] T0 */

DECLARE @FROM AS DATE

/* WHERE */

SET @FROM =  /* T0.DOCDATE */  '[%0]'

/* SELECT * FROM [DBO].[ORDR] T0 */

DECLARE @TO AS DATE

/* WHERE */

SET @TO =  /* T0.DOCDATE */  '[%1]'

SET DATEFORMAT DMY

EXEC <SP_NAME> @FROM, @TO

If there is any other better option,

Please share it here or mail to me arkaa4@gmail.com

Thank You,

Arka Gupta.

http://arkaguptablog.blogspot.in/

https://in.linkedin.com/in/arkagupta

https://plus.google.com/+ArkaGupta-arkagupta/posts