RE: “foreign key check” for non-dictionary fields

      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.

      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.

      User Rating: Be the first one !
      Add Comment
      1 Answers

        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.

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.