topic Re: TABLE CONTROL in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541374#M852007 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Chk this code..</P><P></P><P>IN PAI,</P><P><STRONG>Module user command:</STRONG></P><P></P><P> WHEN 'DELETE'.</P><P> delete1 = '1'.</P><P></P><P> CALL FUNCTION 'POPUP_TO_CONFIRM' "Function Call For Popup Window - confirmation for deletion</P><P> EXPORTING</P><P> titlebar = 'DELETION CONFIRMATION'</P><P> text_question = 'ARE YOU SURE YOU WANT TO DELETE THE SELECTED RECORD?'</P><P> text_button_1 = 'YES'(001)</P><P> icon_button_1 = 'ICON_OK'</P><P> text_button_2 = 'NO'(002)</P><P> icon_button_2 = 'ICON_CANCEL'</P><P> default_button = '1'</P><P> display_cancel_button = 'X'</P><P> IMPORTING</P><P> answer = answer1</P><P> EXCEPTIONS</P><P> text_not_found = 1</P><P> OTHERS = 2.</P><P> IF sy-subrc &lt;&gt; 0.</P><P> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno</P><P> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.</P><P> ENDIF.</P><P></P><P><STRONG>MODULE DELETE:</STRONG></P><P></P><P>WHEN 'DELETE'.</P><P> GET CURSOR LINE line1.</P><P> IF answer1 = '1'.</P><P> IF delete1 = '1'.</P><P> IF table1-current_line = line1.</P><P> IF wi_zcust-status = 'INACTIVE'.</P><P> MESSAGE e024(zbank1msg). "DELIMITED RECORDS CANNOT BE DELETED OR MODIFIED</P><P> ENDIF.</P><P> CLEAR wi_zcust-status.</P><P> wi_zcust-status = 'INACTIVE'.</P><P> SELECT * FROM zacc_master2 WHERE customerid = wi_zcust-customerid.</P><P> IF sy-subrc = 0.</P><P> IF zacc_master2-status = 'INACTIVE'.</P><P> MODIFY wi_zcust INDEX table1-current_line.</P><P> MODIFY zcust_master2 FROM TABLE wi_zcust.</P><P> DISABLE1 = 1.</P><P> ELSE.</P><P> MESSAGE e023(zbank1msg). "ACCOUNTS EXIST DELETION NOT ALLOWED</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDSELECT.</P><P></P><P> IF sy-subrc = 0.</P><P> MESSAGE s020(zbank1msg). "RECORD DELETED</P><P> ELSE.</P><P> MESSAGE e021(zbank1msg). "RECORD NOT DELETED</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P>ENDCASE.</P><P></P><P>Regards,</P><P>Arunsri</P></BODY></HTML> Wed, 12 Mar 2008 04:44:01 GMT Former Member 2008-03-12T04:44:01Z TABLE CONTROL https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541372#M852005 <HTML><HEAD></HEAD><BODY><P>HOW TO SELECT A ROW FROM A SCREEN TABLE CONTROL.THE SCENARIO IS THAT I HAVE TO DELETE A ROW FROM THE TABLE CONTROL SUCH THAT THE RESULT SHOULD B REFLECTED IN THE DATABASE TABLE TO WHICH THE ELEMENTS OF THIS TABLE CONTROL ARE LINKED.I.E A CORRESPONDING ROW FROM DB TABLE SHOULD ALSO BE DELETED.</P></BODY></HTML> Wed, 12 Mar 2008 04:40:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541372#M852005 Former Member 2008-03-12T04:40:26Z Re: TABLE CONTROL https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541373#M852006 <HTML><HEAD></HEAD><BODY><P>Refer to below related threads</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="4594794"></A></P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="3109300"></A></P><P></P><P></P><P>Regards,</P><P>Santosh</P></BODY></HTML> Wed, 12 Mar 2008 04:42:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541373#M852006 Former Member 2008-03-12T04:42:30Z Re: TABLE CONTROL https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541374#M852007 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Chk this code..</P><P></P><P>IN PAI,</P><P><STRONG>Module user command:</STRONG></P><P></P><P> WHEN 'DELETE'.</P><P> delete1 = '1'.</P><P></P><P> CALL FUNCTION 'POPUP_TO_CONFIRM' "Function Call For Popup Window - confirmation for deletion</P><P> EXPORTING</P><P> titlebar = 'DELETION CONFIRMATION'</P><P> text_question = 'ARE YOU SURE YOU WANT TO DELETE THE SELECTED RECORD?'</P><P> text_button_1 = 'YES'(001)</P><P> icon_button_1 = 'ICON_OK'</P><P> text_button_2 = 'NO'(002)</P><P> icon_button_2 = 'ICON_CANCEL'</P><P> default_button = '1'</P><P> display_cancel_button = 'X'</P><P> IMPORTING</P><P> answer = answer1</P><P> EXCEPTIONS</P><P> text_not_found = 1</P><P> OTHERS = 2.</P><P> IF sy-subrc &lt;&gt; 0.</P><P> MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno</P><P> WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.</P><P> ENDIF.</P><P></P><P><STRONG>MODULE DELETE:</STRONG></P><P></P><P>WHEN 'DELETE'.</P><P> GET CURSOR LINE line1.</P><P> IF answer1 = '1'.</P><P> IF delete1 = '1'.</P><P> IF table1-current_line = line1.</P><P> IF wi_zcust-status = 'INACTIVE'.</P><P> MESSAGE e024(zbank1msg). "DELIMITED RECORDS CANNOT BE DELETED OR MODIFIED</P><P> ENDIF.</P><P> CLEAR wi_zcust-status.</P><P> wi_zcust-status = 'INACTIVE'.</P><P> SELECT * FROM zacc_master2 WHERE customerid = wi_zcust-customerid.</P><P> IF sy-subrc = 0.</P><P> IF zacc_master2-status = 'INACTIVE'.</P><P> MODIFY wi_zcust INDEX table1-current_line.</P><P> MODIFY zcust_master2 FROM TABLE wi_zcust.</P><P> DISABLE1 = 1.</P><P> ELSE.</P><P> MESSAGE e023(zbank1msg). "ACCOUNTS EXIST DELETION NOT ALLOWED</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDSELECT.</P><P></P><P> IF sy-subrc = 0.</P><P> MESSAGE s020(zbank1msg). "RECORD DELETED</P><P> ELSE.</P><P> MESSAGE e021(zbank1msg). "RECORD NOT DELETED</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P> ENDIF.</P><P>ENDCASE.</P><P></P><P>Regards,</P><P>Arunsri</P></BODY></HTML> Wed, 12 Mar 2008 04:44:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-control/m-p/3541374#M852007 Former Member 2008-03-12T04:44:01Z