Skip to Content

Changing an infoobject.

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?

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2011 at 06:52 PM

    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..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2011 at 09:37 AM

    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,

    Change length of Info object

    Thanks,

    Vinod

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2011 at 05:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2011 at 03:23 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2011 at 06:50 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

    • Posted on Dec 12, 2011 at 11:48 AM

      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!

      Add a comment
      10|10000 characters needed characters exceeded

    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.