Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SP in Incoming Payment

Hi All,

I'd like to block the incoming payment being add by using SAP SP Notifications. Unfortunately the SP cannot block it, wolud you please help to check what's wrong with my SP. Here is my SP:

IF @transaction_type IN ('A','U') AND @object_type = '24'
BEGIN
IF EXISTS(SELECT T0.U_AcctName FROM DBO.ORCT T0 
WHERE (T0.U_AcctName = '' OR T0.U_AcctName = '0') AND T0.DOCENTRY = @list_of_cols_val_tab_del)
BEGIN
SELECT @Error = 1, @error_message = 'Account name must not be blank'
END
END

Note. U_AcctName is udf in payment header

Thanks and Regards

replied

Great. If it works then you should mark the thread answered.

Suda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question