Dear all,
we wrote one query to fetch wrong entries as per the clients requirement. Here is our query
SELECT A.TRANSID, A.VATAMOUNT, A.VATGROUP, B.BASEREF,
C.CARDCODE, D.DEBPAYACCT, E.SEGMENT_3,B.REFDATE
FROM JDT1 A JOIN OJDT B
ON A.TRANSID=B.TRANSID
LEFT OUTER JOIN OINV C
ON B.BASEREF=C.DOCNUM
LEFT OUTER JOIN OCRD D
ON C.CARDCODE=D.CARDCODE
LEFT OUTER JOIN OACT E
ON D.DEBPAYACCT=E.ACCTCODE
LEFT OUTER JOIN OCRD F
ON C.CARDCODE=F.CARDCODE
right OUTER JOIN OASC G
ON G.CODE=E.SEGMENT_3
SELECT * FROM DBO.V_GET_GLST_INFO
WHERE CONVERT(VARCHAR, REFDATE,112) BETWEEN '20080701' AND '20081231'
AND VATGROUP='S1-Lb' AND SEGMENT_3 = '11'
in this query i have to give segment as parameter so when i tries to execute this query it does not fetch the data. please can anybody will help me.
thanks & Regards
Tavargeri Ganesh