on 11-14-2012 12:01 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.