Long Text in SAP BW

[former_member260745]

Hi,

in SAP: Texts are stored as follows. In SAP there is a query where user enter the notes and when it store in a table, it stores I think around 72 characters on each row and extra CHAR moved to next row with new Rec Num (increase depends on length of Char).

Item Num	Rec Num	Note	Created on
1	1	This item number is related to something.......	6/12/2015
1	2	that is not for user .............................	6/12/2015
1	3	but for someone else.....	6/12/2015

In BW 7.3: I would like to combine all 3 rows into one as shown below with 3 columns only

Item Num	Note	Created on
1	This item is related to something that is not for user but for someone else........(Over 250 Char)	6/12/2015

Thanks

AKA

[sander_vanwilligen]

Hi,

The long text in release 7.3 is according to me still 60 characters maximum. In release 7.4 there are some changes in this area. Characteristic values can now be 250 characters. There is also an extra long text and even XXL attributes.

Best regards,

Sander

[former_member260745]

http://scn.sap.com/community/data-warehousing/bw/blog/2006/05/27/long-texts-in-sap-bw-modeling

I read about 7.4 but my system is 7.3 and no plan to go for 7.4 at this time.

I went through this link but was not able to figure out. Any simplify solutions?

Thanks

Arjun

[sander_vanwilligen]

Hi Arjun,

Long texts prior to release 7.4 require such solutions as described in document . It is not a simple solution but an approach that facilitates the shortcoming of the 60 characters' limitation of standard SAP BW.

Best regards,

Sander