Skip to Content
avatar image
Former Member

SELECT - ENDSELECT RECORD

Hi guys , I´m doing a select endselect but i see only one record at the time , If wanted to process when I´m processing the last record , what I could do , for example is something similiar of waht you do loop at . endloop ' s at last , but here i dont have a internal table .

some code :


      SELECT extrow FROM esll INTO ti_esll-extrow
      WHERE packno = ti_eslh-packno
      AND  del   = ''.
 
    " if last register Perfom xxxxx. 


      endselect .



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 15, 2008 at 11:52 AM

    Hi,

    Why r u doing select and endselect?

    Fetch all records into an internal table then loop that and use at last.

    Rhea.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 11:56 AM

    Hi,

    Create an internal table like ti_esll-extrow with header line.

    select into that internal table.

    then loop at <int table>.

    <use at last here>

    endloop.

    regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2008 at 11:57 AM

    Hi ,

    Fetch the all records and append to the internal table .

    Regards,

    Bharani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 11:57 AM

    Hi,

    You do one thing..

    Declare an intermediate variable (work area) where you want to store the details.

    Then continue like this.

    Clear Variable(work area).

    Select .....................

    " assign value to the variable of work area usign which you want to perform your operions.

    endselect.

    After the final loop is over you will have your record in the variabl/work area.

    Now perform your operation using that variable/work area.

    Regards,

    Pramod

    Add comment
    10|10000 characters needed characters exceeded