topic Re: Select single from EKEK in Application Development and Automation Discussions

Select single from EKEK

Former Member — Tue, 17 Apr 2007 13:46:42 GMT

Hello All,

I have EBELN and EBELP with me.

WIth this I want to select only one record from EKEK where the field ABRUF has the max. value.

I don't want to select all the records and then sort it and the n delete the records with index gt 1.

Instead I want to Select from the EKEK Table only one record at once using Select single .

But I'm not able to get an Idea of how-to ?

Can any one tell me how to fetch this single record ?

Regards,

Deepu.K

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 13:52:24 GMT

use select max( ABRUF ) from EKEK into table itab

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 13:52:32 GMT

SELECT ebeln ebelp max( abruf ) from EKEK

into itab

where .....

Hope this helps.

Sudha

Message was edited by:

Sudha Mohan

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 13:55:33 GMT

Hi,

Please try this.


DATA: V_ABRUF LIKE EKEK-ABRUF.

SELECT MAX( ABRUF )
INTO V_ABRUF
FROM EKEK
WHERE EBELN = P_EBELN
  AND EBELP = P_EBELP.

WRITE: / V_ABRUF.

Regards,

Ferry Lianto

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 14:00:15 GMT

Hi,

MAX( [DISTINCT] col ) Determines the maximum value of the value in the column col in the resulting set or in the current group

Select MAX( ABRUF )

from EKEK

into Itab

where EBELN eq ______

and EBELP eq ______ .

with regards,

jay.

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 14:09:46 GMT

Hello All,

Thanks for ur reply.

But I was getting an error when I used ur Statements as it is.

SO I used like this:-


    LOOP AT gt_temp_data INTO gwa_temp_data.
      SELECT ebeln ebelp MAX( abruf ) FROM ekek
      INTO CORRESPONDING FIELDS OF TABLE gt_ekek
      WHERE ebeln  = gwa_temp_data-ebeln
      AND   ebelp = gwa_temp_data-ebelp
      GROUP BY ebeln ebelp abruf.
    ENDLOOP.

This solved my problem .

But I want to use for-all-entries.

Can u guys tell me how to use this bcoz I'm getting an error once again saying :-

"The addition for-all-entries excludes all aggregate functions with the exceptionof count(*) as the single element of the select clause ".

Regards,

Deepu.K

null

Re: Select single from EKEK

Former Member — Tue, 17 Apr 2007 14:33:31 GMT

Hi Deepu,

If you use FOR ALL ENTRIES, you can not have aggregate functions other than COUNT(*).

Regards,

Ferry Lianto

Re: Select single from EKEK

alex_m — Tue, 17 Apr 2007 14:35:00 GMT

You cant use aggregate funtion in FOR ALL ENTRY statement.