Skip to Content
avatar image
Former Member

Changing the TYPE of Info Object from NUMC top CHAR

Hello All,

There issue with an Infoobject . It was set to NUMC.

I wanted to change to CHAR.

It is an attribute of 0WBS_ELEMT, so BI won't let me delete the master data of that Object until all the values of 0WBS_ELEMT that use that attribute have been deleted.

I can't delete the master data for 0WBS_ELEMT until all Infoproviders that use that master data have been cleared.

We can think of deleting data in Devlopment system. But once we move it in QA or production system it will be difficult to do it.

Is whether there's an alternative way to make the change without deleting all master data, or whether we can resolve this issue without changing that particular object.

Points will be assigned.

Thanks & Regards,

Vaishali.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 03, 2008 at 01:24 PM

    Hello Siggi,

    Help full answere

    Clarify 2 points:

    1. While deleteing master data of WBS_ELMNT it wont raise error that this master data is used in below info providers.

    You will need to delete the transaction data. In any system DEV or QA.

    2. Only changes to WBS_ELMNT will solve the purpose. See after doing the changes we will transport it to QA and will reload it.

    Then we do not have to delete the data from all the info providers in QA. It will work susseccfully.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      there you go. No deletion of data. The old object will stay in the attributes with a description enhanced by (obsolete). The new object will be added at the end of the attributes (not somewhere in between). So the transport will go thru. After the changes to the transfer rules and a new initial load of the master data the new object will be populated.

      Siggi

  • avatar image
    Former Member
    Sep 03, 2008 at 01:03 PM

    Hi,

    I think you need to create a new object of type char and add it to the attributes of 0wbs_elemt. Change the transfer rules and change the mapping from the old field to the new field. Change the old fields text to description + (obsolete). Reload the data 0wbs_elemt completely.

    regards

    Siggi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 01:13 PM

    But one of the Info Provider has Legacy data.

    It wont allow me to delete teh master data of 0WBS_ELEMENt as it is used in 25 info providers. We will require to delete the data from all the 25 info providers. one of the infoprovider has Legacy data.

    If we delete the data then it would be really difficult stuff for that legacy data.

    Any other option

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      if you do what I suggested, there is no need to delete anything. With the reload you do nothing else then an update of the data and basically fill the new attribute.

      regards

      Siggi

  • avatar image
    Former Member
    Sep 03, 2008 at 01:13 PM

    creating another attribute is the better way to go rather than delete data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 09:49 AM

    Hi Siggi,

    Thank you very much, my issue is resolved.

    Add comment
    10|10000 characters needed characters exceeded