Skip to Content
0
Former Member
Feb 27, 2009 at 05:05 AM

select query

155 Views

Hi experts,

I am new to abap and i have to create a report in alv . i am getting problem in select statement.

These are my tables and it's fields.

TABLES : kna1,bsik,vbrk.

DATA : BEGIN OF itab1 OCCURS 0,

bukrs TYPE bsik-bukrs,

netwr TYPE vbrk-netwr,

mwsbk TYPE vbrk-mwsbk,

vbeln TYPE vbrk-vbeln,

kunrg TYPE vbrk-kunrg,

END OF itab1.

DATA : BEGIN OF itab2 OCCURS 0,

kunnr LIKE kna1-kunnr,

lifnr LIKE kna1-lifnr,

END OF itab2.

DATA : BEGIN OF itab3 OCCURS 0,

lifnr LIKE bsik-lifnr,

xblnr LIKE bsik-xblnr,

END OF itab3.

*********Select screen option******

SELECT-OPTIONS:s_bukrs FOR vbrk-bukrs.

**************************************************

****Select Query************************

i have to show netwr mwsbk vbeln kunrg fields of table vbrk in the output with condition that

vbeln = xblnr of bsik and

kunrg = kunnr of kna1.

i tried this select query using inner join :

select vbrknetwr vbrkmwsbk vbrkvbeln vbrkkunrg

kna1kunnr kna1lifnr bsikxblnr bsiklifnr

into corresponding fields of table itab1

from vbrk inner join bsik on vbrkvbeln = bsikxblnr

inner join kna1 on vbrkkunrg = kna1kunnr

and bsiklifnr = kna1lifnr

where vbrk~bukrs IN s_bukrs.

Query doesn't give any output ,must be something wrong....soooo i need experts help

Thanks in advance,

Harsha Anand