Select Query

[Former Member]

Freinds

Thanks for the support.

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

i.e. vbsegk_{bzkey = ekbe}buzei

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 vbsegk_{gjahr = ekbe}gjahr

AND vbsegk_{belnr = ekbe}belnr

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.

[jayanthi_jayaraman]

Hi,

Not sure...but you can make a try

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

vbsegk_{bzkey = ekbe}buzei+0(2)

Take the table which field is larger in the right side...

Then use +0(2) means +Starting point(no. of char)