Skip to Content
author's profile photo Former Member
Former Member

Fixed Rows/Columns in Web Interfaces

We are implementing web based BPS-applications for different customers integrating the BPS interfaces into SAP Enterprise Portal. One of the main problems when using web interfaces is that you're not able to fix leading colums/rows in a way that the user only scrolls through the data cells of a layout.

Does anyone know of a way to fix leading colums or rows in BPS-Web Interfaces (either using pure HTML or Excel web component)?

HTML: When using Web Interfaces I would suggest that you have to work with frames. Has anyone done this and can provide a code example?

Excel OWC: Excel-based layouts work well with fixed rows/colums in SAP GUI. But as far as I know the Excel web component doesn't support this feature.

Thorsten

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

14 Answers

  • Posted on Nov 12, 2005 at 01:24 AM

    Hello Thorsten,

    HTML layouts do not provide this functionality. The best you can do is use styles to format them so they fit on screen.

    Excel layout however can be set to fixed columns/rows. Make the change to the layout in BPS0. On the third screen of the layout builder, select "publish to web" (button above the layout).

    Regards

    Marc

    SAP NetWeaver RIG

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Marc Bernard

      Dear Marc / Dear All,

      Any improvement or updation on this requirement , as we require the same options now as we are not able to freeze the header as we do it in excel. This is creating lot of problem for the planners (BPS-Web)to identify the row/column they are into to do manual planning.

      Regards

      Jerry

      Edited by: jerry raj on Dec 19, 2011 9:24 AM

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2006 at 09:15 PM

    Hi Thorsten,

    You can use freeze panes in the web interface.

    You have to freeze panes (window - freeze pane) in the third screen of your planning layout in BPS0.

    The freeze pane will then be active in the web if you use the office web component.

    Thanks for your points if this helped you,

    Filip

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 20, 2006 at 01:29 PM

    It seems like the topic of fixed rows/colums is quite interesting for a lot of BPS-applications.

    We finaly came to the following solution:

    1. Modifying each web interface by using the freezepanes-method might work, but we wanted a flexible solution giving the user the opportunity to freeze whatever cell he likes.

    2. So we decided to modify the template BPS uses to create new business server pages from web interface builder (BSP "SEM_UPWB"). We added two buttons: the first one freezes the cell the user selected, the second one removes the freeze.

    3. Now whenever a new BSP is generated, the two buttons are added automaticaly.

    Here's the code we used for the modification:

    <img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = true"

    title="Zeilen/Spalten fixieren"

    class="bpsBtnIcn"

    src="../PUBLIC/BC/Icons/s_brdins.gif">

    <img onclick="javascript:layout_sheet.ActiveWindow.FreezePanes = false"

    title="Fixierung aufheben"

    class="bpsBtnIcn"

    src="../PUBLIC/BC/Icons/s_brdout.gif">

    <!-- Ende Modifikation -->

    Just insert the code into the Object "Layout2.htm" of BSP "SEM_UPWB" after line 492 ("...src="../PUBLIC/BC/Icons/s_f_ehlp.gif"><%endif. %>") and activate the BSP.

    If you have problems adding the modification, contact me. I can also supply a short word document (only in german) describing the steps.

    Regards

    Thorsten

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Thorsten,

      simply GREAT 😊

      That was exactlky what I was looking for.

      The next step would be have the possibility to de/activate the functionality.. .just in case some user 😉

      Great job.

      Best regards

      Yannick

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2006 at 08:13 PM

    Hi Thorsten

    Did you het this done based on HTML or Excel component? If you can send the detail information to sem_bps2000@yahoo.com, I would be veru much appreciated.

    Thanks,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2006 at 08:26 AM

    Hi JW,

    the described modification only works for web interfaces based on Microsoft Office Web Component (OWC). So you have to select Excel for all layouts in your web interface.

    Regards

    Thorsten

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2006 at 05:07 PM

    Dear all,

    as Mark mentioned I am working an a How to Paper for freezing pane (header and lead) which offers an almost footprintless solution - just include a style sheet section and one javascript section, that's all - no exit class etc.

    What to to?

    1. Insert a text component at the very beginning of the page and an other one at the very end (attribute html = true)

    2. Insert the content of file freezeLayoutStyles.txt into the first text component.

    3. Insert the content of file freezeLayoutScript.txt into the second text component.

    That should be really all !!!

    Prerequisites:

    - Internet Explorer

    - New Design as of Release BW3.5 (using the SAPBEx styles)

    - The front end PC should not be too old 😉

    - The text files are located at (for the next 100days):

    http://sapmats-de.sap-ag.de/download/download.cgi?id=KYWV2IXL9UWABTEI55GIPOF0ASQK7Z2FKBWN4URC5098ZU1NMC

    Have fun ...

    Best Regards, Olaf Fischer

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 23, 2006 at 07:17 PM

    Olaf, thank you very much for posting a solution. However, we tried it in our 3.5 BW-BPS system and could not get it to work. Our web layout does NOT use the Excel web component -- it is strictly HTML. After implementing your solution, all we see is a grey block where the layout should be. We are using IE 6.0. Any ideas what the problem might be? Anybody else with success using this solution?

    Thanks,

    Tom

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Olaf,

      your solution for fixing columns/rows works so far. But a big problem is performance. In your posting you mentioned to have a few ideas about that issue and to work on that. How far did you get already? I need a solution necessarily. If you haven´t a solution already you can give me your hints and I will try to improve performance by myself.

      Best regards,

      Alex

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2006 at 07:04 PM

    Hi all. I have implemented this and I have 2 issues.

    1) when i go to the layout, it appears and it looks like it should work. However my screen does not respond. I cannot scroll or click any other buttons.

    2) performance. It takes a very long time for my layout to appear. It is not a lot of data. Only 15 or 20 lines by 20 columns.

    M.

    Message was edited by: Michael Svolos

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 12, 2006 at 09:50 AM

    I am trying to make sense of all the conversation on this topic, but alas I am totally lost. I am not more of a functional consultant (do not know where to include all the HTML and JAVA that are proposed). I need to be able to give users this “freeze panes” functionality urgently on the web-input screens. If anyone can offer me the “idiots guide” to do this I’d be delighted.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2006 at 03:07 PM

    Dear Olaf,

    I would like to use your solution. Please send me the active link/ zip file.

    My email address is: g7kiran@gmail.com

    Thanks,

    Kiran

    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.