newuser plz help

[Former Member]

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

[Former Member]

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

[Former Member]

Use transaction SE16.

[athavanraja]

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

Regards

Raja

[Former Member]

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

[Former Member]

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

Srinivas

[Former Member]

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.

[Former Member]

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

[athavanraja]

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

[Former Member]

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.