Entering content frame

Object documentation Table Locate the document in its SAP Library structure

Definition

A Web item that obtains data from a query view to create a table for a Web application. Navigation links are incorporated with the table.

Use

The Web item This graphic is explained in the accompanying text Table displays the value of a query view in the Web application in the form of a table. The same list geometry that is used in the BEx Analyzer is supported. Characteristics and structures can be displayed in both the rows and the columns.

Structure

As well as its general attributes, the Web item Table has the following attributes:

Attributes

Description

Alternating styles for table rows (ALT_STYLES)

'X' = Yes, '  '  = No

In the rows, the formats SAPBEXstdData and SAPBEXstdDataOdd are used alternately to display numerical values. You can adjust them in the CSS file assigned to the template.

Note

Totals cells are removed from this display.

Only hierarchy navigation

(ONLY_HIERARCHY_NAVIGATION)

'X' = Yes, '  '  = No

Only allow hierarchy navigation

The context menu is hidden in this mode, and you can only expand and collapse from the list.

Suppress repetition texts

(SUPPRESS_REPETITION_TEXTS)

'X' = Yes, '  '  = No

Suppressing repetition texts

If you set this attribute to ‘ ‘, the cells in the table are not merged and the texts and keys are repeated.

If you do not specify a value for this attribute, the texts are suppressed.

Number of data rows displayed at one time (BLOCK_SIZE)

Specifying this attribute allows you to determine the number of data rows that are displayed after which an area for scrolling is inserted.

Note

If the value is set to 0, the complete table is displayed, regardless of the number of data rows.

The attribute is set to 100 by default.

Rows scrolled per step

(BLOCK_STEP_SIZE)

Default setting: “0”

This attribute allows you more flexibility in structuring the scrolling logic:

You are able to determine the number of data rows scrolled per step. The default setting “0” corresponds to 2/3 of the display rows.

The value entered corresponds to the number of rows scrolled through.

Example

If you enter the value “2”, two rows will be scrolled through.

If you want to scroll through all the displayed data rows, enter the same value as you entered for the attribute Number of data rows displayed at one time (BLOCK_SIZE).

Number of data columns displayed at one time (BLOCK_SIZE_COLUMNS)

Specifying this attribute allows you to determined the number of data columns that are displayed after which an area for scrolling is inserted.

Note

If the value is set to 0, the complete table is displayed, regardless of the number of data columns.

The attribute is set to 0 by default.

Columns scrolled per step

(BLOCK_STEP_SIZE_COLUMNS)

Default setting: “0”

This attribute allows you more flexibility in structuring the scrolling logic:

You are able to determine the number of data columns scrolled per step. The default setting “0” corresponds to 2/3 of the display columns.

The value entered corresponds to the number of columns scrolled through.

Example

If you enter the value “2”, two columns will be scrolled through.

If you want to scroll through all the displayed data rows, enter the same value as you entered for the attribute Number of data columns displayed at one time (BLOCK_SIZE_COLUMNS).

Table: Scrolling area top

(SHOW_PAGING_AREA_TOP)

'X' = Yes, '  '  = No

 

Display the scrolling area at the start of the table

The attribute is specified with default ' '.

Table: Scrolling area bottom

(SHOW_PAGING_AREA_BOTTOM)

'X' = Yes, '  '  = No

Display the scrolling area at the end of the table

The attribute is set to ‘X’ by default.

Display column headers (SHOW_COLUMN_HEADER)

'X' = Yes, '  '  = No

Display the labels above the data

The attribute is set to ‘X’ by default.

Display column headers SHOW_ROW_HEADER)

'X' = Yes, '  '  = No

Display the labels to the left of the data

The attribute is set to ‘X’ by default.

Display data cells (SHOW_DATA_CELLS)

'X' = Yes, '  '  = No

The data cells are shown by default. That is, the attribute is set to ‘X’ by default.

Affected data provider

(TARGET_DATA_PROVIDER)

List of data providers to which all table commands are sent.

Display data from value row (DATA_ROW_FROM)

Data row after which data is displayed

The attribute is set to 1 by default.

Display data to value row (0=to the end)

(DATA_ROW_TO)

Data row to which data is displayed

The attribute is set to 0 by default. If the value is 0, the system tries to display all of the rows. If there are too many, a scrolling area is inserted. If the value is not 0, data is displayed up to the specified row and there is no scrolling area.

Display data from value column (DATA_COLUMN_FROM)

Data column after which the data is displayed

The attribute is set to 1 by default.

Display data to value column (0=to the end)

(DATA_COLUMN_TO)

Data column to which data is displayed

The attribute is set to 0 by default. If the value is 0, the system tries to display all of the columns. If there are too many, a scrolling area is inserted. If the value is not 0, data is displayed up to the specified column and there is no scrolling area.

Attributes that cannot be set in the Web Application Designer:

MODIFY_CLASS

ABAP class that changes the table contents

By using the Web design API for tables, you can adjust the contents of the table cells individually.

Also see:

Web Design API for Tables

Example

Display the table with a maximum of 5 visible data columns and 10 visible data rows. Start at row 30 and show a scrolling area above and below the values

<object>

      <param name=’OWNER’ value=’SAP_BW’>

      <param name=’CMD’ value=’GET_ITEM’>
      <param name='ITEM' value='Table'>
      <param name='ITEM_CLASS' value='CL_RSR_WWW_ITEM_GRID'>
      <param name='DATA_PROVIDER' value='View1 >
      <param name='DATA_ROW_FROM' value='30'>
      <param name='SHOW_PAGING_AREA_TOP' value='X'>
      <param name='SHOW_PAGING_AREA_BOTTOM' value='X'>
      <param name='BLOCK_SIZE' value='10'>
      <param name='BLOCK_SIZE_COLUMNS' value='5'>

      ITEM :Table

</object>

Display only the 3 data rows without headers

<object>

      <param name=’OWNER’ value=’SAP_BW’>
      <param name=’CMD’ value=’GET_ITEM’>
      <param name='ITEM' value='Table'>
      <param name='ITEM_ID' value='MYTABLE'>
      <param name='DATA_PROVIDER' value='View1 >
      <param name='DATA_ROW_FROM' value='3'>
      <param name='DATA_ROW_TO' value='3'>
      <param name='SHOW_COLUMN_HEADER' value=' '>

      ITEM :Table

</object>

 

You can find more information on using the Table Web item and its functionality under Structure linkContext Menu Functions and Structure linkTable.

 

Leaving content frame