restrictions on table entries

[Former Member]

Hi Experts,

I have created a custom table, which has coloumns 1 & 3 as matnr type.

I have two requirements:

1)  the column 4 shuld have a positive numberic value when these two columns have same material.

2)  Coloumns 3 & 4 can have only materials from mara with materialgroup = grp1 & grp2.

If asked to code, there is no problem, but the requiremnt is to put at the table level.

If i put it in the TMG, it wont be able to stop someone directly updating through program.

Through check table we can only restrict the entries to be from mara, but cannot retrict material group wise.

Can some one please suggest me a way of doing it.

[Former Member]

Hi Naveen ,

1)	Go to yourTMG-->ENVIRONMENT---->MODIFICATION---->EVENTS.
2).	click on new entries
3).	Now use the maintainence event 01 ie before saving the data in the database
4).	in the subroutine write the logic to restrict the entries .

[s_nnoorie]

Hi, This can be done only using Events in TMG.

[rosenberg_eitan]

Hi,

"Through check table we can only restrict the entries to be from mara"

Do a small test write a small program that add EMPTY record to table.

Did you succeed entering to the table erroneous record ?

Regards.