topic Re: Table Key Fields Data Type in Application Development and Automation Discussions

Table Key Fields Data Type

former_member154070 — Fri, 16 Nov 2007 04:26:44 GMT

I need create custom table.

All key fields except MANDT are of type P with decimals.

Is that Ok?

or do we need to keep key fields always CHAR type? if yes then what is the alternative?

Regards,

Umesh

Former Member — Fri, 16 Nov 2007 04:28:30 GMT

No such criteria for creating primary keys.

Go ahead & activate the table.

Former Member — Fri, 16 Nov 2007 04:54:55 GMT

Hi Umesh,

No such constrains in SAP. Key fields can of any type.

Thanks,

Vidyashree

Former Member — Fri, 16 Nov 2007 05:08:37 GMT

Hi,

Adding one more point.

if you create a primary key with character or interger, will be easy for you to easily trace the record.

Regards,

Niyaz

naimesh_patel — Fri, 16 Nov 2007 05:10:31 GMT

Generally it is advisable to make the primary key consiting of the CHAR or NUMC fields.

Regards,

Naimesh Patel

varma_narayana — Fri, 16 Nov 2007 05:34:40 GMT

Hi Umesh...

Primary key fields cannot be Created as Numeric type fields ( Int, Dec, FLTP, CURR, QUAN Etc)

you can have only Character based types such as CHAR, NUMC, DATS, TIMS, LANG, CLNT etc..

<b>reward if Helpful.</b>