topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Tue, 27 Nov 2007 02:19:36 GMT

load the data to internal table by using select statement and load the data to structure by using selct statement ...

is both r same ..

when we use SELECT AND ENDSLECT ?

Regards,

pandu.

Re: internal table

Former Member — Tue, 27 Nov 2007 02:38:37 GMT

Hi,

if you are populating the structure...then you have to use SELECT..ENDSELECT.

Then inside that you either populate either an internal table or directly do the processing..performance wise it will be slower..

If you use SELECT ..INTO TABLE...Then it is directly populating the internal table with the database records...The performance will be much higher...

Thanks

Naren

Re: internal table

Former Member — Tue, 27 Nov 2007 03:51:07 GMT

Hi Pandu,

If you want the fill the structure then you use

SELECT.... ENDSELECT.

If you want to fill the internal table directly from Database Table

Then u need to use

SELECT...INTO TABLE

Hope this clears your doubt.

Regards,

Chandru

Re: internal table

Former Member — Tue, 27 Nov 2007 04:02:45 GMT

Hi,

Use of EndSelect statment should be avoided.

So use SELECT SINGLE to load data to structure and Use SELECT.....INTO TABLE <internal table> to load data to internal table.

Regards,

Amit

Re: internal table

Former Member — Tue, 27 Nov 2007 04:06:45 GMT

hi,

select * from kna1.

write: kna1-kunnr.

endselect.------> Use it.

select * from kna1 into table itab.

write: itab-kunnr.

Endselect------> donot use it.

Re: internal table

Former Member — Tue, 27 Nov 2007 04:07:20 GMT

hi,

select * from kna1.

write: kna1-kunnr.

endselect.------> Use it.

select * from kna1 into table itab.

write: itab-kunnr.

Endselect------> donot use it.

Warm Regards,

S.Suresh.

reward if useful......

Re: internal table

Former Member — Tue, 27 Nov 2007 05:16:22 GMT

when we use SELECT , ENDSELECT

and select into?

Regards,

pandu.

Re: internal table

Former Member — Tue, 27 Nov 2007 05:21:33 GMT

You should use SELECT..ENDSELECT when you want to copy the contents to structure from Database table.

You should use SELECT..INTO TABLE when you want to copy the contents to Internal Table from Database table.

In order to avoid ENDSELECT while copying data to Structure use

SELECT SINGLE. For this no need to use ENDSELECT.

Re: internal table

Former Member — Tue, 27 Nov 2007 06:10:18 GMT

you should always avoid using select and endselect.

if u want to copy it to a structure use select single.

Re: internal table

Former Member — Tue, 27 Nov 2007 07:59:40 GMT

hai Pandu,

In some cases we have to go with SELECT ............ENDSELECT.

SELECT.........ENDSELECT is act like a loop.

SELECT * INTO CORRESPONDING FIELDS OF WF_AUFK FROM AUFK

WHERE AUFNR IN WP_AUFNR

AND BUKRS = WP_BUKRS

AND GSBER = WP_GSBER.

...................some logics...............................

SELECT * INTO CORRESPONDING FIELDS OF WF_EKKN

FROM EKKN

WHERE AUFNR = WF_AUFK-AUFNR

....................some logics.................................

CLEAR WT_DETAIL_TBL.

WT_DETAIL_TBL-WF_PSPID = WF_AUFK-AUFNR.

WT_DETAIL_TBL-WF_POST1 = WF_AUFK-KTEXT.

WT_DETAIL_TBL-WF_SUB_CD = WF_EKKN-SAKTO.

WT_DETAIL_TBL-WF_EBELN = WF_EKKN-EBELN.

WT_DETAIL_TBL-WF_SORT_PI = WF_EKKN-EBELN.

ENDSELECT.

this statement will take first record from database table and perform the necessary logic present within the SELECT ............ENDSELECT.when the processing of the first record is over, endselect event will triger. after that it will goto above select statement and it will check database table for another record suitable for that selelction criteria.after processing the each record the records willl be stored in a internaal table. so interaction with the database is high.that is y some peoplpes asking u to avoid

SELECT ............ENDSELECT.

LOAD THE DATA INTO THE INTERNAL TABLE.

In this case, interaction with the database is less, bcoz u r retrieveing all the data at first time and storing it into internal table. after that u r processing it from internal table, these are the main differences.its quick processing.

i think ur doubt will be clear.

regards,

shafi.

Re: internal table

Former Member — Tue, 27 Nov 2007 08:01:17 GMT

after load the data into internal table, we will loop that internal table for further processing.