regarding table status

[Former Member]

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

[RichHeilman]

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

[Former Member]

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.

[Former Member]

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.