Skip to Content

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

SBO_TransactionNotification Problem Drafts - 2005A SP01 PL22

Hi Gurus,

We have an issue about the SP SBO_TransactionNotification with drafts.

When we create or update a draft (object_Type = 112) in SBO from any documents, the SBO_TransactionNotification stored procedure doesn't run.

I added this code in the SP to test it.

+====================================================

DECLARE @numlinii int

IF @transaction_type IN (N'A', N'U') AND(@Object_type IN (112)) AND (@num_of_cols_in_key = 1)

BEGIN

SELECT TOP 1 @numlinii = (LineNum +1) FROM DRF1 inner join ODRF on DRF1.DocEntry = ODRF.DocEntry

WHERE DRF1.DocEntry = @list_of_cols_val_tab_del

ORDER BY Linenum ASC

IF (ISNULL(@numlinii, 0) <> 0)

BEGIN

SET @error = 10

SET @error_message = N'Test SP: ' + CONVERT(nvarchar(4), @numlinii)

END

END

====================================================+

However, for the others documents (SO, PO, ...), everything is going well.

Please let me know what 's going wrong?

Best regards,

S├ębastien

SBO 2005A SP01 PL22

DB: SQL 2000

Former Member
Not what you were looking for? View more on this topic or Ask a question