Regarding *CLEAR keyword*

[Former Member]

Hi experts,

While going thru a print program I came accross a statement

Clear : vbup,

vbrk,

adrc,......

As far as I know clear is used for internal tables , but here it is used on database tables. So can we use clear on database tables also ? If so what will that clear statement do ?

[Former Member]

Hi experts,

While going thru a print program I came accross a statement

Clear : vbup,

vbrk,

adrc,......

As far as I know clear is used for internal tables , but here it is used on database tables. So can we use clear on database tables also ? If so what will that clear statement do ?

[Former Member]

I dont think u can clear db tables like that

regards

vivek

[Former Member]

Hi Kusuma,

clear vbak.

this statement clears the contents of vbak work area.

tables: vbak.

select single *

from vbak

into vbak

where vbeln = '121'.

for this statement vbak acts as work area and clear vbak means it will clear the work area.

kiran

[Former Member]

Hi,

clear statement clears only the work area.

it does not clear the body of the table/internal table.

Thanks & Regards'

sudheer

[Former Member]

Hi Kusuma,

As you know , we can declare work area using TABLES keword.

TABLES: vbup.

To clear such work area, we write

CLEAR vbup.

[Former Member]

Hello KIran,

So u mean clear here is used on database tables directly ?

[Former Member]

no

it will clear work area only

[mohammedahasanullah_mulla]

Hi Kusuma,

Whenever you declare using statement Tables : vbap,vbak. A workarea gets created during the load of the program.You can use this as the workarea in your program.

Thanks,

Ahsan

[Former Member]

Hi,

When you declare something like this:

Tables: vbap.

An internal table 'Vbap' is created with a header line.

If you use...

clear: vbap.

The header line of the internal table is cleared.

Regards.

[Former Member]

ok got it ... thanq for ur replies.

[Former Member]

Hi,

With the clear statement u can clear the work area of the internal table.

clear VBAK.

this statement will clear the header of the table VBAK. so that u can use the header in this case u need not to define an interrnal table of type VBAK.

Thanks & Regards

Ashu Singh