12 Replies Latest reply: Jul 17, 2007 7:00 AM by shilpa dhawan RSS

ALV features in BSP

shilpa dhawan
Currently Being Moderated

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

  • Re: ALV features in BSP
    Tatvagna Shah
    Currently Being Moderated

    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.

  • Re: ALV features in BSP
    Jaideep Srinivasan
    Currently Being Moderated

    hi,

     

    these features are also supported in tableview...

     

    kindly check out the examples in sbspext_table

     

    thanks

    jaideep

     

    *reward points if useful..

  • Re: ALV features in BSP
    Tatvagna Shah
    Currently Being Moderated

    what happenned ?

  • Re: ALV features in BSP
    shilpa dhawan
    Currently Being Moderated

    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"

    • Re: ALV features in BSP
      Tatvagna Shah
      Currently Being Moderated

      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

      • Re: ALV features in BSP
        shilpa dhawan
        Currently Being Moderated

        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

        • Re: ALV features in BSP
          Tatvagna Shah
          Currently Being Moderated

          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.

          • Re: ALV features in BSP
            shilpa dhawan
            Currently Being Moderated

            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

            • Re: ALV features in BSP
              Tatvagna Shah
              Currently Being Moderated

              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.

            • Re: ALV features in BSP
              Durairaj Athavan Raja
              Currently Being Moderated

              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

  • Re: ALV features in BSP
    shilpa dhawan
    Currently Being Moderated

    Thanks Everyone and special thanks to Tatvagna.

Actions