Skip to Content

Remove a table from HANA data provisioning

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 19, 2015 at 08:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 30, 2015 at 08:15 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded