Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

code-filtering rows

Former Member
0 Likes
710

hii,

In the output there is one date field,

depending on the selection criteria, some rows in the output shows 00000000 as date

i dont want the rows containing date field 00000000 in the output.

how to remove that

thanks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
689

hi

delete tablename where field is initial.

or

delete tablename where field = 00000000.

regards

surender

6 REPLIES 6
Read only

Former Member
0 Likes
689

HI,

if u r using alv in the field catalog place the NO_ZERO as 'X' .

Regards,

Naresh

Read only

Former Member
0 Likes
689

Hi,

Which report ur using for displayin the data. If it is a list report then when ur looping the inernal table use the where condition and provide the condition as date not initial.

Regards,

Shafi

Read only

Former Member
0 Likes
690

hi

delete tablename where field is initial.

or

delete tablename where field = 00000000.

regards

surender

Read only

Former Member
0 Likes
689

thanks all of u.

hii naresh,

will no_zero = x replace dat field as x

hi shafi,

wat does date not initial do.

Read only

Former Member
0 Likes
689

Hi Aks,

you can use delete itab where date = '00000000' .

'Thanks

Sahil

Read only

Former Member
0 Likes
689

thanks