Skip to Content
0
Former Member
Dec 06, 2006 at 07:19 AM

Select Query

125 Views

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.