topic Re: Table without primary key in Application Development and Automation Discussions

Table without primary key

Former Member — Wed, 12 Aug 2009 09:15:18 GMT

Hi,

I have a requirement to create table without primary key.

It shows error when i create table without primary key.

Can anyone help me to create table without primary key.

Thanks in advance

Regards

Shanthi

Re: Table without primary key

former_member209217 — Wed, 12 Aug 2009 09:20:06 GMT

No, u will surely get warnings and error messages if u wont put any primary key in ur table.

Why du want a table without primary key. Wats ur requirement?

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 09:24:02 GMT

Maintain only MANDT as primary key.

Goto SE14 and click on activate and adjust database.

Thanks and Regards,

Chandra

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 09:24:06 GMT

Hi,

I have two fields in the table Role and Employee id.

There will be persons who will not have employee id but a role.

so they are asking to create table without primary key.

Regards

Shanthi

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 09:30:14 GMT

Hi,

As Chandra mentioned, use MANDT field in your table at the beginning and have that as your primary key.

Re: Table without primary key

knitinkumarsethy — Wed, 12 Aug 2009 09:30:48 GMT

HI,

There will be no problem if you keep MANDT as primary key. And it will be allowed.

It only keep the client no. And it will be taken care automatically by SAP.

You could maintain role without employee code.

Regards,

Nitin.

Re: Table without primary key

christine_evans — Wed, 12 Aug 2009 09:41:31 GMT


> Hi,
> 
> As Chandra mentioned, use MANDT field in your table at the beginning and have that as your primary key.

If you do this then you will only be allowed to create a single record in the table per client - which I don't think is what you want to do. I would generate a unique reference for each record and use that as the key. Though of course you should always include MANDT as the first column in a table and have that as the first column in each index, unless you want your table to be non-client specific.

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 09:59:39 GMT

If you not use this table in foreign key relationship u can create a table without primary key,

so that the primary key is not must for all the situation.

Edited by: jamuna palanisamy on Aug 12, 2009 11:59 AM

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 10:11:32 GMT

Hi,

I am not using any foreign key relationship.

Can u help me how to create table without primary key.

Regards

Shanthi

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 10:21:03 GMT

Hi,

Yes ,u can create a table without primary key

Create a MANDT column is an option but it allows only one row per client.

Other option is u can create a identity type of column as primary key which can auto increment by one on every new row.

Thamks,

Smita

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 10:27:05 GMT

Hi smita,

How to create identity type of column as primary key which can auto increment by one on every new row.

Thank you for all your response.

Thanks,

shanthi

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 11:45:15 GMT

YOu can use the FM NUMBER_GET_NEXT and pass the number generated here to the Ztable which will identify the row uniquely

and creatre this as the first Field of your table so that it will identify your row as unique, or you can make this as your

PRIMARY KEY

Cheers

Ramchander Rao.K

Edited by: Ramchander Krishnamraju on Aug 12, 2009 1:50 PM

Re: Table without primary key

Former Member — Wed, 12 Aug 2009 11:59:28 GMT

Hi,

You can make all your fields as composite primary key...

Regards,

Nibha

Re: Table without primary key

Former Member — Thu, 13 Aug 2009 04:02:49 GMT

Hi Shanthi,

You can't create a table without Primary key in SAP DDIC.

Better you consider 3 rows instead of 2 rows.

the first row will be a dummy row with Serial No..

2nd and 3rd rows will be ROLE and Employee ID as usual.

Make this 1st row as primary key field

Regards,

Anirban

Re: Table without primary key

Former Member — Fri, 14 Aug 2009 08:18:22 GMT

Hi,

Choose both the fields as primary keys. It means the same person cannot have the same role more than once. But he can have a different role. I think this would be the best solution. Let me know if you have any Queries.

- Sheeba.