To Increase the info object length upto 255

[Zumba]

Hi Gurus,

I have text field length 240 which is custom datasource field i have to bring data across BW but standard info object permits 60 char only . so please guide how to build this infoobject with length 255.

Thank you.

Regards,
Zumba

[Golfi]

Hi Zumba,

Is this requirement for reporting or for data storage...
the solution varies depending on what you want to do with the data. If you
want to report on it , create multiple IOs of 60 characters length and store
the split values , otherwise , go to the text tables and change the length
of the text field and store what you want to , but if you change the length
of the text fields , it will still not show up in the report with the
original length but only for 60 characters.

There is another way. Create an URL and store the data in the URL. Store
the URL in the InfoObject. When the user click on the URL, the data will
be displayed in a new e-browser.

Another option if you say want to store some free text for a sales order header as well as reporting on sales order information=2E

To do this create an additional ODS (or cube) which has a key containing sales order number and line item and in the data the text you want to store split up into 60 char chunks=2E You can then create a multicube to bring the original sales order information together with the new text ods=2E

It requires writing a datasource to read the text and split it into 60 char chunks and to spl it words at every 60 char boundary=2E

Regards,
Golfi

[Zumba]

Hi Golfi, thanks for your repply.

How can i split the values i want to store in a DSO so i created 2 text fields with 60 length? Please tell me the the process how split the data and load it to these text fields.

Regards,
Zumba

[Golfi]

Ok,

so you can do it at extraction level itself.

i.e. append teh structure of you datasource with 6 fileds say Field1, Field2....Field6

Now say you have long text to read, so there is a function module to called READ_TEXT (search for how to use READ_TEXT )
then split the value of output into Field1, Field2...Field6
say you got temp (255)
Field1 = temp+0(60) " it will store initial 60 char
Field2 = temp+60(60)
Field3 = temp+120(60)
Field4 = temp+180(60)
and so on,

Similarly create infoobjects for Field1, Field2....Field6 each with char 60.
And map the fields in DSO.

Regards,
Golfi