Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to delete the records from database table without using work area

Former Member
0 Likes
424

Hi all,

The purpose of the down program is to delete the entire contents from all the tables. The deletion of the table should be in sorted manner. Is there any other 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.

Waiting for response,

Thanks in advance

John

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
404

Write this way....

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.

CHECK SY_SUBRC = 0.

DELETE ZFFMMHDR_AP.

CHECK SY_SUBRC = 0.

DELETE ZFFM_CHANGE_LOG.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_AR.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_AR.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_JV.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_JV.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_SKF.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_SKF.

CHECK SY_SUBRC = 0.

DELETE ZFINVOICE_DETAIL.

CHECK SY_SUBRC = 0.

DELETE ZFFMMASTER.

CHECK SY_SUBRC = 0.

DELETE ZFFMLOGREAD_CLUS.

CHECK SY_SUBRC = 0.

DELETE ZFFMCTL.

2 REPLIES 2
Read only

Former Member
0 Likes
404

Use check statment to avoid so many If.

For example

check sy-subrc = 0.

Regards

Abhishek

Read only

Former Member
0 Likes
405

Write this way....

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.

CHECK SY_SUBRC = 0.

DELETE ZFFMMHDR_AP.

CHECK SY_SUBRC = 0.

DELETE ZFFM_CHANGE_LOG.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_AR.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_AR.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_JV.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_JV.

CHECK SY_SUBRC = 0.

DELETE ZFFMDTL_SKF.

CHECK SY_SUBRC = 0.

DELETE ZFFMHDR_SKF.

CHECK SY_SUBRC = 0.

DELETE ZFINVOICE_DETAIL.

CHECK SY_SUBRC = 0.

DELETE ZFFMMASTER.

CHECK SY_SUBRC = 0.

DELETE ZFFMLOGREAD_CLUS.

CHECK SY_SUBRC = 0.

DELETE ZFFMCTL.