see the full code how the data is select into work area and then to your internal table .
"first example
TYPES: BEGIN OF t_bseg,
*include structure bseg.
bukrs LIKE bseg-bukrs,
belnr LIKE bseg-belnr,
gjahr LIKE bseg-gjahr,
buzei LIKE bseg-buzei,
mwskz LIKE bseg-mwskz, "Tax code
umsks LIKE bseg-umsks, "Special G/L transaction type
prctr LIKE bseg-prctr, "Profit Centre
hkont LIKE bseg-hkont, "G/L account
xauto LIKE bseg-xauto,
koart LIKE bseg-koart,
dmbtr LIKE bseg-dmbtr,
mwart LIKE bseg-mwart,
hwbas LIKE bseg-hwbas,
aufnr LIKE bseg-aufnr,
projk LIKE bseg-projk,
shkzg LIKE bseg-shkzg,
kokrs LIKE bseg-kokrs,
END OF t_bseg.
DATA: it_bseg TYPE STANDARD TABLE OF t_bseg INITIAL SIZE 0,
wa_bseg TYPE t_bseg.
SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart
dmbtr mwart hwbas aufnr projk shkzg kokrs
FROM bseg
INTO wa_bseg.
APPEND wa_bseg TO it_bseg.
ENDSELECT.
"second example :
DATA : lt_bsik TYPE TABLE OF txi_bsik ,
ls_bsik LIKE LINE OF lt_bsik.
DATA : ld_cursor TYPE cursor.
OPEN CURSOR ld_cursor FOR
SELECT * FROM bsak
WHERE budat LE ls_butab-keydt
AND augdt GT ls_butab-keydt
AND bukrs = ls_butab-bukrs.
DO.
FETCH NEXT CURSOR ld_cursor
INTO CORRESPONDING FIELDS OF TABLE lt_bsik
PACKAGE SIZE txilm_package_size.
IF sy-subrc NE 0.
CLOSE CURSOR ld_cursor.
EXIT.
ENDIF.
SORT lt_bsik BY bukrs gjahr belnr.
LOOP AT lt_bsik INTO ls_bsik.
"if change in ls_bsik move to lt_bsik .
MODIFY lt_bsik FROM ls_bsik.
ENDLOOP.
ENDDO.
reward points if it is usefull...
Girish
Bluesky
