TYPES:BEGIN OF ty_data,
id TYPE string,
num TYPE string,
END OF ty_data.
DATA:lv_connid TYPE string.
DATA:lt_res TYPE TABLE OF ty_data.
DATA:ls_res TYPE ty_data.
SELECT * FROM sflight INTO TABLE @DATA(lt_tb).
LOOP AT lt_tb ASSIGNING FIELD-SYMBOL(<fs_tb>) GROUP BY ( carrid = <fs_tb>-carrid connid = <fs_tb>-connid ) assigning field-symbol(<group>).
LOOP AT GROUP <group> ASSIGNING FIELD-SYMBOL(<ls_group>).
lv_connid = lv_connid + 1.
ENDLOOP.
ls_res-id = <group>-carrid.
ls_res-num = lv_connid.
APPEND ls_res TO lt_res.
WRITE:/ ls_res-id,':',ls_res-num.
CLEAR lv_connid.
ENDLOOP.