Skip to Content

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

Stored procedure to block delete specific type of Draft Document

Hi Dear,

How can I add control on stored procedure to block delete specific type of Draft Document, for example AR Invoice draft.

Following code not working, is there anyway to block it?

IF @object_type = '112'

BEGIN

    IF @TRANSACTION_TYPE = 'D'

    BEGIN   

        SELECT @error = -1, @error_message = 'Remove AR Invoice draft is not allowed'

        FROM ODRF T0

        WHERE T0.ObjType='13' AND T0.DocEntry = @list_of_cols_val_tab_del

    END   

END   

Please Help

Thanks in advance

Daisuki

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question