Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
to populate the selected data into the fields with similar name that is there in the actual table structure. If the order of the fields in the table structure and the order u r selecting in a select statement is different and if u r not using corresponding fields, uwill get runtime error.
If u use INTO CORRESPONDING FIELDS OF TABLE it will not trigger runtime error . it just copies the data into internal table by comparing the names of the fields...
It is used in the case when your internal table in which you are populating the data having more number or in different order of fields than the table from where you are fetching the data.
data : begin of itab occurs 0,
include structure mara.
data : end of itab.
select matnr mktxt from mara into corresponding fields of table itab
from mara
where conditions.
Here if you will not use into corresponding fields of table you will not get the correct result
INTO CORRESPONDING FIELDS OF TABLE is very inefficient. It is much better to set up the internal table with the same structure as the database table and use INTO TABLE.
Actually we use INTO CORRESPONDING FIELDS OF TABLE to map exactly the fields of our internal table with the exact fields of the database table and avoid reduced performance.
We can also go without this into corresponding syntax but performance decreases without this as all the fields are checked for the mapping. So We go for this syntax.
IF U R TABLE HAS FIELDS WHICH ARE NOT IN THE ORDER IN THE ACTUAL D/B TABLE AND IF U R TABLE HAS FIELDS FROM DIFFERENT D/B TABLES THEN U USE CORRESPONDING...
EG
TYPES: BEGIN OF GS_ITAB,
MATNR TYPE MARA-MATNR,
MATKL TYPE MARA-MATKL,
END OF GS_ITAB.
DATA : ITAB TYPE TABLE OF GS_ITAB.
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE...
If the target structure has less number of fields than selected from the database ,
its recommended to use INTO CORRESPONDING FIELDS, by this field having the same data type goes into the correct target fields , otherwise it will cause dump .
Its always good the select the number of fields in the target area in your select statement .
Instead of using INTO in selecting data its better to use INTO CORRESPONDING FIELDS OF TABLE if the internal table has different line type as database table but similar fields.....
while retrieving from data base through INTO statement it will assume that the table has same line type/structure of database table...but if the structure is not same it will goto dump.In such cases it is better to use INTO CORRESPONDING FIELDS OF TABLE.in this case data will be retrieved into the fields by searching the names of the internal table...........
Bluesky
