characteristic length

[Former Member]

Hello Gurus,

I have a field whose length is 1000 char which has to be extracted from Sql table into BW. Could somebody suggest me a way of doing it. As far as I am concerned Characteristic data type can take only 60 char at the maximum. Pls help.

Thanks

jose

[Former Member]

Hi

Yes chars are limited to only 60 chars.

one option is to extract it to a table built on the DB not an ODS (built thru SE11), but then your reporting thru BW Query's is lost.

you can still report on it via Crystal or other tools.

Second option (quite ugly) is to split the taext to sub IO's and then use it in BW Query's.

Reg's

Edan

[former_member184494]

I even tried SAP's 'Expert' Panel at TechEd India and they did not have a clue as to the reason behind the 60 character limit...???

We had to use the second workaround for a 240 character limit , but then it gets uglier as we hit higher characteristic lengths.. I hate to think of handling blobs from SQL where the length can be a text field with upto 1GB in size.

Arun

[Former Member]

Hello Jose,

Please go through these threads

Hope it helps.

Regards,

Praveen