topic internal table serching.. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/internal-table-serching/m-p/1302087#M158826 <HTML><HEAD></HEAD><BODY><P>Dear friends</P><P> I m working on problem in which i need to extract the 2 type of matching records. 1 is 100% matching records from the internal table where 7 out 7 criteria is matching. 2. where 6 out of 7 criteria is matching(90% matching). in both the scenario i need to transfer records in the respective internal tables.. here i have done 50% work by searching 100% matching fields where in 90% matching field my code is not working or i had done some mistake.. please help me to figure out or give me some idea to carry out this task. i m giving you the code.</P><P>in my code: first condition is giving me 100% matching where on the sy-subrc ne 0 it triggered second part where i m checking 7 times by dropping one field in each read statment, but it is not working. please help me to sort out this issue. thanx</P><P>regards, naim</P><P>sort i_bp_p by title initials name_last idnumber idtype f50code rbcode. "acc_num.</P><P>data: wa_i_bp_p_read1 like wa_i_bp_p.</P><P>loop at i_bp_p into wa_i_bp_p.</P><P> lv_tabix = sy-tabix.</P><P> lv_tabix = lv_tabix + 1.</P><P> read table i_bp_p index lv_tabix into wa_i_bp_p_read1</P><P> comparing idnumber</P><P> idtype</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode</P><P> transporting partner</P><P> idnumber</P><P> idtype</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode.</P><P></P><P> if sy-subrc = 0.</P><P> move-corresponding wa_i_bp_p_read1 to i_bp_p100.</P><P> append i_bp_p100.</P><P> clear i_bp_p100.</P><P> move-corresponding wa_i_bp_p to i_bp_p100.</P><P> append i_bp_p100.</P><P> clear i_bp_p100.</P><P></P><P> elseif sy-subrc ne 0.</P><P></P><P>read table i_bp_p index lv_tabix into wa_i_bp_p</P><P> comparing idnumber</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode</P><P> transporting partner</P><P> idnumber</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode.</P><P> if sy-subrc = 0.</P><P> move-corresponding wa_i_bp_p_read1 to i_bp_p90.</P><P> append i_bp_p90.</P><P> clear i_bp_p90.</P><P> endif.</P><P> elseif sy-subrc ne 0.</P></BODY></HTML> Sun, 04 Jun 2006 07:43:35 GMT naimkhans_babi 2006-06-04T07:43:35Z internal table serching.. https://community.sap.com/t5/application-development-and-automation-discussions/internal-table-serching/m-p/1302087#M158826 <HTML><HEAD></HEAD><BODY><P>Dear friends</P><P> I m working on problem in which i need to extract the 2 type of matching records. 1 is 100% matching records from the internal table where 7 out 7 criteria is matching. 2. where 6 out of 7 criteria is matching(90% matching). in both the scenario i need to transfer records in the respective internal tables.. here i have done 50% work by searching 100% matching fields where in 90% matching field my code is not working or i had done some mistake.. please help me to figure out or give me some idea to carry out this task. i m giving you the code.</P><P>in my code: first condition is giving me 100% matching where on the sy-subrc ne 0 it triggered second part where i m checking 7 times by dropping one field in each read statment, but it is not working. please help me to sort out this issue. thanx</P><P>regards, naim</P><P>sort i_bp_p by title initials name_last idnumber idtype f50code rbcode. "acc_num.</P><P>data: wa_i_bp_p_read1 like wa_i_bp_p.</P><P>loop at i_bp_p into wa_i_bp_p.</P><P> lv_tabix = sy-tabix.</P><P> lv_tabix = lv_tabix + 1.</P><P> read table i_bp_p index lv_tabix into wa_i_bp_p_read1</P><P> comparing idnumber</P><P> idtype</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode</P><P> transporting partner</P><P> idnumber</P><P> idtype</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode.</P><P></P><P> if sy-subrc = 0.</P><P> move-corresponding wa_i_bp_p_read1 to i_bp_p100.</P><P> append i_bp_p100.</P><P> clear i_bp_p100.</P><P> move-corresponding wa_i_bp_p to i_bp_p100.</P><P> append i_bp_p100.</P><P> clear i_bp_p100.</P><P></P><P> elseif sy-subrc ne 0.</P><P></P><P>read table i_bp_p index lv_tabix into wa_i_bp_p</P><P> comparing idnumber</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode</P><P> transporting partner</P><P> idnumber</P><P> title</P><P> initials</P><P> name_last</P><P> f50code</P><P> rbcode.</P><P> if sy-subrc = 0.</P><P> move-corresponding wa_i_bp_p_read1 to i_bp_p90.</P><P> append i_bp_p90.</P><P> clear i_bp_p90.</P><P> endif.</P><P> elseif sy-subrc ne 0.</P></BODY></HTML> Sun, 04 Jun 2006 07:43:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/internal-table-serching/m-p/1302087#M158826 naimkhans_babi 2006-06-04T07:43:35Z Re: internal table serching.. https://community.sap.com/t5/application-development-and-automation-discussions/internal-table-serching/m-p/1302088#M158827 <HTML><HEAD></HEAD><BODY><P>Copy the contents of i_bp_p into another table say i_bp_p_temp.</P><P></P><P>First sort i_bp_p_temp by 7 fields.</P><P></P><P>loop at i_bp_p.</P><P>read table i_bp_p_temp using KEY addition for the 7 fields.</P><P>if sy-subrc ne 0.</P><P>sort i_bp_p_temp again .. this time with 6 fields.</P><P>do read again.</P><P>if sy-subrc ne 0.</P><P>sort i_bp_p_temp again .. this time with 5 fields.</P><P>do read again.</P><P> .</P><P> .</P><P> .</P><P>endloop. </P><P></P><P>Try this and let me know if it works.</P></BODY></HTML> Sun, 04 Jun 2006 13:12:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/internal-table-serching/m-p/1302088#M158827 nishanthbhandar 2006-06-04T13:12:06Z