topic SM30 - table maintain data validation in Application Development and Automation Discussions

SM30 - table maintain data validation

rt50896 — Tue, 08 Aug 2006 08:48:33 GMT

Dear all,

When we want to validate table maintain data for cretae/change,how to get the table data or is there a internal table to use? make a sample to understand is a good way...

Regina

Re: SM30 - table maintain data validation

Former Member — Tue, 08 Aug 2006 08:51:07 GMT

REFER..

Re: SM30 - table maintain data validation

Former Member — Tue, 08 Aug 2006 08:51:56 GMT

Hi regina,

How will I know the particular record that the user modified

The CURRENT RECORD

is stored in EXTRACT.

3. U will h ave to use OFFSET to get the

primary key value of that table / or anything u want.

EG.

mykey = EXTRACT+3(10)

(BCOS 3 WILL BE MANDT FIELD

NEXT 10 EG WILL BE VBELN FIELD)

regards,

amit m.

Re: SM30 - table maintain data validation

Former Member — Tue, 08 Aug 2006 08:56:48 GMT

Hi Regina,

Normally the validation in SM30 is made by using foreign keys in the DB-tables. For example you want to enter sales organizations you link this table with the customizing table for sales organizations and link them by a foreign key. When you've done that you cannot save new SM30-entries with a sales organization which is not defined in the customizing table.

Bye,

Timo

Re: SM30 - table maintain data validation

andreas_mann3 — Tue, 08 Aug 2006 10:34:28 GMT

hi,

1st try to use check-tables when modifying your table with SE11