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.