Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Tags:
Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question