topic Re: enpty table in Application Development and Automation Discussions

enpty table

Former Member — Thu, 26 Jun 2008 11:33:42 GMT

hi experts

how do i check if a table is empty

thanks

amit

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:34:17 GMT

if itab is initial

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:35:43 GMT

you can use IS INITIAL command in an if loop.

this will help.

reward if useful.

Regards

Sumit Agarwal

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:36:02 GMT

hi,

do this way ..


if itab[] is initial.

endif.

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:37:25 GMT

There are 2 alternatives:

1) After the select query check SY-SUBRC.

2)Use:

if itab[] is initial.

endif.

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:39:21 GMT

hi,

if you check an internal table (Say, itab) with header line, then

if itab[] is initial.

endif.

if itab is without header line, then use

if itab is initial.

endif.

it will defenitely work.

Award if found helpful.

Anirban Bhattacharjee

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:39:23 GMT

Hi,

Go to SE11.

Put The table name In Database 'Table Field'

click 'Diaplay' Or 'Change' Pushbutton Below.

The Press CtrlshiftF10 A screen is Displayed.

Noe In The Application toolber Click On 'Number Of Entries'

Button If Entry 0 Means Table is Empty.

Let Me know if any Confusion.

Re: enpty table

Former Member — Thu, 26 Jun 2008 11:39:47 GMT

Hi,

Fire a select query on that table and take the values in an internal table. If the internal table is empty, ur table is empty.

The command is

if itab[] is initial.

endif.

Nayan