topic Re: Max function in Application Development and Automation Discussions

Max function

Former Member — Fri, 20 Jun 2008 03:56:23 GMT

Hi experts,

I want to fetch records(PR PO bwart) against maximum movement type(bwart).

Is there max function in abap or tell me some alternative

Select PR PO max(bwart) from ekbe into i_ekbe

group by PR PO bwart.

Is this code correct.

Savita

Re: Max function

Former Member — Fri, 20 Jun 2008 04:00:41 GMT

Hi,

yes the code is right. the max fucntion u used is the right way to find the max value.

regards,

madhu

Re: Max function

Former Member — Fri, 20 Jun 2008 04:05:53 GMT

Hi,

The movement types are defined as numbers like 561 etc.So if you use MAX then highest number is selected.If you wish to have the same thing then your code is correct.

Re: Max function

Former Member — Fri, 20 Jun 2008 04:22:33 GMT

Hi madhu,

Can u tell me , the group by clause with left join & where caluse.

It is showing an error The field "A_{EBELP" from the SELECT list is missing in the GROUP BY clause. addition INTO wa or INTO (g1,...,gn) is required. fields of type "" or "B}WERKS".

select a_{banfn a}ekgrp a_{afnam a}txz01 a_{matnr a}werks a_{lgort a}bednr

a_{menge a}meins a_{badat a}frgdt a_{ebeln a}ebelp b_{ebeln b}ebelp

b_{belnr max( b}bwart ) b_{budat b}menge b~matnr

b~werks

from ( eban as a left outer join ekbe as b on

a_{ebeln eq b}ebeln and

a_{ebelp eq b}ebelp )

into corresponding fields of

table eban_ekbe

where a~ekgrp in s_ekgrp and

a~afnam in s_afnam and

a~matnr in s_matnr and

a~werks eq p_werks and

a~lgort in s_lgort and

a~badat in s_badat

group by b_{ebeln b}ebelp b_{belnr b}bwart b_{budat b}menge b~matnr

b~werks.

I have to put group by on my second table

Savita