topic Re: Select Data from internal table in Application Development and Automation Discussions

Select Data from internal table

Former Member — Tue, 01 Jun 2010 08:47:39 GMT

Dear

i have to some calculation using internal table , nw i have some records in my internal tables , i have to select a multiple no's of records from that internal table . (Not one record ) . How i can select , please help me

Re: Select Data from internal table

arul_murugan — Tue, 01 Jun 2010 09:03:23 GMT

Hi,

I think you cant select from the internal table. Instead of that move the records into another internal table and delete the unwanted records based on your condition.

Thanks

Arul

Edited by: Thomas Zloch on Jun 1, 2010 11:28 AM

Re: Select Data from internal table

Former Member — Tue, 01 Jun 2010 09:08:45 GMT

Hi Shankar,

You can use control Break Statements for doing the calculations in the internal table.

For control break statements search the SCN Forum. You can get lot of examples.

With Regards,

Sumodh.P

Re: Select Data from internal table

Former Member — Tue, 01 Jun 2010 09:09:19 GMT

Hi,

You have the selected data in internal table. You want to do some calculation not one record it should be multiple record

for that you can use LOOP statemet to do the calculation.

LOOP AT ITAB INTO WA.

DO the callculation here.

ENDLOOP.

Re: Select Data from internal table

SuhaSaha — Tue, 01 Jun 2010 09:09:58 GMT

Heard about [LOOP AT itab WHERE|http://help.sap.com/abapdocu_70/en/ABAPLOOP_AT_ITAB_COND.htm#!ABAP_ADDITION_4@4@] ?

Re: Select Data from internal table

Former Member — Tue, 01 Jun 2010 09:11:38 GMT

Check the keyword COLLECT .

Otherwise you have to loop the table and make the summation of the records matching your criteria but this might be slow for big tables.

Re: Select Data from internal table

ThomasZloch — Tue, 01 Jun 2010 09:29:47 GMT

Welcome to SDN.

Please search for available information before posting, ABAP online help etc., do not post basic questions.

Thread locked.

Thomas