topic Append Structure in Application Development and Automation Discussions

Append Structure

Former Member — Thu, 10 Nov 2005 06:34:19 GMT

Hi All,

I m facing a problem while deleting an existing field in append structure. Detail description is as below.

I have a table for which i created an append structure with three fields. Now requirement changed and instead of three they require only two fields. So i need to delete the third field from append structure.

I tried to delete it from structure, it get deleted also but while activation it gives me warning messages and it gets partially activated.

I checked with original table in which i appended the structure. The third field is still there eventhough i deleted from append structure.

After that i tried with se14 and tried to adjust the table also i m facing the same problem.

So my question is "To make it activated weather i need to delete the entries of table" or "Shall i directly adjust the table"

If u have any other idea plz let me know.

its very urgent.

Thanks in advance,

Sagar

Re: Append Structure

Former Member — Thu, 10 Nov 2005 06:38:44 GMT

Sagar,

Why don't you take a look at the activation log, which should explain you clearly why the activation failed. Most probably this strucutre might have some dependencies.

Regards,

Ravi

Re: Append Structure

Former Member — Thu, 10 Nov 2005 06:39:48 GMT

Sagar,

Firstly check with the Basis/DBA if you are authorized to adjust the table. In such cases as you mentioned, you have to adjust the table (Delete and recreate with adjusted data). Activate the structure and then activate the table. Check the Activation log to ensure the table gets recreated correctly on the database. Hence, the need to work with the Basis/DBA Team.

Hope this helps.

Thanks,

Chaps.

Re: Append Structure

Former Member — Thu, 10 Nov 2005 06:40:30 GMT

Sagar,

Why don't you take a look at the activation log, which should explain you clearly why the activation failed. Most probably this strucutre might have some dependencies.

Regards,

Ravi

Note : Award points for the posts that help you.

Re: Append Structure

Former Member — Thu, 10 Nov 2005 06:50:13 GMT

Hi friends,

Thanks for yr quick reply.

I checked the activation log. It says only that 'Table cannot be altered, Inconsistency between database objects'. I have rights to do the things.

Again explaining my requirement.

I dont want to delete the data from table.

In SE14 what is to be done. Activate and Adjust with 'Keep data'(Not solving the purpose) or 'Delete data'(i dont want to do). Or is there any other way to solve the problem.

Thanks,

Sagar Vadher

Re: Append Structure

Former Member — Thu, 10 Nov 2005 07:31:03 GMT

Hi..

TABLE AAAA

Original Field A1,A2,A3

Append Field B1,B2,B3

will be change

TABLE AAAA

Original Field A1,A2,A3

Append Field B1,B2

Data

-Before A1, A2, A3, B1, B2, B3

- 1 11 11 B B B

- 2 12 12 B C

- 3 13 13 C D

After <Activate and Adjust with 'Keep data'>

-After A1, A2, A3, B1, B2

- 1 11 11 B B

- 2 12 12 B C

- 3 13 13 C D

Good Luck.

Regards MSLee.

Message was edited by: Min Seob Lee