cancel
Showing results for 
Search instead for 
Did you mean: 

Remove a table from HANA data provisioning

jrgen_lrwer
Discoverer
0 Kudos

Hello.

We had added several tables to our sid-by-side HANA with HANA studio.

Now we finally want to delete one table (e.g. LIKP) from the replication in SLT and HANA (data provisioning), because we no longer need that table.

What steps must be done in source system, SLT and/or HANA Studio to delete all depending objects of the table (e.g. LIKP) and/or eintries in other tables?

We found lot of objects (e.g Trigger, function modules, ddic objects (e.g. tables with name /1CADMC/nnnnnnnn).

Source system: ECC6; DMIS 2011_1_731 SP04 (upgrade to SP09 in november)

SLT: same DMIS as in ECC6

Where can we find any step-by-step documentation to remove a table from replication and delete all depending objects?

Best regards.

Jürgen.

Accepted Solutions (0)

Answers (2)

Answers (2)

jrgen_lrwer
Discoverer
0 Kudos

Thank you all.

As i read in the blog there no automaticly check tool exists

Then i have to check it manually.

Where can we find any Information about an error in HANA. We have often Problems with tables that are replicated into HANA. I only see in data provisioning "error". I cant find why this error occurs and what ist to do to fix the error.

In the log files there is no entire found.

Mofizur
Contributor
0 Kudos

Hi,

I believe you can find more information in the SLT system with Tcode LTRC/LTRS.

Thanks,

Mofizur

Former Member
0 Kudos

Hi Jurgen,

Easiest way is to 'stop replication' for the table (I am assuming that the SLT configuration will still be active for the tables that you need). The 'stop' will remove the triggers and logging tables from the source system and also from the SLT mass transfer ID...you can perform these steps from HANA Studio (if authorized) or from transaction LTRC in the SLT.

Then, in HANA Studio, find the table (if still there) in the relevant schema, right-click and 'delete' with the cascade option as that will remove the table, data and any associated objects.

Hope this helps.

Kris

Mofizur
Contributor
0 Kudos

Hi,

Please check below section in

1.) Consistency check and Clean-up functions

Thanks,

Mofizur