topic Re: call transaction error log in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/call-transaction-error-log/m-p/4539853#M1072571 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Try this way,</P><P></P><P>Ex:-</P><P></P><P>CALL TRANSACTION 'XD01' USING i_bdcdata MODE 'N' UPDATE 'S' MESSAGES INTO i_bdcmsgcoll.</P><P></P><P>IF sy-subrc EQ 0</P><P>PERFORM get_success_messages.</P><P>WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> i_upload-kunnr, v_msg.</P><P>ELSE.</P><P>PERFORM get_error_messages.</P><P>WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> i_upload-kunnr, v_msg.</P><P>ENDIF.</P><P></P><P>FORM get_success_messages.</P><P>READ TABLE i_bdcmsgcoll WITH KEY msgtyp EQ 'S'.</P><P>IF sy-subrc EQ 0.</P><P>CALL FUNCTION 'FORMAT_MESSAGE'</P><P>Exporting</P><P> id = i_bdcmsgcoll-msgid</P><P> lang = sy-langu</P><P> no = i_bdcmsgcoll-msgnr</P><P> v1 = i_bdcmsgcoll-msgv1</P><P> v2 = i_bdcmsgcoll-msgv2</P><P>Importing</P><P> msg = v_msg.</P><P>ENDIF.</P><P></P><P>ENDFORM.</P><P> </P><P>FORM get_error_messages.</P><P>READ TABLE i_bdcmsgcoll WITH KEY msgtyp EQ 'E'.</P><P>IF sy-subrc EQ 0.</P><P>CALL FUNCTION 'FORMAT_MESSAGE'</P><P>Exporting</P><P> id = i_bdcmsgcoll-msgid</P><P> lang = sy-langu</P><P> no = i_bdcmsgcoll-msgnr</P><P> v1 = i_bdcmsgcoll-msgv1</P><P> v2 = i_bdcmsgcoll-msgv2</P><P>Importing</P><P> msg = v_msg.</P><P>ENDIF.</P><P></P><P>ENDFORM. </P><P></P><P></P><P>or download all the records to an internal table and downlaod to excel sheet.</P><P></P><P>Regards</P><P>Bala Krishna</P><P></P><P>Edited by: Bala Krishna on Sep 21, 2008 8:59 PM</P></BODY></HTML> Sun, 21 Sep 2008 15:29:01 GMT former_member585060 2008-09-21T15:29:01Z call transaction error log https://community.sap.com/t5/application-development-and-automation-discussions/call-transaction-error-log/m-p/4539852#M1072570 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> In call transaction method a log sheet should be generated. For the successful line items, the corresponding line Document Number should be provided. For the Unsuccessful ones, the error details should be provided.</P><P>Line Item No. Success/ Failure Document Number Error Details</P><P>1 S doc 001 </P><P>2 S Doc 002 </P><P>3 F company code does not exist</P><P>4 F company code does not exist</P><P></P><P>Thus if an excel sheet contains 100 line items and there are 5 such line items which have some inconsistent data or no value is entered in a mandatory field, then a log sheet will be displayed. </P><P></P><P>As rectification, the end-user will go back to his excel sheet, and correct the inconsistent values, and upload the sheet again</P><P></P><P></P><P>thanks in advance</P></BODY></HTML> Sun, 21 Sep 2008 15:10:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/call-transaction-error-log/m-p/4539852#M1072570 Former Member 2008-09-21T15:10:36Z Re: call transaction error log https://community.sap.com/t5/application-development-and-automation-discussions/call-transaction-error-log/m-p/4539853#M1072571 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> Try this way,</P><P></P><P>Ex:-</P><P></P><P>CALL TRANSACTION 'XD01' USING i_bdcdata MODE 'N' UPDATE 'S' MESSAGES INTO i_bdcmsgcoll.</P><P></P><P>IF sy-subrc EQ 0</P><P>PERFORM get_success_messages.</P><P>WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> i_upload-kunnr, v_msg.</P><P>ELSE.</P><P>PERFORM get_error_messages.</P><P>WRITE <span class="lia-unicode-emoji" title=":confused_face:">😕</span> i_upload-kunnr, v_msg.</P><P>ENDIF.</P><P></P><P>FORM get_success_messages.</P><P>READ TABLE i_bdcmsgcoll WITH KEY msgtyp EQ 'S'.</P><P>IF sy-subrc EQ 0.</P><P>CALL FUNCTION 'FORMAT_MESSAGE'</P><P>Exporting</P><P> id = i_bdcmsgcoll-msgid</P><P> lang = sy-langu</P><P> no = i_bdcmsgcoll-msgnr</P><P> v1 = i_bdcmsgcoll-msgv1</P><P> v2 = i_bdcmsgcoll-msgv2</P><P>Importing</P><P> msg = v_msg.</P><P>ENDIF.</P><P></P><P>ENDFORM.</P><P> </P><P>FORM get_error_messages.</P><P>READ TABLE i_bdcmsgcoll WITH KEY msgtyp EQ 'E'.</P><P>IF sy-subrc EQ 0.</P><P>CALL FUNCTION 'FORMAT_MESSAGE'</P><P>Exporting</P><P> id = i_bdcmsgcoll-msgid</P><P> lang = sy-langu</P><P> no = i_bdcmsgcoll-msgnr</P><P> v1 = i_bdcmsgcoll-msgv1</P><P> v2 = i_bdcmsgcoll-msgv2</P><P>Importing</P><P> msg = v_msg.</P><P>ENDIF.</P><P></P><P>ENDFORM. </P><P></P><P></P><P>or download all the records to an internal table and downlaod to excel sheet.</P><P></P><P>Regards</P><P>Bala Krishna</P><P></P><P>Edited by: Bala Krishna on Sep 21, 2008 8:59 PM</P></BODY></HTML> Sun, 21 Sep 2008 15:29:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/call-transaction-error-log/m-p/4539853#M1072571 former_member585060 2008-09-21T15:29:01Z