topic Why only Character data type allowed for primary key fields? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898169#M1144000 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P> Could anybody tell me why only Character data type allowed for primary key fields?</P><P></P><P>We also have MANDT (data type -CLNT) as the integral field in the primary key.</P><P>then is it the only exception ? ( primary key field with non-character data type )</P><P></P><P>Please Clarify...</P><P></P><P>Thanks...</P></BODY></HTML> Thu, 11 Dec 2008 05:15:51 GMT Former Member 2008-12-11T05:15:51Z Why only Character data type allowed for primary key fields? https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898169#M1144000 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P> Could anybody tell me why only Character data type allowed for primary key fields?</P><P></P><P>We also have MANDT (data type -CLNT) as the integral field in the primary key.</P><P>then is it the only exception ? ( primary key field with non-character data type )</P><P></P><P>Please Clarify...</P><P></P><P>Thanks...</P></BODY></HTML> Thu, 11 Dec 2008 05:15:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898169#M1144000 Former Member 2008-12-11T05:15:51Z Re: Why only Character data type allowed for primary key fields? https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898170#M1144001 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Who said Primary key can not be other data types than CHAR, you can create with any data type</P><P>to the best of my knowledge FLTP is an exception</P><P></P><P>Best Regards</P><P>Ramchander Rao.K</P></BODY></HTML> Thu, 11 Dec 2008 05:29:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898170#M1144001 Former Member 2008-12-11T05:29:06Z Re: Why only Character data type allowed for primary key fields? https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898171#M1144002 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P><A href="http://help.sap.com/saphelp_nw04/helpdata/en/11/4b6ff5d84511d1951a00a0c929b3c3/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw04/helpdata/en/11/4b6ff5d84511d1951a00a0c929b3c3/frameset.htm</A></P></BODY></HTML> Thu, 11 Dec 2008 06:01:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/why-only-character-data-type-allowed-for-primary-key-fields/m-p/4898171#M1144002 Former Member 2008-12-11T06:01:47Z