topic Re: abap dictionary in Application Development and Automation Discussions

abap dictionary

Former Member — Tue, 08 May 2007 13:13:23 GMT

hi to all

with out primary key can we create the table? what is the disadventages?

Re: abap dictionary

Former Member — Tue, 08 May 2007 13:25:32 GMT

without primary key we cant create a table.

goto se11 & try to create a table without key & read the activation log.

Re: abap dictionary

Former Member — Wed, 09 May 2007 04:02:38 GMT

Hi,

As far as I concerned,Its not possible to create table without primary key.Primary key is used to uniquely identify the table.

Please refer to following links

http://help.sap.com/saphelp_470/helpdata/en/cf/21ea43446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_470/helpdata/en/cf/21eb20446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ec84446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_470/helpdata/en/cf/21eb6e446011d189700000e8322d00/frameset.htm

Re: abap dictionary

Former Member — Wed, 09 May 2007 04:06:08 GMT

hi Sandya,

As per the Database concepts we cant create a table without a primarykey.This is the rule.

When u try to do that it will will show the error its not possible to crate a table without a primary key,Atleast one primary key field we required.

Plz reward points when this is useful

Re: abap dictionary

former_member196299 — Wed, 09 May 2007 04:11:11 GMT

hi sandya,

The system will throw error when you try to create a DDIC table without a primary key .. atleast you should have one primary key for creating a database table..

Reward if helpful .

Regards ,

Ranjita

Re: abap dictionary

Former Member — Wed, 09 May 2007 06:25:10 GMT

A primary key for a table is to identify a particular record. at a ny point of time u should be ableto identify a record, Thats y its a must. u can not create a table without primary keys.

Theremust e atleast one primary key.

Dont forget to award to points

Regards,

Sudheer

Re: abap dictionary

Former Member — Wed, 09 May 2007 06:41:50 GMT

Hi Sandya,

We cannot create a table without a primary key. The Primary key is the medium used by the table to link itself with other tables in SAP. The table whichever is used is identified with the help of primary key during the application part.

So there is no question of table without primary key.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: abap dictionary

Former Member — Wed, 09 May 2007 08:44:42 GMT

Hi Sandhya

without a primary key we can create a table but the thing is that there will not be an integrity in it.

Because we are jus using primary key concept for the uniqueness of the field,if there is no primary in a table then it will cause redunancy.

Anyone number of employees with same record will exist to avoid al those we use primary key concept which will also be useful for applying joins in it.

PLEASE REWARD...

Re: abap dictionary

Former Member — Wed, 09 May 2007 09:10:39 GMT

Hai,

You can't.

Arleast mandt should be there which allows only one field.

Disadvantage is that there is no single advantage.

Regds,

Chary.

Re: abap dictionary

Former Member — Wed, 09 May 2007 09:34:08 GMT

Hi,

U have to award points for useful answers and u have to mention it as Solved if ur question is solved. Dont forget.

Regards,

Sudheer

Re: abap dictionary

Former Member — Wed, 09 May 2007 09:40:17 GMT

You can not create a custome table with out primary key. It will through the error while activation.

regards,

Venkat

Re: abap dictionary

Former Member — Thu, 10 May 2007 05:29:25 GMT

Hai Sandhya,

without primary key, we cann't create a table.

while activating the table, it shows error & table is not activated.

Disadvantage : without table activation, table structure will not be stored in SAP database.

regards,

kavitha.

Re: abap dictionary

Former Member — Thu, 10 May 2007 06:21:57 GMT

Hi Sandya,

We can not create a table with out primary key. table should have a primary key, it's must. bcoz based on primary key only data is saved to a table. so it w'll create index internally.

Regards,

Prasad.

Re: abap dictionary

Former Member — Thu, 10 May 2007 07:56:50 GMT

hai

without primary key you cannot create the table . if you created you ve an error at the time of activation.

thanks vel.

Re: abap dictionary

Former Member — Thu, 04 Oct 2007 05:39:21 GMT

Re: abap dictionary

vijy_mukunthan — Thu, 04 Oct 2007 09:48:31 GMT

hi friend!

As per SAP you cannot create a table without a primary key. Even if u try you will end up in error. Atleast one primary key is required. But u can create a table without forigen Key.

Reward with points if its helpful

Regards

vijay