Skip to Content

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

Stored procedure

Dear expert can any one help me to write the procedure under which we want that once we print the sales order users can not be update or edit the sales order except the Remark(comment) column.

Below store procedure i can do but i want to left remark column .

if @object_type = '17' and @transaction_type = 'U' 

BEGIN

if exists(Select T0.DocNum  from [ORDR] T0

        Where T0.printed='Y'

        AND T0.DocEntry=@list_of_cols_val_tab_del)

begin

    SELECT @error = -5001, @error_message =

'Sales order not updated once print'

end

please help me

thanks

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