Skip to Content

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

SBO_SP_TransactionNotification having wrong object_type (10000011)?

Hi everybody:

I am implementing some data validation on 2007 A PL 47 using SBO_SP_TransactionNotification, but the variable @object_type apparently holds the value '10000011' for every transactional document. I do correctly have '2' in that variable for business partners, and '171' for employees, but when the transaction is a purchase invoice, sales credit note or sales invoices, the @object_type variable always holds '10000011' and leaves me no way of verifying the object type that i'm dealing with. Is this a bug or something that I can fix?

Thanks for any insight,

Joerg.

ALTER proc [dbo].[SBO_SP_TransactionNotification] 

@object_type nvarchar(20), 			-- SBO Object Type
@transaction_type nchar(1),			-- [A], <u>, [D], [C], C[L]
@num_of_cols_in_key int,
@list_of_key_cols_tab_del nvarchar(255),
@list_of_cols_val_tab_del nvarchar(255)

AS

begin

-- Return values
declare @error  int				-- Result (0 for no error)
declare @error_message nvarchar (200) 		-- Error string to be displayed
select @error = 0
select @error_message = N'Ok'

-----------------------------------------------------------------------------------

--	ADD	YOUR	CODE	HERE

-----------------------------------------------------------------------------------

IF (1=1) BEGIN
	select @error = 1
	select @error_message = @object_type
END


-- Select the return values
select @error, @error_message

end

Note: This issue seems to be related to the database, not the server itself, as I have copied that database to another server (from one MS SQL 2005 Server to SQL 2005 Express on my laptop) and have the same issue, while at the same time the issue does not happen on my other databases of the laptop...

Edited by: Joerg Aldinger on Apr 2, 2009 8:40 PM

Former Member
replied

Dear

Testing with following codes:

if @object_type = 13 begin

select @error = 1

select @error_message = @object_type

end

adding a sales invoice, it will return 13.

it seems in the transactionnotification, there would be two object_type returned if there is vat code selected. the first one 10000011 will be vat transaction.

therfore, we still can use the SBO_SP_TransactionNotification to

notify about DB changes, cannot act as an approval mechanism and

database update process. refer to note 1011154

best regards,

xiaodan an

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