Skip to Content
0
Former Member
Apr 13, 2012 at 06:09 AM

How to use sy-dbcnt to get no of row processed in transparent table?

325 Views

Hi Experts,

I have below code to modify a transparent table with internal table. After the execution, I want to get number of row processed in the transparent table.

How to do that? I have use sy-dbcnt, but the value always shows only 1.

LOOP AT <ft_csv_data> INTO <fs_tdat_data> FROM 2.
MOVE-CORRESPONDING <fs_tdat_data> TO <fs_target_table>.

MODIFY (p_target) FROM <fs_target_table>.

COMMIT WORK.
ENDLOOP.

IF sy-subrc EQ 0.
WRITE: 'Data successfully transferred into target table!'.
ELSE.
WRITE: 'Data failed to transfer into target table!'.
ENDIF.

WRITE:/ 'Total rows affected:',sy-dbcnt.

Thank you.

Regards,

Honda