Skip to Content

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

Item Master Data Restrict

I want to restrict user to enter Item Code less than or equal to 13 characters in Item Master Data.

How to do that without SDK ?

Is it possible. ? Plz reply.

Regards

Former Member
replied

Hi Amit,

Your requirement can be easily done using SP_TransactionNotification.

Try this as follows:

Declare @ItemCode nvarchar(30)

if @object_type = '4' And (@transaction_type ='A' Or @transaction_type = 'U')

Begin

      Select @ItemCode = ItemCode from OITM Where ItemCode = @list_of_cols_val_tab_del

      if LEN(@ItemCode ) <> 13

           Begin

           Set @error = 4

           Set @error_message = 'Item Code should be equal to 13 characters.'

           End     

End

Hope it helps.

Thanks & Regards

Ankit Chauhan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question