Filter issue in ALV

[Former Member]

Hi All,

Hope you all are doing fine!!

Am displaying an alv output list for about 15fields among which VBELN ( sales document ) is one of the fields...,am able to filter all the fields in the output except for VBELN field ,,,, i really dont understand wats happening the filter is working for all the fields except sales document field(VBELN)..?

Wud be greatful for any kind of fix for this problem!

Thanks

John

[Former Member]

Hi All,

Hope you all are doing fine!!

Am displaying an alv output list for about 15fields among which VBELN ( sales document ) is one of the fields...,am able to filter all the fields in the output except for VBELN field ,,,, i really dont understand wats happening the filter is working for all the fields except sales document field(VBELN)..?

Wud be greatful for any kind of fix for this problem!

Thanks

John

[Former Member]

How have you passed the fieldcatalog for that field?

regards,

Advait

[Former Member]

Hi

Yes, i have passed VBELN to the field catalog, even then the filter is not working for that field

Thanks

John

[Former Member]

Can you paste your code ? It would be easier to solve your problem that way.

Please put the code using the code markup.

regards,

Advait

[RaymondGiuseppi]

Look at your fieldcatalog, VBELN should not have the good definition, is suggest conversion exit (ALPHA) is not activated, so the selections are unpredictable, filtering on "100 " when "00000100" is in the table will not work. (and vice versa)

Past the code relative to the field

- filling field catalog (if programmaticaly)

- filling values into internal table (if not directly fetched from db)

- filling filter table (if programmaticaly)

Regards

[Former Member]

Hi Raymond,

Im pasting the code wherever am using VBELN in the program...ok

TYPES: BEGIN OF ty_data,

rufnm TYPE char30, "sales resp

aubel TYPE vbeln_va, "sales doc

vbeln TYPE char10, "doc doc bstkd TYPE bstkd, "po

bstdk TYPE bstdk, "po item

erdat TYPE erdat, "created on

name1 TYPE name1_gp, "customer

posnr_r TYPE posnr_vf, "billing item

prctr TYPE prctr, "profit center

netwr TYPE netwr, "net value

augdt TYPE datum, "payment date

terdt TYPE dzfbdt, "base line date

net_val TYPE netwr_fp, "net val

profit TYPE netwr_fp, "profit

END OF ty_data.

PERFORM build_fieldcat USING:

'KUNRG' 'IT_DATA' 30 text-019 CHANGING it_fieldcat,

'VKORG' 'IT_DATA' 30 text-001 CHANGING it_fieldcat,

'VKBUR' 'IT_DATA' 30 text-020 CHANGING it_fieldcat,

'SPART' 'IT_DATA' 30 text-021 CHANGING it_fieldcat,

'VTWEG' 'IT_DATA' 30 text-022 CHANGING it_fieldcat,

'AUBEL' 'IT_DATA' 30 text-023 CHANGING it_fieldcat,

'POSNR_A' 'IT_DATA' 30 text-024 CHANGING it_fieldcat,

'VBELN' 'IT_DATA' 30 text-003 CHANGING it_fieldcat,

'BSTKD' 'IT_DATA' 30 text-025 CHANGING it_fieldcat,

'BSTDK' 'IT_DATA' 30 text-026 CHANGING it_fieldcat,

'ERDAT' 'IT_DATA' 30 text-011 CHANGING it_fieldcat,

'NAME1' 'IT_DATA' 30 text-004 CHANGING it_fieldcat,

'AUGDT' 'IT_DATA' 30 text-012 CHANGING it_fieldcat.

FORM build_fieldcat USING

lw_fieldname TYPE slis_fieldcat_alv-fieldname

lw_tabname TYPE slis_fieldcat_alv-tabname

lw_outputlen TYPE slis_fieldcat_alv-outputlen

lw_seltext_l TYPE slis_fieldcat_alv-seltext_l

CHANGING lit_fieldcat TYPE slis_t_fieldcat_alv.

DATA: lwa_fieldcat TYPE slis_fieldcat_alv. "Field string

lwa_fieldcat-fieldname = lw_fieldname.

lwa_fieldcat-tabname = lw_tabname.

lwa_fieldcat-outputlen = lw_outputlen.

lwa_fieldcat-seltext_l = lw_seltext_l.

APPEND lwa_fieldcat TO lit_fieldcat.

CLEAR: lwa_fieldcat.

ENDFORM. " build_fieldcat

Thanks

John

[RaymondGiuseppi]

Okay, so the ALV is not able to correctly work with the field which is only a simple CHAR field, try to declare the field in the internal table with its actual type

aubel TYPE vbeln_va, "sales doc
vbeln TYPE vbeln, "doc 
doc bstkd TYPE bstkd, "po

like the other fields of the table.

Regards