"foreign key check" for non-dictionary fields

[Former Member]

Hi,

I have a table (ZT1) like MANDT, ID, KUNNR, F1,F2.... and KUNNR field is defined as foreign key . FK Cardinality is set to 1:CN and "check required" box is checked.

And i have a itab like ZT1.

When i place this field into the dialog screen (Open screen painter's "Dictinary/Program Fields Windows", type ZT1-KUNNR and place into the screen), I can see and control the "foreign key check" property in the Attributes windows.

But if i place the itab-kunnr (Open screen painter's "Dictinary/Program Fields Windows", type ITAB-KUNNR and place into the screen), the "foreign key check" property is disabled.

How can i enable foreign check for itab-kunnr?

Thank you.

[Former Member]

Hi,

That foreign key check attribute is only for DDIC field reference I guess... Why not using one of the many search help for KUNNR instead (e.g. C_KUNNR) and code a small select single for existence check in your PAI? That would do the trick...

Kr,

Manu.

[Former Member]

I wonder if i can use this attribute for itab fields too. İf I can't, I will have to write "select check" in PAI as you said.

Thank you.

[lijisusan_mathews]

You can use Foreign Key check only if it is a dictionary reference field. Otehrwise you have to write code in PAI

[Former Member]

OK. Thank to all.

[kesavadas_thekkillath]

Donot provide ITAB-KUNNR, instead WA-KUNNR . I think this should solve your problem.

Kesav

[former_member311451]

Hi,

Please check if you have provided Check table at all the places for your field, I had similar issue and i found out missing check table in my main structure.

Thanks and Regards

Naincy