topic Re: Select statement problem in Application Development and Automation Discussions

Select statement problem

Former Member — Thu, 04 Jun 2009 17:42:54 GMT

Hello all,

I am facing a problem in finding maximum number by using a select stmt.

I had a table contain fields in this seq .

z_doc table:

1.PERNR type pernr

2. Doc_type type C

3.Doc_ID type NUMC

I want to find large number in DOC_ID .

I used select statement as

Select max (doc_id) from Z_doc into wa.

But i am not getting the large number in that .

Pls help me in this issue ..Thanking you.

URS ,

Suman

Re: Select statement problem

Former Member — Thu, 04 Jun 2009 18:06:05 GMT

Hi Suman,

Try this:



data: l_doc_id type numc.
..
..
Select max (doc_id) from z_doc into l_doc_id.

george

Re: Select statement problem

Former Member — Thu, 04 Jun 2009 18:28:09 GMT

Hi Suman,

Alternative way :

1.select all the records into a table.

2.sort the table by docid descending.

3.read the table at index 1.

regards,

Dinesh

Re: Select statement problem

Former Member — Fri, 05 Jun 2009 02:00:15 GMT

Hi Suman,

You cannot get that value to a Work Area or a structure,,..

It should be retrieve to a field,,, make sure that in

Select max (doc_id) from Z_doc into wa , WA is a field of doc_id type.

Thanks & regards,

Dileep .C

Re: Select statement problem

venkat_o — Fri, 05 Jun 2009 02:32:44 GMT

Hi Suman,

Try below one, your query is right but you need to give INTO <fieldname> not <work area>.

TABLES ztest_pernr.
SELECT SINGLE MAX( doc_id ) FROM ztest_pernr INTO ztest_pernr-doc_id .
WRITE ztest_pernr-doc_id.

Thanks

Venkat

Re: Select statement problem

Former Member — Fri, 05 Jun 2009 07:33:14 GMT

Hello all,

I am facing a problem in finding maximum number by using a select stmt.

I had a table contain fields in this seq .

z_doc table:

1.PERNR type pernr

2. Doc_type type C

3.Doc_ID type NUMC

I want to find large number in DOC_ID .

I used select statement as

Select max (doc_id) from Z_doc into wa.

But i am not getting the large number in that .

Here the problem is Table is a DB table and it is sorting depends on PERNR.

So the value corresponding to highest perner getting as large doc_id.

We want to retried it by select stmt only becoz there are 50lacs data in that doc id.

Pls help me in this issue ..Thanking you.

URS ,

Suman

Re: Select statement problem

venkat_o — Fri, 05 Jun 2009 07:37:13 GMT

Hi Suman, Try below one, your query is right but you need to give INTO <fieldname> not <work area>.


TABLES ztest_pernr.
SELECT SINGLE MAX( doc_id ) FROM ztest_pernr INTO ztest_pernr-doc_id .
WRITE ztest_pernr-doc_id.

Thanks Venkat.O

Re: Select statement problem

Former Member — Fri, 05 Jun 2009 08:05:50 GMT

Hi,

SELECT MAX( FIELDNAME ) INTO TABLENAME-FIELDNAME FROM TABLE NAME

WHERE FIELDNAME = <VARIABLE> OR <PARAMETER>.

If you use more than one field in select statement then use group by cause.

SELECT MAX( FIELDNAME ) fieldname2 fieldname 3 INTO ( TABLENAME-FIELDNAME, TABLENAME-FIELDNAME2, TABLENAME-FIELDNAME3 ) FROM TABLE NAME

WHERE FIELDNAME = <VARIABLE> OR <PARAMETER>

group by fieldname filedname2 fieldname3.

Aswarth

Re: Select statement problem

Former Member — Sat, 19 Feb 2011 15:21:23 GMT

thanks all