Modify BW-BPS Web Interfaces with JavaScript to Include Fixed and Scrolling Columns

  • by James Koefelda, Senior Technical Consultant
  • Sheldon Edelstein, Director of Business Development, SAP Platform Solution Group
  • Olaf Fischer, Regional Implementation Group (RIG) Specialist, SAP America
  • April 1, 2007
Improve your scrolling abilities with JavaScript enhancements to Web interfaces. See the step-by-step process for preparing the Web interface and learn where to add the appropriate code.
Key Concept

The standard Business Planning and Simulation (BPS) interface toolset allows the insertion of JavaScript-based commands directly into the Web interface for customization. Existing BPS Web interface customization tools do not provide specific formatting capabilities for overall presentation. In the case of layouts presenting large numbers of columns and rows, the standard presentation does not allow certain columns or rows of a layout to be fixed (or “frozen”) and other columns or rows to scroll. The incorporation of JavaScript commands into the BPS Web interface allows you to customize the Web presentation to include enhanced scrolling capability.

SAP BW-Business Planning and Simulation (BPS) provides tools via transaction BPS_WB that allow you to customize BPS planning applications that you want to present to the end user via a Web session. SAP provides standard Web interface development tools such as function buttons, tab strips, and containers for specific objects. However, the standard solution does not provide a number of custom effects. You can achieve some of these effects by using JavaScript-based commands to enhance your scrolling abilities.

We’ll present a brief example to explain different scrolling capabilities and limitations and then show you the three phases of work you need to undertake to implement the capabilities you want to have. We’ll also show you the logic of the scrolling solution.

We have provided JavaScript commands in the code available at the Downloads section of You can easily incorporate these commands into most Web interfaces during the Web interface configuration. The use of this modification code technique is applicable to all BW-BPS Web Interface Builder functionality found within BW-BPS 3.5 through BW-BPS 6.0.

James Koefelda

James Koefelda is a senior technical consultant at SAP America, Inc. In his 10 years with SAP, he has focused primarily on enhancing SAP software using Internet technologies and the ABAP toolset. For several years, James has specialized in SAP NetWeaver Portal. In his current role as a portal technical lead, he is responsible for managing the technical aspects of large-scale portal implementations.

See more by this author

Sheldon Edelstein

Sheldon Edelstein is a director within the SAP Platform Solutions Group specializing in SAP HANA, SAP HANA Accelerators, SAP Business Warehouse (BW), and SAP Business Planning and Consolidation (BPC). He has over 10 years of experience at SAP and currently focuses on business development opportunities across a wide array of industries and product solutions. Formerly an SAP Platinum Consultant and SAP RIG –Regional Implementation Group—Specialist, Sheldon has either directly implemented or provided architectural guidance for numerous large-scale projects. Currently, his primary area of focus is HANA, but previously he specialized in BW-IP (Integrated Planning), BW-BPS (Business Planning and Simulation), and SAP BPC. Sheldon is an active presenter at numerous events, a contributor to the SAP Customer Network (SCN), writes blogs on a variety of SAP topics, and is an author of many guides on SAP Service Marketplace for use by the extended SAP community.

See more by this author

Olaf Fischer

Olaf Fischer is a Regional Implementation Group (RIG) specialist in SAP NetWeaver BI and Business Planning and Simulation (BW-BPS). He has more than five years of experience in functions for SAP Business Information Warehouse (BW). Olaf has strong technical skills in cross- module application integration, custom developments (ABAP Workbench, WebDynpro), Composite Application Framework (CAF) Guided Procedure and BPS performance tuning.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.