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

if and date?

Former Member
0 Likes
531

Hello!

I'm a beginner.

I have a table and the table has date column. I need to select all information where date = 0.

How can I write it in abap?

*select * from erch into ls_storno_erch*

where stornodat = 0.????

Thanks!

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
506

AA,

select  from erch into ls_storno_erch
where stornodat = '00000000'

Amit.

3 REPLIES 3
Read only

Former Member
0 Likes
507

AA,

select  from erch into ls_storno_erch
where stornodat = '00000000'

Amit.

Read only

Former Member
0 Likes
506

Hi Andrei Algaier ,

Change your select statment like this,,,

where stornodat eq initial.

it will solve ur probelm,,,,

Hope this helps you

Regards,

T.Durai murugan.

Read only

Former Member
0 Likes
506

Hi,

Use the below select statement

select * from erch into ls_storno_erch*

where stornodat is null.