Skip to Content
author's profile photo Former Member
Former Member

need help for SBO _ SP _ TransactionNotification

Hai,

I want to know about the SBO _ SP _ TransactionNotification procedure.

How to modify that procedure for the validation for an field in user defined screen.

if possible can any one give website to know the detail about SBO _ SP _ TransactionNotification.

It is possible to use istead of trigger for the user defined scrren in sap b1.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jun 17, 2008 at 01:16 PM

    Hi Ramya,

    You can also see notes 990343 and 1011154 on the service marketplace for more information on SBO_SP_TransactionNotification. Please do not update database using stored procedures that can cause integrity issues in the database as per note 896891.

    Regards,

    Preety

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 01:02 PM

    Hi Ramya,

    This an example that i'm use to validate a field in an user defined object (.srf) :

    IF @transaction_type IN (N'A', N'U') AND (@Object_type IN ('IFC_GAFF'))

    BEGIN

    IF EXISTS(select * FROM [@IFC_AFF_ENT] T0 WHERE T0.DocEntry=@list_of_cols_val_tab_del AND (T0.U_IFC_DocD is null OR U_IFC_DocD=''))

    BEGIN

    SET @error = 10

    SET @error_message = N'Date document manquante'

    END

    END

    You have in this procedure a "place" where you can put your code :

    -


    -- ADD YOUR CODE HERE

    -- Insert your code here

    -


    Hope i help you

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 11:15 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.