topic Re: key field in Application Development and Automation Discussions

key field

Former Member — Tue, 17 Mar 2009 05:51:40 GMT

hi all,

now we are using member id as key field in one table but we must use member id key field in another table with same member id duplicate.

is it possible.

suresh maniarasu

Re: key field

Former Member — Tue, 17 Mar 2009 05:59:49 GMT

Yes possible.

Re: key field

Former Member — Tue, 17 Mar 2009 06:01:34 GMT

Yes...its possible when declaring the field in other table give the same dataelement for field name...

that is used by member id.

Further set relationships if required.

Regards,

Gurpreet

Re: key field

Former Member — Tue, 17 Mar 2009 09:35:03 GMT

Hi Suresh,

It is possible to have the same field in two different table.

When you create the field in the second table, use the same data element as that of the first table field. Hence you will have the same properties for both the table fields.

Hope this clears the doubt.

Re: key field

Former Member — Tue, 17 Mar 2009 09:45:41 GMT

Hi.... This is Basic question. jst check MARA, MARC, MARD. in this tables MATNR is Primary key.

Regards,

KP.

Re: key field

Former Member — Wed, 18 Mar 2009 10:47:28 GMT

Hi Suresh

You can use the same field name in two different tables. In order to obtain the same properties and attributes for the two fields, define them with the same data elements.

You can check for the same in your system where VLCVEHICLE and VLCHISTORY have the common field VGUID. Also, you can look for some other examples in Material Master tables.

Hope this helps.

Regards

Harsh

Re: key field

Former Member — Wed, 18 Mar 2009 11:18:51 GMT

Hi,

Yes you can use the same fields as key fields in more than two tables, but make sure to create the relationship between the two tables if requried using this key.(only if required)

Pooja

Re: key field

Former Member — Thu, 19 Mar 2009 06:43:35 GMT

Yes possible..No doubts in that.

You can proceed!

Regards,

K.Sibi

Re: key field

Former Member — Wed, 25 Mar 2009 07:17:01 GMT

Hi,

Yes you can have the same field in two different tables. As we have the same primarykey MATNR in our standard tables. If your query is solved award pointd and close the question.

Regards,

Pavan.

Re: key field

Former Member — Wed, 25 Mar 2009 08:54:47 GMT

yes it is possible there is no doubt abt it,

for ex: ebeln (po doc) is in ekko ekpo and eket.

Regards

Re: key field

Former Member — Mon, 30 Mar 2009 08:29:58 GMT

Hi,

Yes it is certainly possible.

You can use same field with the same data element as a key field in more than two tables.