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

Loading error "Master data/Text of Characteristic ZMAT already deleted"

Hi,

I have some problem about SAP BW loading.

while loading I'm getting this error "Master data/Text of Characteristic ZMAT already deleted"

and loading is failing.

So when I try to loading again sometime loading is completed but sometime is failed with this error.

I try to find out root cause and I check table RSMASD there is ZMAT entry this table.

How do I remove the entry?

How can I fixed this problem ??

Now my SAP BW is 3.0 B and support package 26

Hope this helps...

Sumaru

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 14, 2008 at 03:14 AM

    Hi,

    As per you the root cause is the lock entry in RSMASD table.

    If at all deletion is the only solution then,please see if the below is useful for you

    steps to delete the entry.

    1.display the table contents.

    2.double click the record to be deleted.

    3.switch to classical debugging mode ->enter->enter

    4.you will see a variable CODE , change its value to DELE.

    5.click pencil icon and then save.

    6.come out of debugging mode and now u will be able to delete that record.

    Hope it helps

    Reward if useful

    Manish Sharma

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 14, 2008 at 03:24 AM

    Hi,

    Check table RSMASD or SM12 for an entry there.

    RSMASD should be blank normally.

    SAP Note Number: 936694, 946992 and 936694.

    Try

    master-datatext-of-characteristic-0material-alread

    master-datatext-of-characteristic-zxvy-already-del

    data-load-error-due-to-master-data-deletion

    Hope this helps.

    Thanks,

    JituK

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2008 at 11:47 AM

    Hi all,

    I can resovle this problem. Thank you very much.

    Sumaru.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I do it by Manish Sharma solution.

      Manish Sharma Solution is

      "As per you the root cause is the lock entry in RSMASD table.

      If at all deletion is the only solution then,please see if the below is useful for you

      steps to delete the entry.

      1.display the table contents.

      2.double click the record to be deleted.

      3.switch to classical debugging mode ->enter->enter

      4.you will see a variable CODE , change its value to DELE.

      5.click pencil icon and then save.

      6.come out of debugging mode and now u will be able to delete that record. "

      Hope it helps

      Sumaru

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.