topic Performance with internal table and processing Records in Application Development and Automation Discussions

Performance with internal table and processing Records

Former Member — Thu, 24 Apr 2008 06:17:30 GMT

Hi All

Can any one suggest some better ways to declare the internal table and effective statements to process the records in the internal table..

Kindly send model reports with the above criteria.

Thanks and Regards

Arun Joseph

Re: Performance with internal table and processing Records

Former Member — Thu, 24 Apr 2008 06:28:12 GMT

In case you have to LOOP through an internal table or you have to READ from an internal table, use FIELD-SYMBOLS instead of usual workareas.

When READing from internal table, make shure that the table is sorted or hashed and that you declared a good key.

reward points if helpful

Re: Performance with internal table and processing Records

Former Member — Thu, 24 Apr 2008 06:35:39 GMT

Hi,

Go through this for better insight :

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb366d358411d1829f0000e829fbfe/content.htm

Table declaration (old method)

DATA: BEGIN OF tab_ekpo OCCURS 0, "itab with header line

ebeln TYPE ekpo-ebeln,

ebelp TYPE ekpo-ebelp,

END OF tab_ekpo.

*Table declaration (new method n better)

TYPES: BEGIN OF t_ekpo,

ebeln TYPE ekpo-ebeln,

ebelp TYPE ekpo-ebelp,

END OF t_ekpo.

DATA: it_ekpo TYPE STANDARD TABLE OF t_ekpo INITIAL SIZE 0, "itab

wa_ekpo TYPE t_ekpo. "work area (header line)

Build internal table and work area from existing internal table (obsolete now)

DATA: it_datatab LIKE tab_ekpo OCCURS 0,

wa_datatab LIKE LINE OF tab_ekpo.

Build internal table and work area from existing internal table,
adding additional fields

TYPES: BEGIN OF t_repdata.

INCLUDE STRUCTURE tab_ekpo. "could include EKKO table itself!!

TYPES: bukrs TYPE ekpo-werks,

bstyp TYPE ekpo-bukrs.

TYPES: END OF t_repdata.

DATA: it_repdata TYPE STANDARD TABLE OF t_repdata INITIAL SIZE 0, "itab

wa_repdata TYPE t_repdata.

Re: Performance with internal table and processing Records

Former Member — Thu, 24 Apr 2008 07:24:24 GMT

Can you suggest me some better ways to process the internal table records??

I mean to say read table,collect, etc..

Thanks and Regards

Arun Joseph

Re: Performance with internal table and processing Records

Former Member — Thu, 24 Apr 2008 08:04:20 GMT

1) Avoid nested loop, if possible.

if the internal table is large use binary search to read the entries otherwise u can read the entries directly.

for processing huge internal tables use parallel cursor concept.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/abap%2bcode%2bfor%2bparallel%2bcursor%2b-%2bloop%2bprocessing

2) sort the internal table based on ur requirement. this will help u in faster retrieval of data.

3) With COLLECT lines with identical key are aggregated to one line, all numeric fields are summed up automatically

4) u can use "transporting" with READ statement if the internal table has more fields and required fields for processing are less.

5) u can use field-symbols for direct accessing of the internal table instead of populating the header.

6) avoid Selects in the Loop.