Skip to Content
0
Former Member
Dec 06, 2006 at 08:15 AM

Select Query

50 Views

Freinds

Thanks for the support.

Also that i want to include one more clause in JOIN condition in the below query

i.e. vbsegkbzkey = ekbebuzei

but the problem is both these fields have different lengths.

Is there any way out that I can include this in the JOIN clause of the below query.

Thanks

constants: c_vgabe type vgabe value 'P'.

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 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 = c_vgabe.