Hi,
I had appended a structure to STPO table and i needed to convert one Z column(of structure)'s data type from INT1 to INT2. I did that and activated structure. still the change had not appeared in STPO so activated STPO as well. on activating, it gave error that 'Alter table is not possible' and i need to adjust the database table STPO in SE14. i did that. when saw again in SE11, the table structure of STPO was there but it gave me the error that 'Table STPO does not exists in database' !! how could that happen?
table was adjusted for sure (and not deleted). how could i retrieve it again? I dont want the data but at least the table schema should be there to save entry from .
I tried doing 'create database' for STPO in SE14 but again it gave the error that the primary index STPO~0 already exists in database so SQL statement can not be executed?
please advise what can i do to retrieve STPO table back.
Thanks,
Binita