Filter in ALV

[Former Member]

Hi,

when i try to filetr the output is not coming and the date format has to be entered as YYYYMMDD but it has to accept the DDMMYYYY and until leading zeroes are not entered the output is not getting populated

how to change it without leading zerores and etc

thanks

shiva

[Former Member]

Hi,

when i try to filetr the output is not coming and the date format has to be entered as YYYYMMDD but it has to accept the DDMMYYYY and until leading zeroes are not entered the output is not getting populated

how to change it without leading zerores and etc

thanks

shiva

[Former Member]

it_fieldcat-lzero = "".

if this is 'X', then leading zeroes will be displayed , but this is applicable only for NUMC

for date format go to user profil and change the date format as u required.....

[Former Member]

Hii

you enter the date in ddmmyyyy

and using fm <b>CONVERSION_EXIT_PDATE_INPUT</b>

it changes to to YYYYMMDD format

TO ADD LEADING ZEROS

USE THIS FM

<b>CONVERSION_EXIT_ALPHA_INPUT</b>

REGARDS

Naresh

[rahulkavuri]

<b>Use CONVERT_DATE_TO_INTERN_FORMAT

pass DTYPE = 'DATS'.</b>

Check the above thread and ward points if found helpful

Message was edited by: Rahul Kavuri

[Former Member]

hi,

when click on filter icon at that i have to enter the date in YYYYMMDD and leading zeroes for other fields.

if i enter without zeroes it will display blank o/p

if anyone knows please help me.

thanks

shiva

[Former Member]

Hi Shivakumar,

for the fields which you are entering leading zeroes try to pass the edit_mask attribute also to the fieldcat.

some thing like this...(almost you have to do same).

<b>x_field_cat-fieldname = 'VBELN'.
....
...
X_FIELD_CAT-EDIT_MASK = '==ALPHA'.</b>

for all the fields you are trying to enter leading zeroes. you have to pass this edit_mask. before that check their domain they have any conversion routines attched in the domain level, then only it will work.

Regards

vijay

[Former Member]

hii

Try this

it_fieldcat-inttype = 'NUM'.

it_fieldcat-lzero = ''.

though the field is character , i guess it works

your problem is with internal/external format. The reason why some value 1234 with out zeros doesn't work, is because it is stored in the database as 000000000000001234. I suggest that you make sure that you filter includes the internal format.

you should make sure that the value you pass should be in the database format

You could use a function module to convert it.

<b>CONVERSION_EXIT_ALPHA_INPUT</b>

also check this link..same problem is being discussed

<b>

Regards

Naresh

[Former Member]

chk this , may be helpful