Application Development 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: 

select count(*) statement in ABAP

Amey-Mogare
Contributor
0 Kudos

Hi,

Im writing following statement in my Function module,

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword.

And there is one entry in table user_master.

But still, I'm getting l_count as zero..

Can somebody help me with this.

Regards,

Amey

3 REPLIES 3

Former Member
0 Kudos

Once Check the Values u r passing to the Select. Actually SAP Stores the values on the tables in Capital Letters. U would have given ur password in small letters.

awrd points if helpful

Bhupal

Former Member
0 Kudos

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword.

Use group by option...

Like this....

select count(*) into l_count

from user_master

where username = l_username and

process_type = processtype and

password = oldpassword group by username.

Hi,

I got that,

Actually when I replaced COUNT(*) by COUNT ( * ) , problem is resolved...

Thank u so much for your advice.

Regards,

Amey