topic Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query in Application Development and Automation Discussions

topic Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160905#M1370108 <HTML><HEAD></HEAD><BODY><P>> </P><PRE><CODE><P></P><P>> using select....endselect is not advisable.</P></CODE></PRE><P></P><P>This is old Saying. Any SAP document which claim your statement?</P><P>I have used this at some certain places and it works well! For example, while fetching data from MAKT I want to truncate and concatenate material text with some additional transcript at the place of material text then I would use one temp variable and then append to internal table(in select-endselect), for doing so I can get rid of one additional loop.</P></BODY></HTML> Mon, 05 Oct 2009 07:04:34 GMT Former Member 2009-10-05T07:04:34Z using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160900#M1370103 <HTML><HEAD></HEAD><BODY><P>I using CALL FUNCTION 'READ_TEXT' between select.......endselect query.</P><P>If loop goes to second times then sy-tabix goes to zero.so debugger occurs.why?</P></BODY></HTML> Mon, 05 Oct 2009 06:49:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160900#M1370103 Former Member 2009-10-05T06:49:38Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160901#M1370104 <HTML><HEAD></HEAD><BODY><P>Can you post the code? using select....endselect is not advisable.</P></BODY></HTML> Mon, 05 Oct 2009 06:53:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160901#M1370104 Former Member 2009-10-05T06:53:18Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160902#M1370105 <HTML><HEAD></HEAD><BODY><P>first thing, why do you need read text inside select endselect?</P><P></P><P>make the select fetch data into a internal table and loop at this table, use read text inside the loop</P></BODY></HTML> Mon, 05 Oct 2009 06:56:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160902#M1370105 Former Member 2009-10-05T06:56:14Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160903#M1370106 <HTML><HEAD></HEAD><BODY><P>Do not use select endselect.</P><P></P><P>Use </P><PRE><CODE>select <fields> into itab from <table> where <conditions>.</CODE></PRE><P></P><P></P><P>Now loop at itab and call the read text inside this loop.</P></BODY></HTML> Mon, 05 Oct 2009 06:56:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160903#M1370106 Former Member 2009-10-05T06:56:28Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160904#M1370107 <HTML><HEAD></HEAD><BODY><P>SELECT PRUEFLOS KTEXTMAT MATNR ENSTEHDAT LOSMENGE MENGENEINH ERSTELLER INTO CORRESPONDING FIELDS OF WA_QALS FROM QALS WHERE QALS~AUFNR = IT_QALS-AUFNR ORDER BY PRUEFLOS ENSTEHDAT .</P><P></P><P></P><P></P><P> IT_QALS-PRUEFLOS = WA_QALS-PRUEFLOS.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-KTEXTMAT = WA_QALS-KTEXTMAT.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-MATNR = WA_QALS-MATNR.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-ENSTEHDAT = WA_QALS-ENSTEHDAT.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-LOSMENGE = WA_QALS-LOSMENGE.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-MENGENEINH = WA_QALS-MENGENEINH.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P> IT_QALS-ERSTELLER = WA_QALS-ERSTELLER.</P><P> MODIFY IT_QALS INDEX SY-TABIX.</P><P></P><P></P><P></P><P> DATA: BEGIN OF LTEXT OCCURS 50.</P><P> INCLUDE STRUCTURE TLINE.</P><P> DATA: END OF LTEXT.</P><P></P><P> DATA: TNAME LIKE THEAD-TDNAME.</P><P></P><P></P><P></P><P> MOVE '100040000001097L' TO TNAME.</P><P>data: en like THEAD-TDSPRAS.</P><P>en = 'EN'.</P><P> CALL FUNCTION 'READ_TEXT'</P><P> EXPORTING</P><UL><LI level="1" type="ul"><P> CLIENT = SY-MANDT</P></LI></UL><P> ID = 'QAVE'</P><P> LANGUAGE = EN</P><P> NAME = TNAME</P><P> OBJECT = 'QPRUEFLOS'</P><UL><LI level="1" type="ul"><P> ARCHIVE_HANDLE = 0</P></LI><LI level="1" type="ul"><P> IMPORTING</P></LI><LI level="1" type="ul"><P> HEADER = HTEXT</P></LI></UL><P> TABLES</P><P> LINES = LTEXT.</P><UL><LI level="1" type="ul"><P> EXCEPTIONS</P></LI><LI level="1" type="ul"><P> ID = 1</P></LI><LI level="1" type="ul"><P> LANGUAGE = 2</P></LI><LI level="1" type="ul"><P> NAME = 3</P></LI><LI level="1" type="ul"><P> NOT_FOUND = 4</P></LI><LI level="1" type="ul"><P> OBJECT = 5</P></LI><LI level="1" type="ul"><P> REFERENCE_CHECK = 6</P></LI><LI level="1" type="ul"><P> WRONG_ACCESS_TO_ARCHIVE = 7</P></LI><LI level="1" type="ul"><P> OTHERS = 8.</P></LI><LI level="1" type="ul"></LI></UL><P>loop at ltext.</P><P></P><P>write : / LTEXT.</P><P></P><P>endloop.</P><P></P><P> ENDSELECT.</P><P></P><P></P><P> ENDSELECT.</P></BODY></HTML> Mon, 05 Oct 2009 06:59:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160904#M1370107 Former Member 2009-10-05T06:59:51Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160905#M1370108 <HTML><HEAD></HEAD><BODY><P>> </P><PRE><CODE><P></P><P>> using select....endselect is not advisable.</P></CODE></PRE><P></P><P>This is old Saying. Any SAP document which claim your statement?</P><P>I have used this at some certain places and it works well! For example, while fetching data from MAKT I want to truncate and concatenate material text with some additional transcript at the place of material text then I would use one temp variable and then append to internal table(in select-endselect), for doing so I can get rid of one additional loop.</P></BODY></HTML> Mon, 05 Oct 2009 07:04:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160905#M1370108 Former Member 2009-10-05T07:04:34Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160906#M1370109 <HTML><HEAD></HEAD><BODY><PRE><CODE> SELECT PRUEFLOS KTEXTMAT MATNR ENSTEHDAT LOSMENGE MENGENEINH ERSTELLER INTO CORRESPONDING FIELDS OF IT_QALS "Use internal table FROM QALS WHERE QALS~AUFNR = IT_QALS-AUFNR "modify this condition ORDER BY PRUEFLOS ENSTEHDAT . "Donot use ordey by use sort on it_qals after select </CODE></PRE></BODY></HTML> Mon, 05 Oct 2009 07:06:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160906#M1370109 Former Member 2009-10-05T07:06:45Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160907#M1370110 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Change it this way,</P><P></P><PRE><CODE> DATA: BEGIN OF LTEXT OCCURS 50. INCLUDE STRUCTURE TLINE. DATA: END OF LTEXT. DATA: TNAME LIKE THEAD-TDNAME. SELECT PRUEFLOS KTEXTMAT MATNR ENSTEHDAT LOSMENGE MENGENEINH ERSTELLER INTO CORRESPONDING FIELDS OF table IT_QALS FROM QALS WHERE AUFNR = p_aufnr. "should be getting from a parameter MOVE '100040000001097L' TO TNAME. data: en like THEAD-TDSPRAS. en = 'EN'. CALL FUNCTION 'READ_TEXT' EXPORTING * CLIENT = SY-MANDT ID = 'QAVE' LANGUAGE = EN NAME = TNAME OBJECT = 'QPRUEFLOS' * ARCHIVE_HANDLE = 0 * IMPORTING * HEADER = HTEXT TABLES LINES = LTEXT. * EXCEPTIONS * ID = 1 * LANGUAGE = 2 * NAME = 3 * NOT_FOUND = 4 * OBJECT = 5 * REFERENCE_CHECK = 6 * WRONG_ACCESS_TO_ARCHIVE = 7 * OTHERS = 8. * loop at ltext. write : / LTEXT. endloop. </CODE></PRE><P></P></BODY></HTML> Mon, 05 Oct 2009 07:08:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160907#M1370110 Former Member 2009-10-05T07:08:15Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160908#M1370111 <HTML><HEAD></HEAD><BODY><P>Kartik,</P><P></P><P>always INTO <STRONG>TABLE</STRONG> itab</P><P></P><P>Regards,</P><P></P><P>Clemens</P></BODY></HTML> Mon, 05 Oct 2009 13:13:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160908#M1370111 Clemenss 2009-10-05T13:13:22Z Re: using CALL FUNCTION 'READ_TEXT' between select.......endselect query https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160909#M1370112 <HTML><HEAD></HEAD><BODY><P>Hi Amit,</P><P></P><P>yes you are right. Using SELECT ... ENDSELECT will open the cursor for the database once and fetch the data in packets, default size for ORACLE is 65k.</P><P></P><P>But still it is not advisable, to do other SELECTS between SELECT and ENDSELECT. Function READ_TEXT will do that.</P><P></P><P><EM>Rule of thumb: Use SELECT ... ENDSELECT for simple checks that can't be done using the WHERE clause or other simple modification of the data retrieved.</EM></P><P></P><P>Regards,</P><P></P><P>Clemens</P></BODY></HTML> Mon, 05 Oct 2009 13:21:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-call-function-read-text-between-select-endselect-query/m-p/6160909#M1370112 Clemenss 2009-10-05T13:21:21Z