Unable to change anything in custom table

[former_member594288]

Hi,

I am facing one issue with custom table. In custom table when i try to change anything like increase length of the field or deleting existing field etc then when i activated it is giving below error. Please find the screenshot and let me know your suggestions. Thank you.

[FredericGirod]

This looks like to be not a custom table

[former_member594288]

It is a custom table.

[venkateswaran_k]

Please show the screenshot of SE11 of that table. Also mark the field which you want to change

a) increasing the field length or b) deleting the field

[former_member594288]

Before that i have done change in delivery maintenance, earlier it was not allowed now i maintained delivery maintenance allowed with restrictions after that i changed it to delivery maintenance allowed also but no luck. Please find table screenshot.

[venkateswaran_k]

Questions:

1. Is this kind of change previously allowed and it is not working for this table only?

2. Did you try the date data element using the standard date data element

3. What is the Primary key for this table

4. What is the database? Hana or anyother database?

[venkateswaran_k]

Based on your answer, If it is not allowing for any of the custom table, then you may have to raise the incident to SAP. There are some notes to be implemented I believe.

[former_member594288]

1. It was allowed previously

2. yes but not working

3. Some counter field (custom field)

4.Hana DB

I was working in sandbox for the same table.

[Sandra_Rossi]

I guess SLT creates automatically DB triggers.

You must delete the DB triggers before adjusting a table, and re-create them after.

I guess SLT provides an easy procedure, you should target your question with primary tag SAP Landscape Transformation.

But there are already some answers, and also SAP notes.

[former_member594288]

Added SLT team. Thanks

[raymond_giuseppi]

Did yoi already read KBA 2284776 - Table change not possible. There is a DB trigger on the table (it contains some references/links to SLT)

[former_member252769]

You have to stop the replication in SLT which will drop the triggers or if triggers are set manually then you have to delete them.

Once triggers are deleted, then you can change the table and activate the table.