Skip to Content

Hi…

Usage of Into corresponding fields :

Internal table:

Internal tables provide a means of taking data from a fixed structure and storing it in working memory in ABAP. The data is stored line by line in memory, and each line has the same structure.

/wp-content/uploads/2013/07/1_251998.jpg

         

 

Select statement will fetch the data from the column erdat, kunnr, name1 and land1 from table KNA1 and places the data in the internal table , here the data will be inserted based on the fields created in the structure. 

/wp-content/uploads/2013/07/2_252008.jpg

The above pic shows the internal table is filled with the data with select statement,  but here the data of erdat is stored in the kunnr field of the internal table and the kunnr data is filled in erdat field of the internal table. Please refer the above pic clearly.

Whenever we execute the above statement, we get the below dump.

/wp-content/uploads/2013/07/3_252083.jpg

The above dump is displayed because we are placing the data of one field in another field as a result we are getting the dump. The dump message clearly explains the message.

So to avoid this situation we use the keyword “INTO CORRESPONDING FIELDS “ to place the data in the required fields.  The  program demonstrates the into corresponding fields keyword, whenever we use that keyword the data will be placed in the corresponding fields irrespective of the order present in the select statement.

/wp-content/uploads/2013/07/4_252085.jpg

Please observe closely the data movement of the data when we write the select statement, as i have drawn the curve showing the direction of the records to be stored.

Hope u got it,

To report this post you need to login first.

27 Comments

You must be Logged on to comment or reply to a post.

  1. Birajini Devi

    Hi Ravi,

        Way of explanation is  really awesome.This blog’s  very useful for the beginners.

    I like the BLOG with clear concept.

    Regards,

    Birajini

    (0) 
  2. Ranganath Korata

    Hi Ravi,

    It is a well explained blog with diagrams and screenshot. I have a doubt which I’d like to discuss. I remember being told during my training to avoid using “INTO CORRESPONDING FIELDS OF”, and I think the reason was that the system checks for matching column names, which is an additional step and a unnecessary burden on the system. To avoid this, I used to SELECT fields in the order the Internal table structure was defined.

    I later came across some senior developers who told me that Selecting fields from a base table in the sequence in which fields are listed is the efficient way of writing a SELECT statement. This made me switch back to using “INTO CORRESPONDING FIELDS OF”.

    Basically I received conflicting answers from different developers. So, now that there is a blog on it, I’d like to discuss/know which one has precedence. Please let me know your thoughts on it.

    Thanks,

    Ranga.

    (0) 
    1. Ravi Chandra Post author

      Hi ranga,

      If you write into corresponding fields, then it will degrade the performance, because it has to search for the corresponding fields in the internal table and then it has to load the data into that fields.

      You have to use this keyword, if you don’t remember the sequence of the fields in the table.

      Hope u got it,

      (0) 
  3. Kamal Mehta

    Again informative , short , Concept is clear.

    We shall be waiting for your blogs in various other scenarios in BW Modeling , Extraction , Reporting as well.

    Thanks

    (0) 

Leave a Reply