topic Re: Need help in reading internal table data in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170024#M1822095 <HTML><HEAD></HEAD><BODY><P>Hi Priya ,</P><P>I guess your requirement is to find the latest change number ,that has got change in both ekkn and ekkpo .</P><P></P><P>1- Sort <STRONG>it_cdhdr descending .</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG> Loop at it_chdr into w_cdhdr </STRONG></P><P><STRONG> </STRONG></P><P><STRONG>&nbsp; read table i<STRONG>t_cdpos into w_cdpos with key changenr = w_cdhdr <STRONG>Tabname = ekkn .</STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG>&nbsp;&nbsp; if sy-subrc=0 .</STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; read table it_cdpos into w_cdpos with key changenr <STRONG><STRONG>= w_cdhdr <STRONG>Tabname = ekkpo .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if sy-subrc=0 .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "use convenient&nbsp; way to return change number (using varaiable)"<BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; endif .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp; endif.</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp; endloop .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG><BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>By this way change number send will be the latest having both ekkn and ekkpo . If what i assumed is wrong ,then sorry for that .&nbsp; <BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P></BODY></HTML> Fri, 28 Mar 2014 06:13:51 GMT Former Member 2014-03-28T06:13:51Z Need help in reading internal table data https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170020#M1822091 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two internal tables, it_cdhdr and it_cdpos. Data as follows:</P><P><STRONG>it_cdhdr:</STRONG></P><P><STRONG>Objectclass&nbsp;&nbsp;&nbsp;&nbsp; ObjectId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Changenr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Udate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Change_ind</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273002&nbsp;&nbsp;&nbsp; 20131129&nbsp;&nbsp;&nbsp; U</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; 20131129&nbsp;&nbsp;&nbsp; U</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003272995&nbsp;&nbsp;&nbsp; 20131129&nbsp;&nbsp;&nbsp; U</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; 20131030&nbsp;&nbsp;&nbsp; U</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178903&nbsp;&nbsp;&nbsp; 20131030&nbsp;&nbsp;&nbsp; U</P><P><STRONG>it_cdpos</STRONG></P><P><STRONG>Objectclas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ObjectId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Changenr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tabname&nbsp;&nbsp; Fname Value_new Value_old</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178903&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGKE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178903&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGZU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178903&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; PROCSTAT&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178903&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; RLWRT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKET&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.000</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400.000</P><P><STRONG>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400.00</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGKE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGZU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; PROCSTAT&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; RLWRT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; BRTWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.000</P><P><STRONG>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003272995&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGKE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003272995&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGZU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003272995&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; PROCSTAT&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp; 03</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKET&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.000</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.000</P><P><STRONG>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGKE&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp; A</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGZU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; PROCSTAT&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp; 05</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; RLWRT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; AEDAT&nbsp;&nbsp;&nbsp; 20131129&nbsp;&nbsp;&nbsp; 20131030</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; BRTWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; MENGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.000</P><P><STRONG>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00</STRONG></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273002&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGKE&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp; B</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273002&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; FRGZU&nbsp;&nbsp;&nbsp; X</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273002&nbsp;&nbsp;&nbsp; EKKO&nbsp;&nbsp;&nbsp; PROCSTAT&nbsp;&nbsp;&nbsp; 05&nbsp;&nbsp;&nbsp; 03</P><P></P><P>As per requirement, the main focus is on Changes to EKKN and EKPO tables and I have to get the latest changes.</P><P></P><P>If you observe in above it_cdpos internal table data, it has two records,</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003178904&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800.00</P><P></P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKKN&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500.00</P><P>EINKBELEG&nbsp;&nbsp;&nbsp; 4500057161&nbsp;&nbsp;&nbsp; 0003273001&nbsp;&nbsp;&nbsp; EKPO&nbsp;&nbsp;&nbsp; NETWR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000.00</P><P></P><P>Now I have read only the latest changenr data. Say 0003273001 , in this case.</P><P></P><P>My question is how do I know, the latest changenr has EKKN table changes, if you look at it_cdpos data above, the latest one is 0003273002, which doesnt have EKKN changes.</P><P></P><P>Kindly let me know how to read latest EKKN or EKPO data from IT_CDPOS table.</P><P></P><P>Thanks in advance,</P><P>Rgs,</P><P>Priya</P></BODY></HTML> Wed, 12 Mar 2014 05:38:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170020#M1822091 Former Member 2014-03-12T05:38:06Z Re: Need help in reading internal table data https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170021#M1822092 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>As per my understanding, you can build below mentioned logic:</P><P>1. You can sort on it_cdhdr table BY date time based on field date time Changenr ObjectId&nbsp; in descending order.</P><P>2. Pick the 1st record&nbsp; object id and changenr from it_chdr and further read table it_cdpos based on changenr,objectid &amp; tabname = EKKN and similary for EKPO.</P><P></P><P>If you have any query, please let me know.</P><P></P><P>Regards,</P><P>Sudeesh Soni </P></BODY></HTML> Wed, 12 Mar 2014 06:11:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170021#M1822092 Former Member 2014-03-12T06:11:02Z Re: Need help in reading internal table data https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170022#M1822093 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P></P><P>Sort it_cdhdr BY UDate Descending</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; changenr Ascending .</P><P></P><P>"THis is for Binary search</P><P>sort it_cdpos by objectclass objectid changenr .</P><P></P><P>Loop it_cdhdr</P><P>INTO wa_cdhdr .</P><P></P><P>Read table it_cdpos</P><P>INTO wa_cdpos</P><P>with key objectclass = wa_cdhrd-objectclass objectid = wa_cdhdr-objectid changenr = wa_cdhdr-changenr tabname = EKKN .</P><P></P><P>If sy-subrc = 0</P><P></P><P>"You will get EKKN recrord.</P><P></P><P>ENDIF.</P><P></P><P>clear wa_cdpos .</P><P>Read table it_cdpos </P><P>INTO wa_cdpos</P><P>with key objectclass = wa_cdhrd-objectclass objectid = wa_cdhdr-objectid changenr = wa_cdhdr-changenr tabname = EKPO . </P><P></P><P>If sy-subrc = 0 </P><P></P><P>"You will get EKPO recrord. </P><P></P><P>ENDIF. </P><P></P><P>Endlloop</P></BODY></HTML> Wed, 12 Mar 2014 06:25:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170022#M1822093 Former Member 2014-03-12T06:25:13Z Re: Need help in reading internal table data https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170023#M1822094 <HTML><HEAD></HEAD><BODY><P>Hi Priya,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Please close the thread if your question is clarified Priya, if no, do continue your query. We all will be happy to help you out.</P><P></P><P></P><P></P><P>PS:- If the thread is closed and resolved it can be viewed&nbsp; by others for their reference purpose. Please do let people know whether their answer was useful or not because " SCNians are always their to help their fellow SCNian."&nbsp; <SPAN __jive_emoticon_name="plus" __jive_macro_name="emoticon" class="jive_macro_emoticon jive_macro jive_emote" src="https://community.sap.com/651/images/emoticons/plus.gif"></SPAN> <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro_emoticon jive_macro jive_emote" src="https://community.sap.com/651/images/emoticons/happy.gif"></SPAN></P></BODY></HTML> Fri, 28 Mar 2014 05:45:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170023#M1822094 Former Member 2014-03-28T05:45:24Z Re: Need help in reading internal table data https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170024#M1822095 <HTML><HEAD></HEAD><BODY><P>Hi Priya ,</P><P>I guess your requirement is to find the latest change number ,that has got change in both ekkn and ekkpo .</P><P></P><P>1- Sort <STRONG>it_cdhdr descending .</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG> Loop at it_chdr into w_cdhdr </STRONG></P><P><STRONG> </STRONG></P><P><STRONG>&nbsp; read table i<STRONG>t_cdpos into w_cdpos with key changenr = w_cdhdr <STRONG>Tabname = ekkn .</STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG>&nbsp;&nbsp; if sy-subrc=0 .</STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; read table it_cdpos into w_cdpos with key changenr <STRONG><STRONG>= w_cdhdr <STRONG>Tabname = ekkpo .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if sy-subrc=0 .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "use convenient&nbsp; way to return change number (using varaiable)"<BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; endif .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp;&nbsp; endif.</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>&nbsp; endloop .</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG><BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>By this way change number send will be the latest having both ekkn and ekkpo . If what i assumed is wrong ,then sorry for that .&nbsp; <BR /></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P></BODY></HTML> Fri, 28 Mar 2014 06:13:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/need-help-in-reading-internal-table-data/m-p/10170024#M1822095 Former Member 2014-03-28T06:13:51Z