ALV features in BSP

[Former Member]

Hi all,

Can we have ALV features in BSP table views?

My Requirement is that i am using table-views in my BSP pages Can i have features like sorting, re-sizing - that is, the common functionality usually available in SAP for ALV displays.

Thanks in Advance

Regards

Shilpa Dhawan

[jaideeps · Accepted solution]

hi,

these features are also supported in tableview...

kindly check out the examples in sbspext_table

thanks

jaideep

*reward points if useful..

[Former Member]

Thanks Everyone and special thanks to Tatvagna.

[Former Member]

hi Tatvagna,

I have applied this code as suggested by you:-

but i got some funnel shape above the table row data what is this mean?

<htmlb:tableView id = "tab_list"

design ="ALTERNATING"

table = "<%= i_list %>"

footerVisible = "TRUE"

columnWrapping = "TRUE"

columnHeaderVisible = "TRUE"

width = "100%"

sort = "SERVER"

filter = "SERVER"

[Former Member]

Hi Shilpa...

If you notice, there will be a blank row between the row headers and the first row....for each column....

This is the filter for each row....

If the data type is numeric then the operations like >, <, >= , <= etc will work.... just put something and hit enter or click on the funnel....

Also if the data type is character, then functions like A* or *A etc will work....

Also for each column headers, there will be two arrows for ascending and descending sorting, but this will be visible only if you don't use iterator...

Hope this helps.

<b><i>Do reward each useful answer..!</i></b>

Thanks,

Tatvagna.

Message was edited by:

Tatvagna Shah

[Former Member]

Hi Tatvagna,

I have got the funnel row and its working fine.

But i am not getting the arrows in the column headers and i am not using iterator.

Thanks

Shilpa Dhawan

[Former Member]

Hi shilpa,

If you've declared the attribute sort of the tableView as

<htmlb:tableView id="TV1"
....
sort = "SERVER"
....
/>

Then this should work properly.....I donno why it is not coming...

Are you declaring tableViewColumns or columndefinitions....

try and post your code here and let's see how it works...

Thanks,

Tatvagna.

[Former Member]

Hi Tatvagna,

When i place the cursor on the column header hotspot (indexed finger appears but there are no arrows)

I have posted the code here.

<htmlb:tableView id = "tab_list"

table = "<%= i_list %>"

design = "ALTERNATING"

footerVisible = "TRUE"

selectionMode = "MULTISELECT"

columnWrapping = "True"

columnHeaderVisible = "TRUE"

sort = "SERVER"

filter = "SERVER"

width = "100%"

onRowSelection = "onInputProcessing()"

emptyTableText = "No data available"

visibleRowCount = "10"

keyColumn = "completekey" >

<htmlb:tableViewColumns>

<htmlb:tableViewColumn columnName = "userid"

horizontalAlignment = "Center"

title = "User Id" >

</htmlb:tableViewColumn>

<htmlb:tableViewColumn columnName = "role"

horizontalAlignment = "Center"

title = "Role" >

</htmlb:tableViewColumn>

<htmlb:tableViewColumn columnName = "site"

horizontalAlignment = "Center"

title = "SLA Partner" >

</htmlb:tableViewColumn>

<htmlb:tableViewColumn columnName = "firstname"

horizontalAlignment = "Center"

title = "First Name" >

</htmlb:tableViewColumn>

<htmlb:tableViewColumn columnName = "lastname"

horizontalAlignment = "Center"

title = "Last Name" >

thanks and regards

Shilpa

[Former Member]

Hi Shilpa,

Try using the sort attribute of the tableViewColumn....

eg....

<htmlb:tableView id = "tab_list"
      table          = "<%= i_list %>"
      design         = "ALTERNATING"
      footerVisible  = "TRUE"
      selectionMode  = "MULTISELECT"
      columnWrapping = "True"
      columnHeaderVisible = "TRUE"
      sort            = "SERVER"
      filter          = "SERVER"
      width           = "100%"
      onRowSelection  = "onInputProcessing()"
      emptyTableText  = "No data available"
      visibleRowCount = "10"
      keyColumn       = "completekey" >
  <htmlb:tableViewColumns>
     <htmlb:tableViewColumn columnName = "userid"
     horizontalAlignment = "Center"
     sort = "TRUE"
     title = "User Id" >
</htmlb:tableViewColumn>

Hope this helps.

<b><i>Do reward each useful answer..!</i></b>

Thanks,

Tatvagna.

[athavanraja]

like ALV layout you can also have saved view (subset of all available columns) different layouts .

check out this weblog for details

/people/ulli.hoffmann2/blog/2004/10/28/personalize-my-bsp-tableview

[Former Member]

Hi Shilpa,

If your issue is resolved, Please Reply/Reward/Close this thread.

Thanks,

Tatvagna.

[Former Member]

what happenned ?

[Former Member]

Hi Shilpa,

For sorting you can use the sort attribute of the tableView, and for filtering, user filter atttribute

              <htmlb:tableView id                = "TV1"
                               table             = "<%= gt_tview %>"
......
                               sort        = "SERVER"
                               filter       = "SERVER"
......
                               selectionMode     = "NONE"  />

You cannot do re-sizing on the fly..., but I beleive, BSP is more for the purpose of getting input data from user...!!

Which other functions of the ALV report are you looking for ??

Hope this helps.

<b><i>Do reward each useful answer..!</i></b>

Thanks,

Tatvagna.