Creating Maintenance View - related issue.

[Former Member]

Hello Experts,

I have created a maintenance view. Which is join with Ztable, USR21, ADRP tables with foreign key relations.

in my view fields there is one filed SMTP_ADDR (e-mail) from the table ADR6.

I have no foreign key relation with above tables for the ADR6 table.

How can I add this field to table maintenance and display its value?

Kindly provide the suggestions.

Regards,

RH

[Former Member]

using personnel number in adrp and adr6 we can add the field and display its value

[Former Member]

But when we try to find foreign key relation for ADR6 to USR21 or ADRP, no relation available so finally we are not able to join ADR6 table.

is there any other approach for this issue?

Regards,

RH

[joginder_singh]

Hi

You can make use of PERSNUMBER which is present in ADR6,ADRP ,USR21.

And also you can make use of selection condition tab.

Cheers

Joginder