How to skip some fields of Internal Table for Display In Bsp Page

[Former Member]

Hi,

I would like to skip some of fields(Status,desc1, intcomms) of My ITAB, for not displaying to BSP Page. The code I wrote as follows.

  DATA: itabtype  type standard table of ZBH_QUEUE_UPDATE initial size 0.

SELECT * FROM ZBH_QUEUE_UPDATE
   INTO CORRESPONDING FIELDS OF TABLE itab
    UP TO 25 ROWS.

   SKIP.
   SELECT  STATUS DESC1 INTCOMS
   INTO CORRESPONDING FIELDS OF TABLE itab
   UP TO 25 ROWS FROM ZBH_QUEUE_UPDATE.

   FREE ITAB.

 vSize                = '7'.
 vIndex_prev_disabled = 'TRUE'.
 vIndex_next_disabled = 'FALSE'.

.

The BSP Page is not skipping the fields, I mentioned above.But instead it is displaying all fields.

I look forward your suggestions in this regard.

Regards

CSM REDDY

[Former Member · Accepted solution]

hi,

you have not provided the code of flow logic.

if you are displaying using tableview then you can remove the columns by using columnview tag inside tableview.

the columnname attrib of columnname takes the name of column

tableview disply only those columns which are included in colunmname.

you have to specify no of columnnae tag for every column

regards

[shiva_suvarna]

Hi mallikarjun,

if you are displaying by using <htmlb:tableview> then you may fill the columnDefinitions attrbiute using internal table of type 'TABLEVIEWCONTROLTAB' contains the fieldnames whatever you want.

example

<% data: lt_COLUMN_DEFINITIONS type tableviewcontroltab.

field-symbols:<LWA_COLUMN_DEF> like line of lt_COLUMN_DEFINITIONS.

APPEND INITIAL LINE TO lt_COLUMN_DEFINITIONS ASSIGNING <LWA_COLUMN_DEF>.

<LWA_COLUMN_DEF>-COLUMNNAME = 'STNAME'.

<LWA_COLUMN_DEF>-TITLE = 'Name'.

APPEND INITIAL LINE TO lt_COLUMN_DEFINITIONS ASSIGNING <LWA_COLUMN_DEF>.

<LWA_COLUMN_DEF>-COLUMNNAME = 'STUNO'.

<LWA_COLUMN_DEF>-TITLE = 'Student No'.

%>

<htmlb:tableView id = "TBL_CLASS"

columnDefinitions = <%=lt_COLUMN_DEFINITIONS %>

table = "<%= itab %>"

/>

[Former Member]

Hi Siva,

fine, the code send by you should be in Which event proceesing?

OnInitilization OR onCreate or OnInputProcessing??

pls clarify me.

regards

CSM Reddy

[shiva_suvarna]

Hi mallikarjun,

if you want to fill the table only once then you may write it in 'onCreate' ,

and if you want to fill the table every time page is called then you write it in 'OnInitialization'

or even you can write it in your layout part also.

[Former Member]

Hi Siva,

It is giving the following error.

<htmlb:tableView id = "itab"

columnDefinitions = <%=lt_COLUMN_DEFINITIONS >

table = "<%= itab %>"

/>

You must assign a value to the property.

Regards

CSM REDDY

[shiva_suvarna]

The error because i have not given the quotations for columndefintions value.

this is the right one

<htmlb:tableView id = "itab"

columnDefinitions = "<%= lt_COLUMN_DEFINITIONS >"

table = "<%= itab %>" />