cancel
Showing results for 
Search instead for 
Did you mean: 

Texts more then 60 characters?

Former Member
0 Kudos

Hi friends,

we have in source system (ECC) a table, which includes some texts for every Profit Center for each month

001.2010 PRCTR1 Text1

002.2010 PRCTR1 Text2

001.2010 PRCTR2 Text3

002.2010 PRCTR2 Text4u2026

Text field (Text1, 2, 3u2026) can have approx. 100-120 characters.

They want to show those texts in BW reports according to Profit Center and Period.

But I donu2019t know how to define those fields in BW data model ?

If I define it as an Infoobject then they can have max 60 characters.

How would you define the data model in BW to show the text fields completely?

Cheers.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

An Article in BI expert explainas about Displaying Text Longer Than 60 Characters in Web Queries.

BW users often turn to BW-based Web queries to display document-level details. For example, vendors often access BW reports through the Web and need to view long text stored on purchase orders or delivery documents. However, length limitations on BW InfoObjects restrict how much data users can display in BW Web queries. You can display text greater than 60 characters in BW Web queries by enhancing the context menu of Web queries and using a Business Server Page (BSP) application in the back end.

SAP Web Application Server includes BSP, a page-based programming model with server-side scripting as well as server page technology for developing, designing, and implementing Web applications. Server-side scripting enables direct access to all elements in the application server (such as function modules, database tables, ABAP Objects, and remote function modules).

To display text greater than 60 characters in BW reports, you must enhance the context (right-click) menu on BW Web queries by modifying the Web template to call the BSP application. In turn, the BSP application calls a remote function module in R/3 to retrieve the text and present it in a pop-up window. You must set up a separate BSP application for each field (such as delivery number) for which you want to display the enhanced context menu. Then, all users see the new option in their context menu.

Helpfull Link of BSP

http://help.sap.com/saphelp_nw2004s/helpdata/en/e9/bb153aab4a0c0ee10000000a114084/frameset.htm

Thanks

Suganya

Former Member
0 Kudos

Hi thanks for your reply.

We have nw2004 in use.

I am not familiar with BSP. I want to learn how to use BSPs in WAD ?

Can you send some links how to paper or step by step documents about BSP Page in WAD ?

I want to see some simple scenarios with BSP in WAD.

I have no access for BI Experts.

Cheers.

Former Member
0 Kudos

hi

y dnt you load the data from ECC to BI and use it in report..

check the below blog:

/people/sap.user72/blog/2006/05/27/long-texts-in-sap-bw-modeling

u'll be able to load the data more than 60 and then use it in report...

Answers (1)

Answers (1)

MartinMaruskin
Active Contributor
0 Kudos

Check out following blog series:

/people/sap.user72/blog/2006/05/27/long-texts-in-sap-bw-modeling

/people/sap.user72/blog/2006/06/03/long-texts-in-sap-bw-modeling-150-follow-up

Former Member
0 Kudos

Hi,

thanks for your quick reply but, it explains how to do it with Bex Workbooks with VBA Scripts.

I need to show the report on web with WAD.

Do you have any idea, how to do it ?

Cheers.

Former Member
0 Kudos

Another question.

Can i solve it with using Documents.

Can i specify an existing Infoobject (Profit Center) as a document property ? After this will all related Infocubes and queries be affected ??

Or can i simply change an existing Infoobject as a document property. After that shold i make some adjustments in datamodell?

Thanks.