topic Re: Custom table key fields in Application Development and Automation Discussions

Custom table key fields

Former Member — Mon, 03 Apr 2006 13:47:56 GMT

Hi all,

I have to create some custom(Z) tables.

I just want to know how many key fields are necessary in creating a Ztable.

just one key field is o.k. or I have to check 2 or 3 fields as key fields.

I only have 4 fields in my custom table.

Any help will be appreciated.

Thanks

Re: Custom table key fields

Former Member — Mon, 03 Apr 2006 13:50:26 GMT

As many as you want. It is recommended to put a client (MANDT) as a prmary key field.

Re: Custom table key fields

Former Member — Mon, 03 Apr 2006 13:50:37 GMT

As many as it takes to make each and every record in the table unique.

This is no finite number for all tables.

Re: Custom table key fields

Former Member — Mon, 03 Apr 2006 13:52:13 GMT

Hi,

it depends on your requirement,based on that you can make them key fields, and you need to make MANDT is the primary key filed before that along with other key fields.

Regards

vijay

Re: Custom table key fields

Former Member — Mon, 03 Apr 2006 13:55:13 GMT

u can assign all 4 fields as a key field, but atleast one is necessary.but when u assign a field as a key field that field should be a 'CHAR' field other wise it will not accept.

Thanks'

Vikranth

Re: Custom table key fields

Former Member — Mon, 03 Apr 2006 14:02:54 GMT

Andy,

To be truthful, your question is a bit alarming.

If you have been tasked with creating tables and you have no formal training in DB design, I would suggest researching http://help.sap.com or making a visit to a local bookstore for beginning level book about DB design and implementation.