Filter Functionality is not working in ALV

[Former Member]

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.

[Simha_]

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..

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

I have used

gt_field_cat_line-datatype = 'CHAR'.

still it's not working

kindly help.

[former_member194669]

Hi,

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

aRs