Changing an infoobject.

[henry_jones]

I'm looking for advice on the best way to change the length on 2 attributes of 0WBS_ELEMT. 0WBS_ELEMT itself is rather large. In the past, I changed the lengths and transported. It took an extremely long time. Here are my scenarios:

1) just change the lengths and transport. (this takes a long time)

2) remove the attributes from 0WBS_ELEMT, transport 0WBS_ELEMT, change the attribute lengths and add them back to 0WBS_ELEMT.

3) create a transformation and set the 2 attribute values to null, then change the lengths.

any thoughts?

[Former Member]

In order to change the length of any master data Infoobject, first you need to identify the data target where this field is referring to. If you have to first delete the data in those data targets.

goto tcode SLG1-- enter Object: RSDMD and Subobject: MD_DEL and User: ur userID and F8

In the next screen Expand node and dbl click 'Problem class additional information'

This will give u which ever objects using SIDs of this master data.

U should delete this SID according to that list.

Then U should delete particular data from DSO/Cubes. Once deletion is done, then you can delete your master data.

Once its done then you can change the length of infoobject.

[Former Member]

When you are increasing the length - there is no dependency - the SID tables get realigned automatically...

• I am not too sure about this one below *****

You cannot delete attributes from the infoobject without deleting master data - this is because the structure of the P , X and Y tables will change and since you are DELETING a field - you will have to drop master data - which means delete all transaction data and deleting SIDs

The reason why the transport takes so much time is because the P , X , Y tables all have to be converted and the SID tables have to be checked - which is why your transport takes so much time - even if you add new attributes - it is going to take a similar amount of time.

Another option which I think would be faster would be :

1. for the two attributes you want to change - make them display attributes and then transport

2. Change the length and transport

3. Make these attributes navigational

Edited by: Arun Varadarajan on Dec 11, 2011 8:03 PM