Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table Key Fields Data Type

0 Kudos

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

5 REPLIES 5

former_member223537
Active Contributor
0 Kudos

No such criteria for creating primary keys.

Go ahead & activate the table.

Former Member
0 Kudos

Hi Umesh,

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

Thanks,

Vidyashree

former_member200338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Regards,

Naimesh Patel

varma_narayana
Active Contributor
0 Kudos

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>