Skip to Content
0

Outgoing payment Approval for Manual cheque

Mar 27, 2017 at 12:54 PM

86

avatar image
Former Member

Hi Expert,

I'm making Outgoing Payment for all manual cheque should be approved by certain person but my approval is not working can any one check my query and correct it.

SELECT Distinct 'True' FROM OVPM t0 INNER JOIN VPM1 t1 ON t0.DocNum=t1.DocNum where $[$28.Manualchk]='Y'

Regards,

Mukesh Singh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Mar 27, 2017 at 10:52 PM
0

Hi,

Try this,

SELECT Distinct 'True' FROM OVPM t0 INNER JOIN VPM1 t1 ON t0.DocNum=t1.DocNum where $[$28.150000047]='Y'

OR

SELECT Distinct 'True' FROM OVPM t0 INNER JOIN VPM1 t1 ON t0.DocNum=t1.DocNum where $[RCT1.Manualchk]='Y'

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi,

I tried your approval procedure query but document not going for approval.

Regards,

Mukesh Singh

0
Rizki Wicaksana Mar 28, 2017 at 09:46 AM
0

Hi,

It is not possible for you to make query approval in row level.

The query can be based on data that is currently in process, with the condition that only the header tables.

Please refer to sap note : 920187

Hope this helps :)

Regards,

Rizki

Share
10 |10000 characters needed characters left characters exceeded