‎2008 Aug 21 11:24 AM
Dear All
In Bellow code i modify one internal table at a same i will check condition check the condition matching append second table
my problem is index value changed
how to rectify?
LOOP AT IBS.
SELECT single ekkn~vbeln into ibs-vbeln from ekkn
WHERE ebeln = ibs-ebeln.
SELECT Single lfa1~name1 into ibs-name1 from lfa1
WHERE lifnr = ibs-lifnr.
SELECT BELNR LFBNR INTO (MATDOC, REFDOC) FROM EKBE WHERE
EBELN EQ IBS-EBELN AND
EBELP EQ IBS-EBELP.
IF MATDOC NE REFDOC.
INS-BELNR = MATDOC.
INS-LFBNR = REFDOC.
APPEND INS.
ENDIF.
CLEAR: MATDOC, REFDOC.
ENDSELECT.
modify ibs index sy-tabix.
Thanks and regards
Suresh
‎2008 Aug 21 11:30 AM
Plz do like that
Data idx type sy-tabix.
LOOP AT IBS.
idx = sy-tabix.
SELECT single ekkn~vbeln into ibs-vbeln from ekkn
WHERE ebeln = ibs-ebeln.
SELECT Single lfa1~name1 into ibs-name1 from lfa1
WHERE lifnr = ibs-lifnr.
SELECT BELNR LFBNR INTO (MATDOC, REFDOC) FROM EKBE WHERE
EBELN EQ IBS-EBELN AND
EBELP EQ IBS-EBELP.
IF MATDOC NE REFDOC.
INS-BELNR = MATDOC.
INS-LFBNR = REFDOC.
APPEND INS.
ENDIF.
CLEAR: MATDOC, REFDOC.
ENDSELECT.
MODIFY ibs INDEX idx.
rgds
rajesh
‎2008 Aug 21 11:27 AM
‎2008 Aug 21 11:30 AM
Plz do like that
Data idx type sy-tabix.
LOOP AT IBS.
idx = sy-tabix.
SELECT single ekkn~vbeln into ibs-vbeln from ekkn
WHERE ebeln = ibs-ebeln.
SELECT Single lfa1~name1 into ibs-name1 from lfa1
WHERE lifnr = ibs-lifnr.
SELECT BELNR LFBNR INTO (MATDOC, REFDOC) FROM EKBE WHERE
EBELN EQ IBS-EBELN AND
EBELP EQ IBS-EBELP.
IF MATDOC NE REFDOC.
INS-BELNR = MATDOC.
INS-LFBNR = REFDOC.
APPEND INS.
ENDIF.
CLEAR: MATDOC, REFDOC.
ENDSELECT.
MODIFY ibs INDEX idx.
rgds
rajesh
‎2008 Aug 21 11:38 AM
Hi,
Each Select statement when executed will change the Index value.
Declare one more variable of this index and use this index in your loop accordingly.
Same applies with the Read statement also.
Regards
Lekha
‎2008 Aug 21 11:55 AM