Changing the TYPE of Info Object from NUMC top CHAR

[Former Member]

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.

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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

[Former Member]

Hi Siggi,

Thank you very much, my issue is resolved.

[Former Member]

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

[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

[Former Member]

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

[Former Member]

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