Table Key Fields Data Type

[former_member154070]

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]

No such criteria for creating primary keys.

Go ahead & activate the table.

[Former Member]

Hi Umesh,

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

Thanks,

Vidyashree

[Former Member]

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]

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

Regards,

Naimesh Patel

[varma_narayana]

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>