topic Re: Filter Functionality is not working in ALV in Application Development and Automation Discussions

Filter Functionality is not working in ALV

Former Member — Tue, 19 Jun 2007 14:02:26 GMT

Hi,

I have a ALV Report which contains a column named Delivery Status. The Delivery Status could be of 3 types->Not Delivered, Open and Fully Delivered.

But the report is not getting filtered with respect to a certain delvery status.

For example if I select the " Delivery Status" column and choose set filter and put "Open" as filter criteria, it returns me null value where as the report contains records having "Open" status.

Please provide some solution.

Re: Filter Functionality is not working in ALV

Simha_ — Tue, 19 Jun 2007 14:19:55 GMT

Hi,

Filter in ALV Grid is a satndard functionality , so there is no need to do anything here.

Check this report example...BCALV_TEST_FULLSCREEN_FILTER

Cheers,

Simha.

Reward all the helpful answers..

Re: Filter Functionality is not working in ALV

Former Member — Tue, 19 Jun 2007 14:30:43 GMT

Hi Simha,

Thanks for ur quick reply. Yea, it’s true that Filtering is an in built power in ALV report. But in my Report all the columns which I shaving numeric values is getting filtered in the write way. But the columns which is containing string (like “open”) or characters are giving issues. Right Now the client requirement to get it filtered for Delivery Status. Please give some soln.

Re: Filter Functionality is not working in ALV

Former Member — Tue, 19 Jun 2007 14:35:25 GMT

See the below example

COL_POS = COL_POS + 1.

GT_FIELDCAT-COL_POS = COL_POS.

GT_FIELDCAT-FIELDNAME = 'EBELN'.

GT_FIELDCAT-TABNAME = P_DETAIL.

GT_FIELDCAT-REF_FIELD = 'EBELN'.

GT_FIELDCAT-REF_TABLE = 'EKKO'.

GT_FIELDCAT-KEY = 'X'.

APPEND GT_FIELDCAT.

CLEAR GT_FIELDCAT.

can u please modify ur fieldcat ? remove all this..

s_fieldcat-datatype = 'CHAR'.

s_fieldcat-no_zero = ''.

s_fieldcat-lzero = 'X'.

s_fieldcat-NO_CONVEXT = 'X'.

Regards

Ravi

Re: Filter Functionality is not working in ALV

former_member194669 — Tue, 19 Jun 2007 14:39:31 GMT

Hi,

Check the field domain , whether the domain is case sensitive?

aRs

Re: Filter Functionality is not working in ALV

Former Member — Wed, 20 Jun 2007 05:09:29 GMT

Hi Ravi,

We have used

gt_field_cat_line-outputlen = 20.

gt_field_cat_line-coltext = 'Delivery Status'.

gt_field_cat_line-seltext = 'Delivery Status'.

gt_field_cat_line-inttype = 'C'.

gt_field_cat_line-fieldname = 'LFSTA_TXT'.

APPEND gt_field_cat_line TO gt_field_cat.

Kindly suggest which modification I need to do here.

Re: Filter Functionality is not working in ALV

Former Member — Fri, 22 Jun 2007 06:35:19 GMT

I have used

gt_field_cat_line-datatype = 'CHAR'.

still it's not working

kindly help.