topic Re: regarding table status in Application Development and Automation Discussions

regarding table status

Former Member — Fri, 02 Mar 2007 02:13:36 GMT

hi guys,

How to find table status is whether active or inactive.

I have TADIR table entries where i could not find whether this table is active or not.

Is there anyway to check this in from standard tables.

Thanks

Ambichan

Re: regarding table status

RichHeilman — Fri, 02 Mar 2007 02:43:31 GMT

You might want to check the table DD02L. If there is a single entry for the table, and the field AS4LOCAL is set to "A", then it is active. There could be more than one record, for example if it is inactive, there will probably two records, one with 'A' and one with 'N'. You should read the last record based on the AS4VERS. If there is one record, this value should be 0000, if there is an inactive version as well, this value will be 0001.

Regards,

RIch Heilman

Re: regarding table status

Former Member — Fri, 02 Mar 2007 06:14:10 GMT

Hi Prince,

To check the <b>Table status</b> DD02l. If you also want program status, there is one VIEW "D010SINF" which will be helpful to you. This view consists of <b>program status</b>, Authorization checks, locks, Program type...

and so many things.Have a glance.

Regards,

V.Raghavender.

Re: regarding table status

Former Member — Fri, 09 Mar 2007 09:47:20 GMT

Hi!

Table DD02L contains all SAP tables.

In table DD02L , there is a field called AS4LOCAL ,which tells the status(activated or not) of the table.

You can execute it and find the status of any table.

Regards,

Neha Bansal.