can I assign a foregin key relation ship for a structure?

[Former Member]

Hi,

can I assign a foregin key relation ship for a structure?

Thanks in advance

Sri..

[Former Member]

Hi,

You cannot define as it is independent, because structure cannot hold any data. And you cannot find any Key columns or check box to select to define a relation to the structure.

Thanks,

Sriram Ponna.

[uwe_schieferstein]

Hello Krishna

The previous answer is complete nonsense.

Of course you can define foreign-key relations for structure fields.

Simply select all records from <i>DB view</i> <b>DD03VT </b>using:

TABNAME = 'TR*' (example)
TABCLASS = 'INTTAB' (-> structure)
CHECKTABLE <> ' '     (-> i.e. has check table)

You will find thousands of structures having foreign-key relations. One example is structure TRIAS:

- its include structure TRIAS_KEY has a foreign-key relation for field INT_REFERENCE (checktable T056R).

Regards

Uwe

[uwe_schieferstein]

Hello Krishna

Forgotten to mention that you will see the foreign-key relations for a structure if you switch to tabstrip <b>Entry help/check</b> (transaction <b>SE11</b>).

Regards

Uwe