Select Max Problem

[Former Member]

Dear Experts

I need to fetch the latest sales price and last sales date from table vbrp on the basis of material and site combination.For that purpose i tried to use the below select query which is showing syntex error as i did not used NETWR and MWSBP in GROUP BY clause .How can i achieve this as i cannot put the above two fields other wise i wont get the max sales dat for the article and site combination as it vl be unique combination every time.

SELECT  NETWR
               MATNR
               WERKS
    MAX(  ERDAT )
              MWSBP
      FROM VBRP
      INTO CORRESPONDING FIELDS OF TABLE IT_VBRP
     WHERE MATNR IN S_MATNR
        AND   WERKS IN S_SITE
    GROUP BY MATNR WERKS .

Here S_MATNR and S_WERKS are input material and site.

[IngoH]

Hi,

which SAP BUsinessObjects tool are you using ?

Ingo

[Former Member]

Hi Ingo

I did not get ur question clrearly. Would u pls elaborate me wat do u mean by Bussiness Object and how its related to my question.

[IngoH]

Hi,

this forum is for the Integration of SAP BusinessObjects BI Tools with SAP and therefore I asked which SAP BusinessObjects BI products you are using. If this is not related to this topic then I would suggest you post your question into the correct forum.

regards

Ingo Hilgefort

[Former Member]

Sorry Friends

I posted my problem in wrong forum unknowingly