Skip to Content
0
Former Member
Jan 09, 2007 at 03:15 AM

Check Table with Constant Field

193 Views

I created table ZTEST with fields MANDT and MATNR, and also created check table MARA for field ZTEST-MATNR, so the current check logic is:

ZTEST-MANDT = MARA-MANDT and

ZTEST-MATNR = MARA-MATNR.

But I just wonder whether I can put one more creteria to only check a specified material type (MARA-MTART) such as 'ZAWA', and there is NO such a field MTART in ZTEST. That is, I want to put one more field from MARA for foreign key check, the new logic is:

ZTEST-MANDT = MARA-MANDT and

ZTEST-MATNR = MARA-MATNR and

MARA-MTART = 'ZAWA'.

Thanks in advance