Skip to Content
author's profile photo Former Member
Former Member

Wan to delete data from table

hi experts,

I want to delete hierarchy data from table /HInfobject.deleting data from table leads to any inconsistencies. Could any provide the steps to delete data from /H table .

I'll assign points too

Regards

kumar

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2006 at 02:02 PM

    Simply delete all hierarchy of the IO; this will remove all entry from H table.

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thnaks Paolo,

      But it is not allowing me to delete the data from the IO. The message i'm getting in IO logs was to delete the data from the H Table. Can u tell me which T-code to use to delete the data from the Table. Give me some steps.

      Regards

      Kumar

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2006 at 02:11 PM

    Hi,

    If you delete the hierarchy data from the IO it'll automatically delete it from the table.

    Before doing that make sure to check where all the hierarchy is being used.

    Cheers,

    Kedar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thnaks Kedar,

      But it is not allowing me to delete the data from the IO. The message i'm getting IO logs was to delete the data from the H Table. Can u tell me which T-code to use to delete the data from the Table. Give me some steps.

      Regards

      Kumar

  • Posted on Oct 17, 2006 at 04:04 AM

    Hi:

    Use this as last option to manually delete from H-Table.

    GO to InfoObject change mode and click on Hierarchy Tab. Here, you will find the H-Table name. Copy it.

    Run transaction SE14. Give the table name.

    Execute.

    Inside, you will fing a Button called Delete Table.

    Good luck

    Ram C

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ram C

      Thanks 4 ur answer, I've deleted the data from H table. Few records are deleted successfully.Now it is asking to delete data from Ktable(hierarchy SID table) for the remaining few records. If i do this is there any issues will come up in the future.

      Please suggest me

      Regards

      kumar

  • Posted on Oct 18, 2006 at 02:20 PM

    Hi Kumar:

    The only issue that you might have is that if the Hierarchy is used in any queries in BW, those queries have to be re-created/changes as they will not work.

    Since you want to delete Hierarchy anyway, you still need to do that.

    So, if you want to delete, you can go ahead and do it.

    In case of any problems, you can load the hierarchy again, thake the hierarchy off the queries and then delete tables again.

    Good luck,

    Ram C.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.