key field

[Former Member]

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

[Former Member]

Yes possible.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

Regards,

KP.

[Former Member]

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

[Former Member]

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

[Former Member]

Yes possible..No doubts in that.

You can proceed!

Regards,

K.Sibi

[Former Member]

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.

[Former Member]

yes it is possible there is no doubt abt it,

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

Regards

[Former Member]

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.