restrictions on table entries
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.