Skip to Content

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

How to use Stored Procedure in sap business one

Hi,

How to use stored procedures in sap business one. If any sample code send me.

Thanks

P.Suresh kumar

Former Member
Former Member replied

hi

you can use the "SBO_SP_TransactionNotification" , this is SAP stored procedure .

this Sp is useful to do any required validation on any documents get before add/update ,

go through the following links

[<a class="jive_macro jive_macro_thread" href="" __jive_macro_name="thread" modifiedtitle="true" __default_attr="1777172"></a>]

[/people/lisa.mulchinock/blog/2009/05/22/the-sptransactionnotification-stored-procedure]

you can create your own SP also, but you need to execute through DI API

to know more own SP

check out these links

[http://msdn.microsoft.com/en-us/library/aa174792(SQL.80).aspx]
[http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p3.aspx]

the main advantage of SP is you can execute set of SQL statement together and also conditional based .

ajith

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