Hi
Can anybody help me to correct the query.
it is giving me a short dump.
DATA : BEGIN OF t_vbsegk OCCURS 0,
ausbk TYPE ausbk,
belnr TYPE belnr_d,
gjahr TYPE gjahr,
bzkey TYPE buzei,
lifnr TYPE lifnr,
sgtxt TYPE sgtxt,
ebeln TYPE ebeln,
ebelp TYPE ebelp,
buzei TYPE mblpo,
werks TYPE werks_d,
END OF t_vbsegk.
SELECT vbsegk~ausbk
vbsegk~belnr
vbsegk~gjahr
vbsegk~bzkey
vbsegk~lifnr
vbsegk~sgtxt
ekbe~ebeln
ekbe~ebelp
ekbe~buzei
ekbe~werks
FROM vbsegk
JOIN ekbe
ON vbsegkgjahr = ekbegjahr
AND vbsegkbelnr = ekbebelnr
INTO CORRESPONDING FIELDS OF TABLE t_vbsegk
WHERE vbsegk~ausbk IN s_ausbk
AND vbsegk~belnr IN s_belnr
AND vbsegk~gjahr IN s_gjahr
AND vbsegk~lifnr IN s_lifnr
and ekbe~VGABE = P.
Basicallly i want to extract the data fom the above two tables based on user input in selection screen.
Thanks
Any help will not go unmarked.