SAP Query

[Former Member]

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

[former_member209066 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Nithi,

Thanks for your reply. The query is working fine.

Thanks!

Ashley

[former_member184146]

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

[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