topic problem in report in Application Development and Automation Discussions

topic problem in report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525275#M1069778 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i made a report and when i m executing it then its wondering in infinite loop. while i m looking in debugger then itab contains only one value and its wondering within select and endselect.</P><P>can anyone plz help me?</P><P></P><P>this is the code.</P><P></P><P>SELECT VKBUR KUNNR FROM VBAK INTO CORRESPONDING FIELDS OF TABLE ITAB</P><P> WHERE KUNNR IN KUNNR</P><P> AND VKBUR IN VKBUR.</P><P>IF SY-SUBRC <> 0.</P><P> MESSAGE 'DATA NOT FOUND.' TYPE 'I'.</P><P>ENDIF.</P><P>SORT ITAB BY KUNNR.</P><P>DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR.</P><P>LOOP AT ITAB.</P><P> SELECT BEZEI FROM TVKBT INTO ITAB-BEZEI WHERE VKBUR = ITAB-VKBUR.</P><P> MODIFY ITAB . "INDEX SY-TABIX TRANSPORTING BEZEI.</P><P> ENDSELECT.</P><P></P><P> SELECT NAME1 FROM KNA1 INTO ITAB-NAME1 WHERE KUNNR = ITAB-KUNNR.</P><P> MODIFY ITAB. " INDEX SY-TABIX TRANSPORTING NAME1.</P><P> ENDSELECT.</P><P></P><P></P><P> SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNA1</P><P> WHERE KUNNR = ITAB-KUNNR.</P><P></P><P></P><P> IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P></P><P> SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNVV</P><P> WHERE KUNNR = ITAB-KUNNR.</P><P> IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P> DELETE ITAB.</P><P></P><P> ELSE.</P><P> ITAB-SEL = ITAB-CASSD.</P><P> APPEND ITAB .</P><P> ENDIF.</P><P> ENDSELECT.</P><P> ELSE.</P><P> ITAB-ALL = ITAB-CASSD.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING ALL.</P><P> ENDIF.</P><P></P><P> IF ITAB-AUFSD NE ''.</P><P> SELECT VTEXT FROM TVAST INTO ITAB-VTEXT WHERE AUFSP = ITAB-AUFSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P></P><P> IF ITAB-LIFSD NE ''.</P><P> SELECT VTEXT FROM TVLST INTO ITAB-VTEXT WHERE LIFSP = ITAB-LIFSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P></P><P> IF ITAB-FAKSD NE ''.</P><P> SELECT VTEXT FROM TVFST INTO ITAB-VTEXT WHERE FAKSP = ITAB-FAKSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P> IF ITAB-ALL NE ''.</P><P> ITAB-VTEXT = 'ALL SALES AREAS'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDIF.</P><P> IF ITAB-SEL NE ''.</P><P> ITAB-VTEXT = 'SELECTED SALES AREAS'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDIF.</P><P> ENDSELECT.</P><P> CLEAR ITAB.</P><P>ENDLOOP.</P><P></P><P>and its performance is also very slow and taking too much time.</P><P></P><P>regards saurabh.</P></BODY></HTML> Tue, 30 Sep 2008 05:08:04 GMT Former Member 2008-09-30T05:08:04Z problem in report https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525275#M1069778 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i made a report and when i m executing it then its wondering in infinite loop. while i m looking in debugger then itab contains only one value and its wondering within select and endselect.</P><P>can anyone plz help me?</P><P></P><P>this is the code.</P><P></P><P>SELECT VKBUR KUNNR FROM VBAK INTO CORRESPONDING FIELDS OF TABLE ITAB</P><P> WHERE KUNNR IN KUNNR</P><P> AND VKBUR IN VKBUR.</P><P>IF SY-SUBRC <> 0.</P><P> MESSAGE 'DATA NOT FOUND.' TYPE 'I'.</P><P>ENDIF.</P><P>SORT ITAB BY KUNNR.</P><P>DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR.</P><P>LOOP AT ITAB.</P><P> SELECT BEZEI FROM TVKBT INTO ITAB-BEZEI WHERE VKBUR = ITAB-VKBUR.</P><P> MODIFY ITAB . "INDEX SY-TABIX TRANSPORTING BEZEI.</P><P> ENDSELECT.</P><P></P><P> SELECT NAME1 FROM KNA1 INTO ITAB-NAME1 WHERE KUNNR = ITAB-KUNNR.</P><P> MODIFY ITAB. " INDEX SY-TABIX TRANSPORTING NAME1.</P><P> ENDSELECT.</P><P></P><P></P><P> SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNA1</P><P> WHERE KUNNR = ITAB-KUNNR.</P><P></P><P></P><P> IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P></P><P> SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNVV</P><P> WHERE KUNNR = ITAB-KUNNR.</P><P> IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P> DELETE ITAB.</P><P></P><P> ELSE.</P><P> ITAB-SEL = ITAB-CASSD.</P><P> APPEND ITAB .</P><P> ENDIF.</P><P> ENDSELECT.</P><P> ELSE.</P><P> ITAB-ALL = ITAB-CASSD.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING ALL.</P><P> ENDIF.</P><P></P><P> IF ITAB-AUFSD NE ''.</P><P> SELECT VTEXT FROM TVAST INTO ITAB-VTEXT WHERE AUFSP = ITAB-AUFSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P></P><P> IF ITAB-LIFSD NE ''.</P><P> SELECT VTEXT FROM TVLST INTO ITAB-VTEXT WHERE LIFSP = ITAB-LIFSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P></P><P> IF ITAB-FAKSD NE ''.</P><P> SELECT VTEXT FROM TVFST INTO ITAB-VTEXT WHERE FAKSP = ITAB-FAKSD</P><P> AND SPRAS = 'EN'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDSELECT.</P><P> ENDIF.</P><P> IF ITAB-ALL NE ''.</P><P> ITAB-VTEXT = 'ALL SALES AREAS'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDIF.</P><P> IF ITAB-SEL NE ''.</P><P> ITAB-VTEXT = 'SELECTED SALES AREAS'.</P><P> MODIFY ITAB INDEX SY-TABIX TRANSPORTING VTEXT.</P><P> ENDIF.</P><P> ENDSELECT.</P><P> CLEAR ITAB.</P><P>ENDLOOP.</P><P></P><P>and its performance is also very slow and taking too much time.</P><P></P><P>regards saurabh.</P></BODY></HTML> Tue, 30 Sep 2008 05:08:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525275#M1069778 Former Member 2008-09-30T05:08:04Z Re: problem in report https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525276#M1069779 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>If you want to improve the performance of you report first </P><P></P><PRE><CODE>SELECT VKBUR KUNNR FROM VBAK INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE KUNNR IN KUNNR AND VKBUR IN VKBUR. IF SY-SUBRC 0. MESSAGE 'DATA NOT FOUND.' TYPE 'I'. ENDIF. SORT ITAB BY KUNNR. DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR. LOOP AT ITAB. SELECT BEZEI FROM TVKBT INTO ITAB-BEZEI WHERE VKBUR = ITAB-VKBUR. MODIFY ITAB . ENDSELECT. " Remove this SELECT..... ENDSELECT</CODE></PRE><P></P><P>and </P><P></P><P>I hope you have not declared the internal tables with exact fields that you want that's why your report is taking more time , so declare the internal table types only with the fields that you want to read the data from the database tables</P><P></P><P></P><P>Regards</P><P>Pavan</P></BODY></HTML> Tue, 30 Sep 2008 05:10:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525276#M1069779 bpawanchand 2008-09-30T05:10:43Z Re: problem in report https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525277#M1069780 <HTML><HEAD></HEAD><BODY><P>hai,</P><P> u have used endselect no of times ,try to use select single instead of endselect.</P><P></P><P>select ..</P><P>endselect.</P><P>it is consider as loop only so try to avoid.</P><P></P><P>shan.</P></BODY></HTML> Tue, 30 Sep 2008 05:14:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525277#M1069780 Former Member 2008-09-30T05:14:28Z Re: problem in report https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525278#M1069781 <HTML><HEAD></HEAD><BODY><P>Hi Friend,</P><P></P><P> In Any Report , try to Avoid select queries in Loop statements.</P><P></P><P>it may affect the performance of the report.</P><P></P><P>Regards,</P><P></P><P>K.S.Kannan.</P></BODY></HTML> Tue, 30 Sep 2008 05:21:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525278#M1069781 Former Member 2008-09-30T05:21:24Z Re: problem in report https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525279#M1069782 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Between select and endselect, you are appending to the same internal table.</P><P>Hence it is going for infinite loop</P><P>Regards</P><P>MD</P><P></P><P>SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNA1</P><P>WHERE KUNNR = ITAB-KUNNR.</P><P></P><P></P><P>IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P></P><P>SELECT CASSD AUFSD LIFSD FAKSD INTO (ITAB-CASSD , ITAB-AUFSD , ITAB-LIFSD , ITAB-FAKSD) FROM KNVV</P><P>WHERE KUNNR = ITAB-KUNNR.</P><P>IF SY-SUBRC = 0 AND ITAB-CASSD = '' AND ITAB-AUFSD = '' AND ITAB-LIFSD = '' AND ITAB-FAKSD = '' .</P><P>DELETE ITAB.</P><P></P><P>ELSE.</P><P><STRONG>ITAB-SEL = ITAB-CASSD.</STRONG></P><P><STRONG>APPEND ITAB .</STRONG></P><P>ENDIF.</P><P>ENDSELECT.</P></BODY></HTML> Tue, 30 Sep 2008 05:29:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-report/m-p/4525279#M1069782 Former Member 2008-09-30T05:29:58Z