topic Re: Select Statements in Application Development and Automation Discussions

Select Statements

Former Member — Tue, 12 Feb 2008 16:33:45 GMT

Hi,

How can I fetch values for parameters...is the select statements right....how can i use ?

select-options : s_vbeln for vbak-vbeln.

Parameters : s_vkorg(10),

s_vtweg(10),

s_spart(10).

Initialization.

start-of-selection.

select a_{vbeln a}auart a_{netwr a}waerk b_{zmeng b}zieme b_{posnr b}matnr

into table itab from vbak as a inner join vbap as b on b~vbeln =

a_{vbeln where a}vbeln in s_vbeln.

select vbeln auart netwr waerk from vbak into table itab where

vkorg = s_vkorg and

vtweg = s_vtweg.

select zmeng zieme posnr matnr from vbap into table itab where

spart = s_spart.

Re: Select Statements

Former Member — Tue, 12 Feb 2008 16:37:02 GMT

put in where condition

where vblen in s_vbeln

thnkx

Re: Select Statements

Former Member — Tue, 12 Feb 2008 16:41:49 GMT


select a~vbeln  a~auart a~netwr a~waerk b~zmeng 
          b~zieme b~posnr b~matnr
            into table itab 
           from vbak as a inner join vbap as b on b~vbeln = a~vbeln 
                 where a~vbeln in s_vbeln 
                    and a~vkorg = s_vkorg
                    and a~vtweg = s_vtweg
                    and a~spart  = s_spart

Max

Re: Select Statements

Former Member — Tue, 12 Feb 2008 16:42:41 GMT

ya ur select statement is right .

Re: Select Statements

Former Member — Tue, 12 Feb 2008 17:49:47 GMT

Hi,

I coulnt get the syntax clear coz spart is from vbap table and the other fields are from vbak...

I have tried using OR instead of AND..it shows the error like this ' the column name spart has two meanings..abap/4 open sql statement.'.

what to do.

Stalin.

Re: Select Statements

Former Member — Tue, 12 Feb 2008 17:54:08 GMT


select a~vbeln  a~auart a~netwr a~waerk b~zmeng 
          b~zieme b~posnr b~matnr
            into table itab 
           from vbak as a inner join vbap as b on b~vbeln = a~vbeln 
                 where a~vbeln in s_vbeln 
                    and a~vkorg = s_vkorg
                    and a~vtweg = s_vtweg
                    and b~spart  = s_spart<--------

Max