Skip to Content
0
Former Member
Sep 10, 2007 at 05:00 PM

plese correct the select statment...

27 Views

HI,

this is my select program.

SELECT BELNR XBLNR INTO TABLE T_GET_ACCDOCU " SELECTING THE ACCOUNT

" NUMBER AND REFERENCE

" NUMBER INTO TABLE

FROM BKPF

WHERE BLART = P_BLART.

when i output this, i can see several lines.and now using this table i process the following code...

LOOP AT T_GET_ACCDOCU INTO WA_GET_ACCDOCU.

  • GET THE DEALER NUMBER

CLEAR t_GET_DEALER.

SELECT VBELN KUNNR INTO TABLE t_GET_DEALER

FROM LIKP

WHERE VBELN = WA_GET_ACCDOCU-XBLNR

AND VBTYP = 'J'.

ENDLOOP.

now when i output this table i can see only 1 record being output..but there are more tha 1 records present ....i can see all of them when i debug the program but they are being overwritten each time a new record is appeneded to the table..

can any one tell me where the code went wrong...

thank you..

challa