topic Re: How to delete the records from database table without using work area in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770842#M332856 <HTML><HEAD></HEAD><BODY><P>Write this way....</P><P>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.</P><P></P><P>DELETE ZFFMCTL_AP.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMMHDR_AP.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFM_CHANGE_LOG.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_AR.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_AR.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_JV.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_JV.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_SKF.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_SKF.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFINVOICE_DETAIL.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMMASTER.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMLOGREAD_CLUS.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMCTL.</P></BODY></HTML> Mon, 04 Dec 2006 10:30:53 GMT Former Member 2006-12-04T10:30:53Z How to delete the records from database table without using work area https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770840#M332854 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>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,</P><P></P><P>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.</P><P></P><P>DELETE ZFFMCTL_AP.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMMHDR_AP.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFM_CHANGE_LOG.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMDTL_AR.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMHDR_AR.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMDTL_JV.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMHDR_JV.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMDTL_SKF.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMHDR_SKF.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFINVOICE_DETAIL.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMMASTER.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMLOGREAD_CLUS.</P><P>IF SY-SUBRC = 0.</P><P>DELETE ZFFMCTL.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P>ENDIF.</P><P></P><P></P><P>Waiting for response,</P><P></P><P>Thanks in advance</P><P></P><P>John</P></BODY></HTML> Mon, 04 Dec 2006 09:12:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770840#M332854 Former Member 2006-12-04T09:12:19Z Re: How to delete the records from database table without using work area https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770841#M332855 <HTML><HEAD></HEAD><BODY><P>Use check statment to avoid so many If.</P><P></P><P>For example</P><P>check sy-subrc = 0.</P><P></P><P>Regards</P><P>Abhishek</P></BODY></HTML> Mon, 04 Dec 2006 10:20:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770841#M332855 Former Member 2006-12-04T10:20:16Z Re: How to delete the records from database table without using work area https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770842#M332856 <HTML><HEAD></HEAD><BODY><P>Write this way....</P><P>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.</P><P></P><P>DELETE ZFFMCTL_AP.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMMHDR_AP.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFM_CHANGE_LOG.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_AR.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_AR.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_JV.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_JV.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMDTL_SKF.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMHDR_SKF.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFINVOICE_DETAIL.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMMASTER.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMLOGREAD_CLUS.</P><P>CHECK SY_SUBRC = 0.</P><P>DELETE ZFFMCTL.</P></BODY></HTML> Mon, 04 Dec 2006 10:30:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-the-records-from-database-table-without-using-work-area/m-p/1770842#M332856 Former Member 2006-12-04T10:30:53Z