topic Re: select? in Application Development and Automation Discussions

select?

Former Member — Thu, 05 Oct 2006 05:54:37 GMT

Hai all,

While validating a field which is better to opt and why?

1.data: l_matnr like mara-matnr.

select single matnr from mara where matnr in p_matnr into l_matnr.

where p_matnr is a selection-screen element

2.with out declaring a local variable using

select count *

if 2. is best plz provide me with code

Regards,

Madhu

Re: select?

Former Member — Thu, 05 Oct 2006 05:56:02 GMT

First one is better. Its simple!!!

reward points if u find answer well enough.

Re: select?

Former Member — Thu, 05 Oct 2006 05:57:20 GMT

hi,

i think the first method is better and less time consuming

Re: select?

anversha_s — Thu, 05 Oct 2006 06:00:10 GMT

hi,

u don want to declare local variable,

just do this.

tables mara.

SELECT SINGLE matnr FROM mara

WHERE matnr in p_matnr.

if mara-matnr is initail.

no value available.

endif.

Re: select?

anversha_s — Thu, 05 Oct 2006 06:00:18 GMT

hi,

u don want to declare local variable,

just do this.

tables mara.

SELECT SINGLE matnr FROM mara

WHERE matnr in p_matnr.

if mara-matnr is initail.

no value available.

endif.

Re: select?

Former Member — Thu, 05 Oct 2006 06:02:23 GMT

In this particular case, neither!

I would use BAPI_MATERIAL_EXISTENCECHECK or MARA_SINGLE_READ to check/read the material instead of using select statements etc. etc.

The development approach should be to levarage as much as possible from SAP standard objects/methods/FMs. One should only write code as the very last option when SAP standard functionalities are not available.

Re: select?

Former Member — Thu, 05 Oct 2006 06:02:41 GMT

Hi,

I belive the first statement is better as it does single hit to database and will terminate the connection once the first row is encountered, where as the count * will loop through all the occurences of the records before returning the count.

Hope this helps.