Skip to Content
avatar image
Former Member

Outgoing payment Approval for Manual cheque

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 27, 2017 at 10:52 PM

    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'

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

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

      Regards,

      Mukesh Singh

  • Mar 28, 2017 at 09:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded