Skip to Content
avatar image
Former Member

Approval Procedure

Hi Experts,

I have to set up an approval procdure based on a query fot my client.

The approval procedure has the following criteria.

When someone creates a new Sales Order and goes to the Accounting tab and changes the Default payment terms that has been set up for the BP (i.e the payment terms on his master record) , it should first go for approval.

The query that I currently have is :

SELECT DISTINCT 'TRUE'

FROM ORDR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode WHERE T0.[GroupNum] <> T1.[GroupNum]

this query above does work when someone changes the default payment terms of the BP on the Sales order which is what I want, but it also goes for approval when they don't change the payment terms on the SO which is wrong.

Please can someone assist me...

Always appreciated!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 03, 2009 at 12:53 PM

    I don't think that this is question for SAP MaxDB/liveCache forum, even if your SAP system is running on MaxDB. You might as well ask in a forum for carpentry, because you are sitting in a chair when you run this query. 😉

    You might want to try in a subforum of SAP Solutions or ABAP Development.

    regards

    Add comment
    10|10000 characters needed characters exceeded