Skip to Content
avatar image
Former Member

SAP Query

HI Experts,

I'm doing a query regarding outgoing payments and A/P Invoice but there's no detail appearing once I execute it. Can someone help me on this? Details needed are as follows:

  • Posting Date (OVPM)
  • Document Number (OVPM)
  • Check Number (VPM1)
  • Vendor Name (OVPM)
  • Remarks (from A/P Invoice) (OPCH)
  • Document Total (OVPM)

Thanks!

Ashley

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 06:49 AM

    Hi,

    Please check this

    Select A.DocDate,A.DocNum,B.CheckNum,A.CardName,D.Comments,A.DocTotal

    From OVPM A LEFT OUTER JOIN VPM1 B ON A.DocEntry=B.DocNum

    LEFT OUTER JOIN VPM2 C ON A.DocEntry=C.DocNum

    LEFT OUTER JOIN OPCH D ON C.DocEntry=D.DocEntry

    Thanks,

    Nithi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 06:46 AM

    Hi,

         Try this

    SELECT A.DocDate,a.DocNum,b.CheckNum,a.CardName,C.Comments,A.DocTotal

    FROM OVPM A INNER JOIN VPM1 B ON A.DocNum=B.DocNum

    inner join OPCH C ON A.DOCENTRY=C.DocEntry

    GROUP BY A.DocDate,a.DocNum,b.CheckNum,a.CardName,C.Comments,A.DocTotal

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Manish,

      Thank your for your imeediate feedback but upon execution, there is a system message that 'No data was found as a result of the selection criteria.'. I've been encountering the same error.

      Thanks!

      Ashley