topic Re: problem in tables in Application Development and Automation Discussions

problem in tables

Former Member — Sun, 24 Jul 2005 11:59:00 GMT

hello

i want to know how to check if table is active or not(i mean if table have data or not)in code?

in SE11 i see the table declared but in SE16 the table is not active because there is no data

thanks

Re: problem in tables

athavanraja — Sun, 24 Jul 2005 12:20:51 GMT

in SE11 i see the table declared but in SE16

i guess you are comparing tables and structures?

Structure is a structure it does not hold data so you wont see them from se16.

check out the link for Data dictionary FAQ

http://www.sappoint.com/faq/faqabdic.pdf

Regards

Raja

Re: problem in tables

RichHeilman — Sun, 24 Jul 2005 15:47:54 GMT

If you want to know if there is data in a particular table programmically, you could just do a select against it.



Select Single * from t001 into xt001.
if sy-subrc  = 0.
write:/ 'Yep, there is data'.
else.
write:/ 'Nop, there is no data'.
endif.

Don't know if that select statement will pass a syntax check or not(no r/3 available right now), but you get the idea.

Regards,

Rich Heilman

Re: problem in tables

jayanthi_jayaraman — Mon, 25 Jul 2005 04:28:41 GMT

Hi,

I think you created table but not activated.Just check the status of the table in SE11 whether it is 'Active'.Sometimes if you copied the table the status will be New.You have to activate them.

If you want to see whether the table has data,you can see it in SE11 itself.Just go to table of contents and execute.

Re: problem in tables

Former Member — Mon, 25 Jul 2005 04:34:48 GMT

In se11, if u have created a structure, then see that whetehr u have referred all the reference table and field, if u click on the currencyfields tab if u see some blank lines in the edit mode. U have to fill those details.

When u try to activate it,it will give some error.

If the table is not active then it wont accept the table name while u define that in code.

Re: problem in tables

Former Member — Mon, 25 Jul 2005 05:08:18 GMT

Hi,

Please let us know the error message you r getting while u try to activate the table.

Regards,

Anjali

Re: problem in tables

Former Member — Mon, 25 Jul 2005 05:17:20 GMT

Hi,

Guess you've mixed up the terms..:-).

A table (or any workbench object in SAP , for that matter) when created has the status new. When you have saved it at least once, it has the status inactive. when you have activated it, the status is active.

Only those tables in SE11 that have the status active can be populated with data. But if a table is active, it doesn't necessarily mean that it has got some data. It may just be that nobody has updated this table. Or the entries that were in the table have been deleted.

Regards,

Anand Mandalika.