Skip to Content
0
Former Member
May 30, 2008 at 06:48 AM

select

26 Views

i am using this piece of code to fetch data from bseg.

but for a aprticular record of t_final it is not picking all the records ofrm bseg,can u tell me why

for example there is record 1 in t_final and for record 1 there are 8 records in bseg

but it iselectin only 4 records out of 8

IF t_final IS NOT INITIAL.

SELECT bukrs

belnr

gjahr

augdt

koart

shkzg

dmbtr

kostl

aufnr

saknr

hkont

kunnr

lifnr

zfbdt

projk

FROM BSEG INTO TABLE t_bseg

FOR ALL ENTRIES IN t_final

WHERE bukrs = t_final-bukrs

AND belnr = t_final-belnr

AND gjahr = t_final-gjahr

AND koart NE 'K'.

ENDIF.