SAP Conditional parameter for views:

Hi,

I want to use SAP Conditional parameter for views...while using am getting Error "Must Specify table to select From" ... how to resolve it..

FYI:

For Ex,

My View is PurchaseDetails,

My View contains columns like [INVOICE NO],[DATE], [PARTY NAME],[MATERAIL],[HCESS],[SCESS] etc

i tried the following ways:

way 1:

Select T0.INVOICE NO,T0.DATE, T0.PARTY NAME From PurchaseDetails T0 where T0.DATE >='[%0]' and T0. DATE <='[%1]'

way 2:

declare @tt table

(

INVOICE NO nvarchar(100),

DATE Datetime,

PARTY NAME nvarchar(100)

)

insert into @tt

Select T0.INVOICE NO,T0.DATE, T0.PARTY NAME From PurchaseDetails T0 where T0.DATE >='[%0]' and T0. DATE <='[%1]'

Select TT.INVOICE NO,TT.DATE, TT.PARTY NAME from @tt TT

both ways producing the same error...how to resolve...

- Ganesh

Edited by: Ganesh Karunakaran on May 26, 2009 9:26 PM

Edited by: Ganesh Karunakaran on May 26, 2009 9:26 PM