Skip to Content

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

What is the Object Type for User Define table ?

Dear All Experts,

I create one of the User Define Table with no. of UDF's

I already register User Define Table with Unique ID.

As per my knowledge, Unique ID is our Object type for that User Define Table.

I want to add Transaction Notification Code for created Used Define Table.

This Transaction Notification prevents user to must enter name in that form.

IF (@object_type = 'Z_Roto' AND (@TRANSACTION_TYPE = 'A' or @TRANSACTION_TYPE = 'U'))

BEGIN

If not Exists (Select T0.DocEntry from [@Z_ROTO] T0 Where ( T0.Name is null  OR  T0.Name = ' ' ) AND T0.Code  = @list_of_cols_val_tab_del )

begin

SET @error = 1

SET @error_message = 'Name is NULL then So, Please enter ZERO Value i.e. 0 in Filed_Name'

End

End

Please help me for this problem.

Thanks & Regards,

Nishit Makadia

Tags:
Former Member
Former Member replied

Hi All,

Thanks for your replay.

Below code is working for User Define Table's Transaction Notification

IF (@transaction_type = 'A' OR @transaction_type = 'U') AND @object_type = 'Z_Roto'

BEGIN

If Exists (Select T0.Code from [@Z_ROTO] T0 Where ( T0.Name is null  OR  T0.Name = ' ' ) AND T0.Code  = @list_of_cols_val_tab_del)

begin

select @error = 10

select @error_message = 'Name is NULL then So, Please enter ZERO Value i.e. 0 in Filed_Name'

End

End

Necessary to Remember 4 Things. That are mentioned below.

1) Register User Define Table (UDT) with using "Object Registration Wizard". For Example : @object_type = 'Z_Roto'

2) When you define selection criteria then it must be compulsory for use Code Field. For Example : Select T0.Code from [@Z_Roto]

3) When you define selection criteria then it must be compulsory for use Code for @list_of_cols_val_tab_del.

4) Use error code as 10 Number

Thanks & Regards,

Nishit Makadia

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