Skip to Content
author's profile photo Former Member
Former Member

Approval when Bank Account Changes (TXN)

Hi,

My client is looking for a way to have an "approval" system for when a supplier's bank details change. We have created 4 UDFs for this (3 for approvers and 1 for an overall approval).

We set the overall approval to Yes when a BP is updated with more than two approvers (Y).

We now want to create a post transaction notification to set all to N for when a change is made to a Supplier's bank details in table OCRB and object 187.

It seems like object 187 and object 2 (BP) fire together, the reason I say this is that when you update the bank nothing happens but when you update OCRD the TXN actually fires for object 187.

We just cannot get it to fire 100%. Started using the AbsKey but as OCRB has four keys SBO concatenates the four fields to be used in the TXN.

The fields are OCRB.COUNTRY, OCRB.BANKCODE, OCRB.ACCOUNT, OCRB.CARDCODE.

The post txn we use is:

UPDATE OCRD

SET U_ApproveR1 = N'N'

FROM OCRD INNER JOIN

OCRB ON OCRD.CardCode = OCRB.CardCode

WHERE (OCRD.CardCode = (Select CardCode from OCRB where OCRB.Country+' '+OCRB.BankCode+' '+OCRB.Account+' '+OCRB.CardCode = @list_of_cols_val_tab_del))

END

Your help will be appreciated as always.

Jacques

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2012 at 11:04 PM

    Hi Jacques,

    Direct update to system table is not supported by SAP even if they are UDF.

    However, if you like to take the risk for your client, you may try:

    FROM OCRD T0

    WHERE T0.CardCode = (Select T1.CardCode from OCRB T1 where T1.Country+' '+T1.BankCode+' '+T1.Account+' '+T1.CardCode = @list_of_cols_val_tab_del)

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.