select statement

[Former Member]

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

[Former Member]

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

[Former Member]

i declared tables vbak vbap

[Former Member]

between into and table 'corresponding fields' is missing.

[Former Member]

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>

[Former Member]

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

[Former Member]

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.

[Former Member]

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.