Application Development 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: 

key field

Former Member
0 Kudos

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

10 REPLIES 10

Former Member
0 Kudos

Yes possible.

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Regards,

KP.

former_member217316
Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

Yes possible..No doubts in that.

You can proceed!

Regards,

K.Sibi

Former Member
0 Kudos

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
0 Kudos

yes it is possible there is no doubt abt it,

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

Regards

Former Member
0 Kudos

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.