topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Wed, 22 Aug 2007 12:35:05 GMT

tables : mvke,vbak,vbap.

data : itab like mvke occurs 0 with header line .

Get the material pricing group (field MVKE-KONDM) from the material master of the current material (MVKE where MVKE-VKORG = VBAK-VKORG and MVKE-VTWEG = VBAK-VTWEG and MVKE-MATNR = VBAP-MATNR).

for this..i writen like that

select kondm

from mvke

into table itab

where vkorg = vbak-vkorg AND

vtweg = vbak-vtweg AND

matnr = vbap-matnr.

loop at itab.

write : / itab-kondm.

endloop.

no data is there kindly help me out.

Thanks & regards

Kavitha

Re: select statement

Former Member — Wed, 22 Aug 2007 12:36:34 GMT

And what is in VBAK and VBAP at the time of this read.

Re: select statement

Former Member — Wed, 22 Aug 2007 12:38:19 GMT

between into and table 'corresponding fields' is missing.

Re: select statement

Former Member — Wed, 22 Aug 2007 12:39:27 GMT

i declared tables vbak vbap

Re: select statement

Former Member — Wed, 22 Aug 2007 12:40:49 GMT

hi kutti

your query is absolutely fine.

after ur select query check

if sy-subrc eq 0.

if it is equal to 4 it means there is no kondom satisfying the where condition.

regards

ravish

<b>plz rerward points if helpful</b>

Re: select statement

Former Member — Wed, 22 Aug 2007 12:44:15 GMT

Hi,

First of all you need to get all the of values VBAK basing on some condition of you requirement into internal table use this internal to get the avalues from MVKE table by using for all entries. And then loop the final internal table for output.

Thanks,

Sriram Ponna.

Re: select statement

Former Member — Wed, 22 Aug 2007 12:46:14 GMT

hi,

one reason is the input which gave n the value that exists for that field may not be same.

for this use FM CONVERSION_EXIT_ALPHA_INPUT and pass the parameter and use out obtained from fm in sleect option.

another may be remaining conditions may be false check them also. or go for OR relational operator if required.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: select statement

Former Member — Wed, 22 Aug 2007 12:47:03 GMT

your code seems to b ok

but just chek that is there any record related to all three tables

use inner join for better code.

just chk the tables for the record

reward points to all helpful answers