topic Re: select max problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/select-max-problem/m-p/4718859#M1108043 <HTML><HEAD></HEAD><BODY><P>You don't need to use DISTINCT and GROUP BY and this may be what is causing the problem. Try with GROUP BY only.</P></BODY></HTML> Tue, 04 Nov 2008 14:51:32 GMT christine_evans 2008-11-04T14:51:32Z select max problem https://community.sap.com/t5/application-development-and-automation-discussions/select-max-problem/m-p/4718858#M1108042 <HTML><HEAD></HEAD><BODY><P>Hi experts</P><P>I have this long query:</P><P></P><P> SELECT DISTINCT MAX( vbka~ktabg ) "add</P><P> mseg~mblnr</P><P> mseg~mjahr</P><P> mseg~ebeln</P><P> mseg~lifnr</P><P> mseg~matnr</P><P> mseg~grund</P><P> mseg~erfmg</P><P> mseg~erfme</P><P> mseg~shkzg</P><P> knvv~kvgr1</P><P> tvv1t~bezei</P><P> lfa1~name1</P><P> lfa1~stras</P><P> lfa1~ort01</P><P> lfa1~telf1</P><P> lfa1~kunnr</P><P> eipa~preis</P><P> eipa~bwaer</P><P> eipa~peinh</P><P> eipa~bprme</P><P></P><P> FROM mseg JOIN mkpf ON mseg<SUB>mblnr = mkpf</SUB>mblnr</P><P> AND mseg<SUB>mjahr = mkpf</SUB>mjahr</P><P> JOIN ekpo ON mseg<SUB>ebeln = ekpo</SUB>ebeln</P><P> JOIN eine ON ekpo<SUB>infnr = eine</SUB>infnr</P><P> JOIN eipa ON eine<SUB>ebeln = eipa</SUB>ebeln</P><P> AND eine<SUB>ebelp = eipa</SUB>ebelp</P><P> JOIN lfa1 ON mseg<SUB>lifnr = lfa1</SUB>lifnr</P><P> JOIN knvv ON lfa1<SUB>kunnr = knvv</SUB>kunnr</P><P> JOIN tvv1t ON knvv<SUB>kvgr1 = tvv1t</SUB>kvgr1</P><P> JOIN vbka ON lfa1<SUB>kunnr = vbka</SUB>kunnr "add</P><P></P><P> into CORRESPONDING FIELDS OF TABLE i_data1</P><P> WHERE mseg~lifnr IN r_lifnr</P><P> AND mseg~matnr = 'B1992'</P><P> AND ( mseg<SUB>bwart = '101' or mseg</SUB>bwart = '102' )</P><P> AND mseg~grund IN r_grund</P><P> AND mkpf~budat IN r_budat</P><P> AND tvv1t~spras = 'B'</P><P> AND eine~esokz = '0'</P><P> and vbka~ktaar = '0010' "add</P><P> group by</P><P> mseg~mblnr</P><P> mseg~mjahr</P><P> mseg~ebeln</P><P> mseg~lifnr</P><P> mseg~matnr</P><P> mseg~grund</P><P> mseg~erfmg</P><P> mseg~erfme</P><P> mseg~shkzg</P><P> knvv~kvgr1</P><P> tvv1t~bezei</P><P> lfa1~name1</P><P> lfa1~stras</P><P> lfa1~ort01</P><P> lfa1~telf1</P><P> lfa1~kunnr</P><P> eipa~preis</P><P> eipa~bwaer</P><P> eipa~peinh</P><P> eipa~bprme.</P><P></P><P>I get results, but in the field vbka~ktabg i get 00000000 although i know that there is values there.</P><P>What's wrong here, and how can i do this right.</P><P>Thanks</P><P>Amit</P></BODY></HTML> Tue, 04 Nov 2008 14:43:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-max-problem/m-p/4718858#M1108042 Former Member 2008-11-04T14:43:21Z Re: select max problem https://community.sap.com/t5/application-development-and-automation-discussions/select-max-problem/m-p/4718859#M1108043 <HTML><HEAD></HEAD><BODY><P>You don't need to use DISTINCT and GROUP BY and this may be what is causing the problem. Try with GROUP BY only.</P></BODY></HTML> Tue, 04 Nov 2008 14:51:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/select-max-problem/m-p/4718859#M1108043 christine_evans 2008-11-04T14:51:32Z