topic Re: SELECT STATEMENT PROBLEM in Application Development and Automation Discussions

SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:07:39 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 STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:09:51 GMT

it will check all value for where condition.

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') <b>chk condition</b>and b}VKGRP in VKGRP.

Re: SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:11:39 GMT

hi,

if the vlaue in the field fkart = 'ZUF2' or fkart = 'ZUIN' OR ...

like that for that purpose its better to keep

statement select * from table name where field in ( 'ZUF2','ZUIN',....).

REGARDS

SIVA

Re: SELECT STATEMENT PROBLEM

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

Hi,

Basically to select the data where the billing types is either one of them which is given in the list..

'ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2'

You can also use a OR for the billing type like this..

where a_{fkart = 'ZUF2' OR a}fkart = 'ZUIN'....

Thanks

Naren

Re: SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:12:10 GMT

Hi Jose,

This a~fkart in ('ZUF2','ZUIN','ZUVF','ZUS2','ZC23','ZC24','ZC26','ZUL2','ZUG2') means, only mentioned fkart type in the brackets will fetch.

based on the inner join statement, aprt from all corresponding parameters the given select query will execute.

Suku

Re: SELECT STATEMENT PROBLEM

former_member404244 — Tue, 13 Nov 2007 05:12:49 GMT

Hi,

THe field fkart have lot of values ,but we are filtering out some values..thats why it has given the values which we require..Please check the table vbrk and field fkart..

Regards,

Nagaraj

Re: SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:13:17 GMT

THE STATEMENT SELECTS THE RECORDS THAT CONTAINS THE VALUES OF THE FIELD FKART IN GIVEN RANGE ONLY. (................................................................................)

Re: SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:13:53 GMT

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

means that filed value may be any one from that group of values

Re: SELECT STATEMENT PROBLEM

Former Member — Tue, 13 Nov 2007 05:20:58 GMT

hi guys,

i have another question, whats the use of this field .....kinak = ' '......in the below sample code??what does this refer to??

select kschl sakn1 kwert from konv into table con

for all entries in doc

where knumv = doc-knumv

and kinak = ' '

and kschl in ('ZU01','R100','ZC25','ZDTR','ZDTL','ZDTP','ZDDA','ZRET','ZD06','ZDMI','ZDNP','ZDNE','ZDTD',

'ZC20','ZC01','ZC02','ZC03','ZC04','ZC05','ZC06','ZC07','ZC10','ZC14','ZC18','ZM09','ZC19',

'ZC27').

thanks in advance,

gerald

Re: SELECT STATEMENT PROBLEM

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

Hi,

If the condition type is inactive then KINAK will be not initial..

In your case KINAK = ' ' means condition is active

Thanks

Naren