When I execute the following query (in Query Generator) I got 6411 records. But when I want to filer this table, in the drop down list in 'ITEM' column I found only 500 records (i.e. up to the recods starting with 'K' though there are records starting with 'W' in 'ITEM' field).
I am using SAP B1, PL 14.
Can any one suggest how to get all the records in the drop down list of filter window?
My query is as follows:
SELECT distinct D.ITEMCODE + ' - ' + D.DSCRIPTION 'ITEM',
DATENAME(M,H.DOCDATE) + ' - ' + DATENAME(YYYY,H.DOCDATE) 'MONTH',
FROM PCH1 D INNER JOIN OPCH H ON H.DOCENTRY= D.DOCENTRY
WHERE H.DOCTYPE='I' AND D.ITEMCODE + ' - ' + D.DSCRIPTION IS NOT NULL
ORDER BY 1, 2
Thnaks & with regards
Edited by: ALOKE BANDYOPADHYAY on Jul 15, 2011 4:51 PM