topic Re: How to sort an message internal table.? in Application Development and Automation Discussions

topic Re: How to sort an message internal table.? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192089#M1519982 <HTML><HEAD></HEAD><BODY><P>If your getting this dump in standard program then you have to contact SAP on this issue.</P><P></P><P>If you are using some standard FM return message internal table in custom program then you can delete adjacent duplicates no issues.</P></BODY></HTML> Tue, 17 Aug 2010 06:57:12 GMT former_member206439 2010-08-17T06:57:12Z How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192083#M1519976 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P>I'm looping the standard messages of SAP into an internal table.</P><P>The standard messages were stored in SAP internal table as below format.</P><P></P><P>MSGTYP MSGID MSGNO MSGV1 MSGV2 MSGV3</P><P></P><P>W FB_ICRC 058 1 Company 008340</P><P>W FB_ICRC 058 2 Company 008340</P><P>W FB_ICRC 058 3 Company 008340</P><P>W FB_ICRC 058 4 Company 008340</P><P>W FB_ICRC 058 5 Company 008340</P><P></P><P></P><P>I am using the function module CALL FUNCTION 'FORMAT_MESSAGE' and pass the above parameters ,to get the original messages..</P><P>My Issue is that i am getting the duplicate entries in the internal table,</P><P></P><P>Line 5: Field Company: 008340 not valid according to restrictions</P><P>Line 4: Field Company: 008340 not valid according to restrictions</P><P>Line 3: Field Company: 008340 not valid according to restrictions</P><P>Line 2: Field Company: 008340 not valid according to restrictions</P><P>Line 1: Field Company: 008340 not valid according to restrictions</P><P>Line 4: Field Company: 008340 not valid according to restrictions</P><P>Line 3: Field Company: 008340 not valid according to restrictions</P><P>Line 2: Field Company: 008340 not valid according to restrictions</P><P>Line 1: Field Company: 008340 not valid according to restrictions</P><P>Line 3: Field Company: 008340 not valid according to restrictions</P><P>Line 2: Field Company: 008340 not valid according to restrictions</P><P>Line 1: Field Company: 008340 not valid according to restrictions</P><P>Line 2: Field Company: 008340 not valid according to restrictions</P><P>Line 1: Field Company: 008340 not valid according to restrictions</P><P></P><P></P><P>I'm getting the duplicate entries which is leading to SAP Dump because of Paging Memory ...while i'm trying to export the internal table...</P><P></P><P>How to eliminate the duplicate entries in the above internal table?</P></BODY></HTML> Tue, 17 Aug 2010 06:26:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192083#M1519976 Former Member 2010-08-17T06:26:52Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192084#M1519977 <HTML><HEAD></HEAD><BODY><P>SORT the table based on MSGTYP MSGID MSGNO and delete the adjacent duplicates from the table by using DELETE ADJACENT DUPLICATES statement.</P></BODY></HTML> Tue, 17 Aug 2010 06:29:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192084#M1519977 former_member206439 2010-08-17T06:29:41Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192085#M1519978 <HTML><HEAD></HEAD><BODY><P>Can i use the function module BAL_LOG_MSG_ADD instead of 'FORMAT_MESSAGE' to eliminate the duplicate entries?</P></BODY></HTML> Tue, 17 Aug 2010 06:29:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192085#M1519978 Former Member 2010-08-17T06:29:53Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192086#M1519979 <HTML><HEAD></HEAD><BODY><P>Hi naresh,</P><P></P><P>The MSG TYP, MSG ID were in SAP internal table (standard) i cant change the standard fuunctionality.</P></BODY></HTML> Tue, 17 Aug 2010 06:32:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192086#M1519979 Former Member 2010-08-17T06:32:51Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192087#M1519980 <HTML><HEAD></HEAD><BODY><P>You said you are using 'FORMAT_MESSAGE' to display the message. So we understand there is a custom code written somewhere. This implies you've access to the internal table with the messages. The idea is to sort the table & delete the duplicate recs before calling 'FORMAT_MESSAGE'.</P><P></P><PRE><CODE>SORT IT_MSG. DELETE ADJACENT DUPLICATES FROM IT_MSG COMPARING ALL FIELDS.</CODE></PRE><P></P><P>Now i don't understand why you can't write the above logic in your code.</P><P></P><P>BR,</P><P>Suhas</P><P></P><P>PS: You can use MESSAGE ... INTO addition instead of FORMAT_MESSAGE to get the message text.</P></BODY></HTML> Tue, 17 Aug 2010 06:38:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192087#M1519980 SuhaSaha 2010-08-17T06:38:59Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192088#M1519981 <HTML><HEAD></HEAD><BODY><P>Try the below code</P><P></P><PRE><CODE>LOOP AT it_msg ASSIGNING <fs_msg>. MESSAGE ID <fs_msg>-msgid TYPE <fs_msg>-msgty NUMBER <fs_msg>-msgno INTO wa_msg WITH <fs_msg>-msgv1 <fs_msg>-msgv2 <fs_msg>-msgv3. APPEND wa_msg TO it_output. ENDLOOP. SORT it_output ASCENDING. DELETE ADJACENT DUPLICATES FROM it_output COMPARING ALL FIELDS.</CODE></PRE><P></P></BODY></HTML> Tue, 17 Aug 2010 06:54:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192088#M1519981 Former Member 2010-08-17T06:54:31Z Re: How to sort an message internal table.? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192089#M1519982 <HTML><HEAD></HEAD><BODY><P>If your getting this dump in standard program then you have to contact SAP on this issue.</P><P></P><P>If you are using some standard FM return message internal table in custom program then you can delete adjacent duplicates no issues.</P></BODY></HTML> Tue, 17 Aug 2010 06:57:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-sort-an-message-internal-table/m-p/7192089#M1519982 former_member206439 2010-08-17T06:57:12Z