Skip to Content
avatar image
Former Member

How to avoid corresponding in select

Hi,

What are the diff. ways to avoid corresponding in select query.

Rgds,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 25, 2010 at 06:19 AM

    Hi,

    Write the Select Query fields in the order of the Database table and declare the Internal table in the same order. So that u can avoind correspoding .

    Regards,

    Vijaya Lakshmi.T

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 25, 2010 at 06:30 AM

    Create a structure using TYPES and have fields in this structure in same sequence as in database table, then in the select fetch the fields in the same order into an internal table whose type is of above structure so you wont need into corresponding fields clause

    Add comment
    10|10000 characters needed characters exceeded