Skip to Content
0
Former Member
Dec 01, 2009 at 08:02 AM

Error while giving where condition

33 Views

hi experts,

in my following query

SELECT TOP (100) PERCENT

OWTR_2.docentry AS 'internal number',

OWTR_2.U_Loc AS 'From Location',

OCST_1.Name AS 'From State',

--OWTR_2.U_tinno as 'Tin No.1',

dbo.OWHS.U_whtin AS 'Tin No.1',

--dbo.WTR1.StockPrice as 'Stock Price',

OWTR_2.U_dtype as 'Document Type',

OWTR_2.TaxDate AS 'DocDate',

OWTR_2.CardCode as 'To Location',

dbo.OCST.Name AS 'To state',

--dbo.OWHS.State AS 'LocState',

--dbo.OCRD.State2,

OWTR_2.U_tinno as 'Tin No.2',

--dbo.OWHS.U_whtin AS 'Tin No.2',

dbo.WTR1.ItemCode as 'Item Code',

dbo.WTR1.Dscription as 'Description',

dbo.WTR1.Quantity as 'Quantity',

(dbo.WTR1.StockPrice * dbo.WTR1.Quantity) as 'value' ,

OWTR_1.DocDate AS 'Closing date',

dbo.[@ITMG].Name AS 'MAG',

OWTR_2.U_C_Name as 'Carrier Name',

OWTR_2.U_V_Number as 'Vehicle Number ',

OWTR_2.U_lrno as 'LR No.',

OWTR_2.U_LR_Date as 'LR Date' FROM dbo.OCST AS OCST_1 RIGHT OUTER JOIN

dbo.OWHS INNER JOIN

dbo.OWTR AS OWTR_2 INNER JOIN

dbo.WTR1 ON OWTR_2.DocEntry = dbo.WTR1.DocEntry INNER JOIN

dbo.OITM ON dbo.WTR1.ItemCode = dbo.OITM.ItemCode ON dbo.OWHS.WhsCode = OWTR_2.Filler LEFT OUTER JOIN

dbo.[@ITMG] ON dbo.OITM.U_itmg = dbo.[@ITMG].Code ON OCST_1.Country = dbo.OWHS.Country AND

OCST_1.Code = dbo.OWHS.State LEFT OUTER JOIN

dbo.OCST INNER JOIN

dbo.OCRD ON dbo.OCST.Code = dbo.OCRD.State2 AND dbo.OCST.Country = dbo.OCRD.Country ON

OWTR_2.CardCode = dbo.OCRD.CardCode FULL OUTER JOIN

dbo.WTR1 AS WTR1_1 INNER JOIN

dbo.OWTR AS OWTR_1 ON WTR1_1.DocEntry = OWTR_1.DocEntry ON cast(OWTR_2.DocNum as nvarchar)= OWTR_1.U_stno AND

dbo.WTR1.ItemCode = WTR1_1.ItemCode AND OWTR_1.FinncPriod >= OWTR_2.FinncPriod AND OWTR_1.CANCELED = OWTR_2.CANCELED WHERE OWTR_2.U_dtype = 'Stock Transfer OUT'

if i wish to select OWTR_2.U_dtype = [%0] then it show error

incorrect syntax near 'where'.2

pls help me in this regard

ketan

SAP b1