Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Value Table

Former Member
0 Likes
1,170

Hi,

I have a Table T1->Field F1 ->Data Element DE1 -> Domain DO1 ->Value Table T2.

Table T2 has

Field F5 ->Data Element DE1 -> Domain DO1

Field F6 ->Data Element DE1 -> Domain DO1.

Now, what field in T2 actually is the T1->Field F1 ->Data Element DE1 -> Domain DO1 refering to?

Thanks,

Suryakiran D.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,155

Hi,

If F5 is the Key field of table T2 then the value table

will refer to F5.

Regards,

GSR.

11 REPLIES 11
Read only

Former Member
0 Likes
1,155

Field F5, if that is the key field in table T2

Read only

0 Likes
1,155

what if both F5 and F6 are key fields?

Read only

0 Likes
1,155

first key field

the first ocuurence field in the table

Read only

0 Likes
1,155

Then

it will look for the same type.

Regards

vijay

Read only

0 Likes
1,155

which ever is the first field in the table t2 to that field t1 field will refer to.

Read only

Former Member
0 Likes
1,155

hi,

sorry, for the previous one

it will refer the key field of T2.

if T5 is thekey field then it is The one it will refer.

Regards

vijay

Message was edited by: Vijay Babu Dudla

Read only

FredericGirod
Active Contributor
0 Likes
1,155

If the table has been well done, the both.

Rgd

Frédéric

Read only

Former Member
0 Likes
1,156

Hi,

If F5 is the Key field of table T2 then the value table

will refer to F5.

Regards,

GSR.

Read only

0 Likes
1,155

F1 may refer to anyone of the both fields F5 and F6.

Read only

0 Likes
1,155

As both fields in T2 have the same domain and data element as the field in table T1 and as T2 fields donot have value table further, any one of the two fields can be refered to the field in T1.

so the value check should be in the following way.

T1-F1 = T2-F5 or T1-F1 = T2-F6

thanks,

Aditya

Read only

Former Member
0 Likes
1,155

Hi Suryakiran,

I really doubt there is any table with a field having same domain & data element,as their description is same.But incase if you have like you are saying,then your T1-->F1 is refering to the key field among F5 or F6 in T2.