Max function

[Former Member]

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

[Former Member]

Hi,

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

regards,

madhu

[Former Member]

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

[Former Member]

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.