Skip to Content
0
Former Member
Nov 13, 2007 at 05:21 AM

SELECT PROBLEM

48 Views

Hi gurus,

I jst want some clarification regarding this sample code. I jst wnt to ask on whats the use or purpose of this part of the select statement.....

a~fkart in ('ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2') in the sample code below???

select afkart aknumv arfbsk bVKGRP from vbrk as a

inner join knvv as b on akunag = bkunnr into table doc

where rfbsk = 'C'

and a~fkdat in fkdat

and a~erdat in erdat

and a~fkart in ('ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2')

and b~VKGRP in VKGRP.

helpful answers would be given points,thanks in advance.

gerald