Skip to Content
author's profile photo Former Member
Former Member

Select Max Problem

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 14, 2010 at 06:04 AM

    Hi,

    which SAP BUsinessObjects tool are you using ?

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.