Skip to Content
0
Former Member
Dec 17, 2011 at 04:52 AM

Passing Parameter to Query

15 Views

I have to create the report for sales based upon 30 , 60,90,120,150,180 days. It should be come from From date + 30 days sales , From date+ 60 etc..

Input is From Date and To date.

The following query is using for above sales.In this query I have directly mentioned the date .

My Doubt is.

I have creaed the From date and To date Parameter using Parameter fields.

But How do i pass the Parameter value (From Date ) to bellow query using SAP.

select T0.ItemCode,

isNUll((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,30, '2011-09-01') and INV1.ItemCode =T0.ItemCode ),0) as first30,

isNull((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,60, '2011-09-01')and INV1.ItemCode =T0.ItemCode ),0) as first60,

isNull((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,90, '2011-09-01')and INV1.ItemCode =T0.ItemCode ),0) as first90,

isnull((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,120, '2011-09-01')and INV1.ItemCode =T0.ItemCode ),0) as first120,

isnull((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,150, '2011-09-01')and INV1.ItemCode =T0.ItemCode ),0) as first150,

isnull((select sum(Quantity) from INV1 where DocDate between '2011-09-01' and DATEADD(dd,180, '2011-09-01')and INV1.ItemCode =T0.ItemCode ),0) as first180

from INV1 T0 inner join OINV T1 on T0.DocEntry =T1.DocEntry group by ItemCode

How do I pass From date value as paramter to query.

Please help me.