topic Re: SELECT PROBLEM in Application Development and Automation Discussions

SELECT PROBLEM

Former Member — Tue, 13 Nov 2007 05:21:56 GMT

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 a_{fkart a}knumv a_{rfbsk b}VKGRP from vbrk as a

inner join knvv as b on a_{kunag = b}kunnr 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

Re: SELECT PROBLEM

Former Member — Tue, 13 Nov 2007 05:24:37 GMT

fkart -> Billing Type

chk condition for = ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2'

if sy-subr = 0 "record finf else not match record.

Re: SELECT PROBLEM

Former Member — Tue, 13 Nov 2007 05:26:07 GMT

hi,

in table VBRK

field FKART

there should be values only 'ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2'

the select statement will select data where values for FKART are given there only.

Regards,

Sandeep Kaushik

Re: SELECT PROBLEM

Former Member — Tue, 13 Nov 2007 05:28:04 GMT

Hi,

ur select statement will fetch the records with fkart = 'ZUF2' or 'ZUIN' or 'ZUVF' or 'ZUS2' or 'ZC23' or 'ZC24' or 'ZC26' or 'ZUL2' or 'ZUG2'.

rgds,

bharat.

Re: SELECT PROBLEM

Former Member — Tue, 13 Nov 2007 05:31:47 GMT

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

this means it acts like on OR condition

it will check for all the values in that condition

Re: SELECT PROBLEM

meikandan_krishnan2 — Tue, 13 Nov 2007 05:32:14 GMT

Hi ,

This select statement fetches records from the table, only for the values where

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

above is the simplification of the below mentioned condition

.......and ( fkart = ZUF2 or

fkart = ZUIN or

fkart = ZUVF or

fkart = ZUS2 or ...........)

and ......

Regards

Meikandan