validation on SBO_SP_TransactionNotification

[Former Member]

Hi all,

i never use this SP, but now i have to do.. that´s the thing, when i create a outgoing payment and the Total Amount due is mayor than 700, the sbo, that show me a message, i ask some people and tell me that use SBO_SP_TransactionNotification, but i dont have like a examples or something that help me,

Anybody have something that really help me, and the other thing , is there an object for outgoing payment ??

Best Regards,

Christian

[Former Member]

Christian....

What the #$%& is SP ?

Could you be a bit more explicit, I have my system in spanish and I whish I could help.

-

-

---

Alfredo Pérez

www.corponet.com.mx

SAP Developer & Consultant

alperal (at) gmail.com

+52-(81)-137-937-80

[Former Member]

Hi Alfredo, i´m talking about the store procedure Transaction Notification, i don´t now how use that parameters like @num_of_cols_in_key, @list_of_key_cols_tab_del, @list_of_cols_val_tab_del

Regards

Christian Carrasco

[Former Member]

You mean something like this:

-

-

---

CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)

AS

SELECT

ProductName,

Total=SUM(Quantity)

FROM

Products P,

OD,

Orders O,

Customers C

WHERE

C.CustomerID = @CustomerID AND

C.CustomerID = O.CustomerID AND

O.OrderID = OD.OrderID AND

OD.ProductID = P.ProductID

GROUP BY

ProductName

-

-

---

And then:

-

-

---

SqlConnection conn = new SqlConnection("...");

conn.Open();

CustOrderHist.Result r = CustOrderHist.Invoke(conn, "OTTIK");

if (r.ReturnValue != 0)

return;

foreach (CustOrderHist.Row order in r)

{

Console.WriteLine(order.ProductName);

Console.WriteLine(order.Total);

}

-

-

---

Hope this helps !

-

-

---

Alfredo Pérez

www.corponet.com.mx

SAP Developer & Consultant

alperal (at) gmail.com

+52-(81)-137-937-80

[Former Member]

hi alfredo,

i don´t know if you know that when you create a new company or database whatever, there is an store procedure call SBO_SP_TransactionNotification, and that store procedure that valide to you data from UI API or DIAPI ...

Regards

Christian Carrasco

[Former Member]

I got your point... See... as I've read, the Store Procedure, must me triggered from VB, C# or using the DI API, but the variables used:

-

-

---

@object_type nvarchar(20), -- SBO Object Type

@transaction_type nchar(1), - dd, pdate, elete, ancel, C[L]ose

@num_of_cols_in_key int,

@list_of_key_cols_tab_del nvarchar(255),

@list_of_cols_val_tab_del nvarchar(255)

-

-

---

Are not precistly documented. To trigger it, use the code I posted before, and try using the following values:

object_type nvarchar

transaction_type

That's the least you need, As I know, you don't need the rest...:

num_of_cols_in_key = 1

list_of_key_cols_tab_del =

There is a fine manual you might want to read:

<a href="http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/53cefa6a-0a01-0010-cd8e-e7c189cb6519">SP_TransactionNotification</a>

-

-

---

Alfredo Pérez

www.corponet.com.mx

SAP Developer & Consultant

alperal (at) gmail.com

+52-(81)-137-937-80

Message was edited by: Alfredo Perez

Message was edited by: Alfredo Perez

[Former Member]

Hi alfredo,

what about the parameter list_of_cols_val_tab_del ??.. i dont know if i can this, when i create a outgoing payment and the total amount of that payment is smaller than 700 dolars with the store procedure transaction notification dont let me add the register, i dont know if you understand me. i hope ..

Regards

Christian Carrasco

ccarrasco@stratperu.com

[Former Member]

Christian,

As I understand (I've never used that SP) you should use it something like this:

@object_type nvarchar(20), -- Your Outgoing Payment

@transaction_type nchar(1), -- dd

@num_of_cols_in_key int, -- 1

@list_of_key_cols_tab_del nvarchar(255), -- or Sum Of Mayments SubQuery

@list_of_cols_val_tab_del nvarchar(255) -- or any other value

-

-

---

Alfredo Pérez

www.corponet.com.mx

SAP Developer & Consultant

alperal (at) gmail.com

+52-(81)-137-937-80

[Former Member]

yeah something like that, but i dont know if this is possible !!

Regards

[Trinidad]

Hi,

You can have a look to the DIEventService tool published in SDN as free source code sample. You have also a setup to install it in your server/client side and simply use a listener mechanism in your code (it is a service using MSMQ and .NET Remoting between client/server).

Just download it and have a look at:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/53cefa6a-0a01-0010-cd8e-e7c...

Hope it helps

Trinidad.

[Former Member]

Hi trinidad,

i understand that DIEventService is use when you have an add on, that right?, or i can validate too the values of the form on SBO ???

[Trinidad]

You have to add some code in your addon to use the DIEventService.

[Former Member]

but i dont want to create an addon to validate values on a form to SBO ... other alternative?

[Former Member]

hi all,

a question, how i use that field @list_of_cols_val_tab_del ?? .. is only for column key of the object.. o work with differents columns ?