How to use Stored Procedure in sap business one
How to use stored procedures in sap business one. If any sample code send me.
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
the main advantage of SP is you can execute set of SQL statement together and also conditional based .