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?

[henry_jones]

Thanks all. It was not a big deal after all. I just deleted the data for the attribute and increased the length. There were no issues.

Thanks!

[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_member184494]

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

[Former Member]

Hi Henry,

In BI,increasing the length of an infobject is possible without deletion of data only if the object is not a master data object.

In your case, you are trying to increase the length of the Master data info objects,it wouldn't be possible without deleting data in all data targets whereever the object is used. Reason being the connection with the SID's.You will also need to delete the master data with SID's and then change the length.

If at all still data exists in the SID tables goto se16 and check the SID table. You might have some entries there. Delete them manually.

Also increasing the length is only possible in case there is no conversion routine. So you can delete the conversion routine activate the object and then increase the length.

Let meknow if you need more info or have nay concerns.

Regards,

Bhagyarekha.

[former_member188080]

Hi,

Normally it depends on situation

1. If u are increasing normally there is no problem..

You can transport the objects into next system with data also. It will just give some warning

2.If u are reducing the length and try to send the object without deleting data all the transaction data it will fail for sure.

You can take a call based on what u are doing.You need to ask for downtime accordingly.

Thanks and regards

Kiran

[Former Member]

Hi Henry,

If the infoobjects are using conversion routine best thing is to delete the conversion routine adjust the length and then activate,

Then goto transaction RSMDEXITON and then put the conversion back on the object and activate conversion routine.

InfoObject Maintenance

Remove Alpha Conversion Setting

Change Object Size and activate in Background and transport the objects

Change Field Size in Transfer Structure

Change and activate it and transport it.

Re-Activate Alpha Conversion for InfoObject

See SAP Note 559524 to set up parallel processing for ALPHA conversion

Transaction RSMDEXITON - use Activate Conversion Routine

The below thread will be helpful,

Thanks,

Vinod

[Former Member]

the attributes are 2 infoobjects on wbs.. all you need to do is go to your sa1 and under infopbject find thenm , use rsd1 to change them the field length. if they are holding data then might not let you chnage it you will have to delete the data first.. you could try.. then just transport those infoobject. to see the chnages check yoru quality system . i dont think you will neeed to transport WBs as well as it alreacy contains those inobjects. when transporting do necessary objects only see if Wbs shows up..