topic newuser plz help in Application Development and Automation Discussions

newuser plz help

Former Member — Sat, 15 Oct 2005 06:56:05 GMT

Hi guys,

anybody suggest me a better & effective way of checking a database table whether data exist in it or not?

ur help appericiated...

raja

Re: newuser plz help

Former Member — Sat, 15 Oct 2005 07:20:45 GMT

Use transaction SE16.

Re: newuser plz help

athavanraja — Sat, 15 Oct 2005 10:16:02 GMT

thru program? what is the method you are currently using?

Regards

Raja

Re: newuser plz help

Former Member — Sat, 15 Oct 2005 14:45:15 GMT

In a program you can do something like

SELECT COUNT( * ) INTO v_count FROM dbatab.

In SE16, simply press the button 'Number Of Entries'.

Srinivas

Re: newuser plz help

Former Member — Sat, 15 Oct 2005 14:46:44 GMT

Looks like you have another post with the same question and marked it as answered. Can you please close this one too?

Srinivas

Re: newuser plz help

Former Member — Mon, 17 Oct 2005 11:59:33 GMT

hi,

try with this

data : l_matnr like matnr.

select single matnr into l_matnr from mara.

if sy-subrc is initial

records exist

endif.

Re: newuser plz help

Former Member — Mon, 17 Oct 2005 12:02:15 GMT

If these answers helped you, could you please reward and close the post?

Re: newuser plz help

athavanraja — Mon, 17 Oct 2005 13:10:43 GMT

Hi Raja,

So many people took their time and effort to understand your problem and try to give a solution. Don't you think, you should do more than just giving two points and closing the thread?

Regards

Raja

Re: newuser plz help

Former Member — Mon, 17 Oct 2005 13:14:28 GMT

I would do.

data : l_mandt type mandt.

select single mandt

from db_tab

where db_field = user_val.

if sy-subrc eq 0.

"record has been found

else.

" record does not exists

endif.