topic Re: Value Table in Application Development and Automation Discussions

Value Table

Former Member — Fri, 24 Feb 2006 13:37:13 GMT

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.

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:40:17 GMT

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

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:41:07 GMT

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

Re: Value Table

FredericGirod — Fri, 24 Feb 2006 13:42:37 GMT

If the table has been well done, the both.

Rgd

Frédéric

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:43:26 GMT

what if both F5 and F6 are key fields?

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:44:54 GMT

first key field

the first ocuurence field in the table

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:48:00 GMT

Then

it will look for the same type.

Regards

vijay

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:51:06 GMT

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

Re: Value Table

Former Member — Fri, 24 Feb 2006 13:54:58 GMT

Hi,

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

will refer to F5.

Regards,

GSR.

Re: Value Table

Former Member — Fri, 24 Feb 2006 14:15:51 GMT

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

Re: Value Table

Former Member — Fri, 24 Feb 2006 15:21:15 GMT

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

Re: Value Table

Former Member — Fri, 24 Feb 2006 15:24:47 GMT

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.