Doubt in select statement

Former Member — Sat, 11 Aug 2007 11:57:27 GMT

Hi Friends,

I have written a select statement like

select a_{kunnr a}j_3avakzt a_{j_3avakzp into fpi_sold_output from knvv as a inner join vbap as b on a}kunnr = b~kunnr

where a~vkorg in fp_vkorg and

a~vtweg in fp_vtweg and

a~spart in fp_spart and

a~kunnr in fp_kunnr and

b~parvw eq 'SP'.

my doubt is b~parvw(party function in vbpa) should be in the value from select option it can be any two character. they can give any number of input for parvw in the select option by giving no intervals.

i need to write two select statements

1st select satement should work for b~parvw with the value 'SP' .

2nd select statement should work for b~parvw with the value 'ST'.

i was asked not to use like this

b~parvw eq 'SP'.

instead asked to use the value from selection screen for b~parvw.

but i should extract records only for two parvw which are 'SP' and 'ST'

how to wrute the select statement.

please help.

Re: Doubt in select statement

Former Member — Sat, 11 Aug 2007 12:15:35 GMT

Hi Gokul

Simple !!!!!!!

use in operator and reward points for helpful ans's

select a_{kunnr a}j_3avakzt a_{j_3avakzp into fpi_sold_output from knvv as a inner join vbap as b on a}kunnr = b~kunnr

where a~vkorg in fp_vkorg and

a~vtweg in fp_vtweg and

a~spart in fp_spart and

a~kunnr in fp_kunnr and

b~parvw in ( 'SP' , 'ST') .

IF IT IS A SELECT OPTION THEN USE

b~parvw in S_OPT.

reward,

kiran.M

Message was edited by:

KIRAN KUMAR

topic Re: Doubt in select statement in Application Development and Automation Discussions

Doubt in select statement

Re: Doubt in select statement