Skip to Content
0
Former Member
Dec 04, 2006 at 07:49 AM

Deleteing the contents from the database table

30 Views

The aim of this code is to delete the whole contents from these 12 tables. Is there any way to write the code more efficiently.

TABLES: ZFFMCTL_AP, ZFFMHDR_AP, ZFFM_CHANGE_LOG, ZFFMDTL_AR, ZFFMHDR_AR, ZFFMDTL_JV, ZFFMHDR_JV, ZFFMDTL_SKF,ZFFMHDR_SKF,ZFINVOICE_DETAIL, ZFFMMASTER, ZFFMLOGREAD_CLUS, ZFFMCTL.

DELETE ZFFMCTL_AP.

IF SY-SUBRC = 0.

DELETE ZFFMMHDR_AP.

IF SY-SUBRC = 0.

DELETE ZFFM_CHANGE_LOG.

IF SY-SUBRC = 0.

DELETE ZFFMDTL_AR.

IF SY-SUBRC = 0.

DELETE ZFFMHDR_AR.

IF SY-SUBRC = 0.

DELETE ZFFMDTL_JV.

IF SY-SUBRC = 0.

DELETE ZFFMHDR_JV.

IF SY-SUBRC = 0.

DELETE ZFFMDTL_SKF.

IF SY-SUBRC = 0.

DELETE ZFFMHDR_SKF.

IF SY-SUBRC = 0.

DELETE ZFINVOICE_DETAIL.

IF SY-SUBRC = 0.

DELETE ZFFMMASTER.

IF SY-SUBRC = 0.

DELETE ZFFMLOGREAD_CLUS.

IF SY-SUBRC = 0.

DELETE ZFFMCTL.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

This is very urgent,

Thanks in advance

John