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