abap dictionary

[Former Member]

hi to all

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

[Former Member]

without primary key we cant create a table.

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

[Former Member]

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

[Former Member]

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

[former_member196299]

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

[Former Member]

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.

<u><b>Dont forget to award to points</b></u>

Regards,

Sudheer

[Former Member]

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.

<b>Reward all the helpful answers.</b>

Regards

[Former Member]

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...

[Former Member]

Hai,

You can't.

Arleast mandt should be there which allows only one field.

Disadvantage is that there is no single advantage.

Regds,

Chary.

[Former Member]

Hi,

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

Regards,

Sudheer

[Former Member]

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

regards,

Venkat

[Former Member]

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.

[Former Member]

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.

[Former Member]

hai

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

thanks vel.

[Former Member]

tx

[vijy_mukunthan]

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