topic Re: Free itab functionality? in Application Development and Automation Discussions

Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 11:43:57 GMT

Hi....

In which situation , we hav go for FREE syntax..?

Where this statement mandatory to use...?

What this statemnet exatly do..?

> free itab.

( Expecting practical answer, no links or documentaion )

Thanks,

Naveen.I

Re: Free itab functionality?

bpawanchand — Mon, 04 Aug 2008 11:45:22 GMT

Free is used to delete the enitire internal table with its data and it memory is given back to SAP or OS.

You can use FREE to initialize an internal table and release its memory space without first using the REFRESH or CLEAR statement. Like REFRESH, FREE works on the table body, not on the table work area. After a FREE statement, you can address the internal table again. It still occupies the amount of memory required for its header (currently 256 bytes). When you refill the table, the system has to allocate new memory space to the lines.

DATA: BEGIN OF LINE,

COL1,

COL2,

END OF LINE.

DATA ITAB LIKE TABLE OF LINE.

LINE-COL1 = 'A'. LINE-COL2 = 'B'.

APPEND LINE TO ITAB.

REFRESH ITAB.

IF ITAB IS INITIAL.

WRITE 'ITAB is empty'.

FREE ITAB.

ENDIF.

Regards

Pavan

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 11:46:48 GMT

free itab.

will release the memory which is allocated to itab.

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 11:50:00 GMT

<content removed by moderator as it was just a copy and paste without giving a source>

With luck,

Pritam.

Edited by: Mike Pokraka on Aug 4, 2008 2:43 PM

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 11:50:12 GMT

Hi,

with FREE statement we free the memory allocated by an internal table

Re: Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 11:50:21 GMT

Hi....Vijay...

So if i write

> free itab

before the select statement, My select statement should not work... isn't it?

Thanks,

Naveen Inuganti

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 11:51:19 GMT

hiii

it will relese memory occupied by that internal table..and will make it available for another use.

select statement will not work in this case..because you need to define internal table with that structure before using select query and after using FREE statement.

regards

twinkal

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 11:59:25 GMT

Press F1 on Key word and use SAP help.dont forget we are paying high buks them.

may be sometime we mis concept but SAP never

Re: Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 12:01:06 GMT

Hi.. Twinkal....

But Iam getting output list for this code...

>data: itab like ztable occurs 0 with header line.

>free itab.

>select * from ztable into corresponding FIELDS OF TABLE itab.

>loop at itab.

> write:/ itab-zfield.

>endloop.

Please let me know what is the purpose of free itab.. and if it will deallocates memory of itab.. why my above code giving output...

Also... where this FREE itab statement is mandatory.....

Hi Amit...

It is some what confusing for me every time.... Thats why i posted this question....i tried with F1....

i.e...,

> The FREE statement has the same effect as the CLEAR

> ....

> FREE has the same effect as the REFRESH statement....

Sorry to say this its confusing for me.. Amit...

And thank you very much for your attention...

Plz clear my doubt....

Thanks,

Naveen Inuagti

Re: Free itab functionality?

Former Member — Mon, 04 Aug 2008 12:04:52 GMT

Hi,

free itab.

means it will free the memory space created for the variable.

Re: Free itab functionality?

former_member182354 — Mon, 04 Aug 2008 12:06:56 GMT

Hi,

FREE statement is very usefull when you want to de allocate the momory that has been used by variable or Internal tables.

Raghav

Re: Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 12:10:40 GMT

Hi Ragavedhar and Manjari...

Thanks for ur attention...

Plz check my second reply for this thread...

Thanks,

Naveen Inuganti.

Re: Free itab functionality?

bpawanchand — Mon, 04 Aug 2008 12:16:15 GMT

data: itab like table occurs 0 with header line.

free itab.

*select * from ztable into corresponding FIELDS OF TABLE itab.*

loop at itab.

write:/ itab-zfield.

endloop.

What is confusing you see Internal table is Dynamic I mean

check this statement

It still occupies the amount of memory required for its header (currently 256 bytes). When you refill the table, the system has to allocate new memory space to the lines.

that means when in the select query as soon as you are trying to fill the itab then dynamically again the memory is assigned to it

The FREE statement has the same effect as the CLEAR

....

FREE has the same effect as the REFRESH statement....

this means that apart from INITIALIZING the internal table to its default values it will even de-allocates the memory.

And more over REFRESH is applied to only to teh body of teh internal table not to the header line.

Regards

Pavan

Re: Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 12:32:41 GMT

Hi.... Pavan....

So If i Write free itab statement it will deallocates memory in application server...

again that memory will allocate dynamically with the select statement...

So...

Better to use Free itab syntax.. at the end of the all reports (after displaying iatb with write statement or somthing) to reduce the allocated memory area for internal tables in the application server...

Is n't it?

Thanks,

Naveen Inuganti.

Re: Free itab functionality?

weltspion — Mon, 04 Aug 2008 12:34:48 GMT

table t with header line:

clear t deletes the header line

refresh t deletes the table content (initial value remains)

clear t[] deletes the table content (modern version of refresh)

free t deletes both (initial value remains)

table t without header line:

clear t[] deletes the table content (initial value remains)

refresh t same result as before

free t same result as before

free releases some more ressources, which I don't know exactly.

Re: Free itab functionality?

bpawanchand — Mon, 04 Aug 2008 12:37:51 GMT

To make you correct it is not application server it is ABAP memory as soon you write FREE and more over see to be more precise FREE is used if at all you come across a situation where you have to read the data from a table based on two different conditions so first time you will read teh data and then you FREE the memory for Performance issues and again you read the data into internal table based on the second condition.

Regards

pavan

Re: Free itab functionality?

naveen_inuganti2 — Mon, 04 Aug 2008 12:52:38 GMT

Ok pavan thank you very much...

Naveen Inuganti.