topic Data element for integer in Application Development and Automation Discussions

Data element for integer

former_member202474 — Wed, 21 Feb 2007 09:08:38 GMT

Hi All,

There is a field 'NUM' in a custom database table it should store only integer values .What will be the apt data element for this field?

Regards,

Ruby.

Re: Data element for integer

Former Member — Wed, 21 Feb 2007 09:11:20 GMT

HI Ruby,

YOu can use Pre defined data types instead of Data elements in se11.

There will be a button just above the Data element column in se11, upload clicking which you can specify the pre defined data types like int2 int4 int8 etc.

Regards,

Ravi

Re: Data element for integer

Former Member — Wed, 21 Feb 2007 09:15:47 GMT

Hi Ruby

One way to get the required data element is via table <b>DD04L</b>.

Check the data type of type Integer to find a suitable data element.

Alternatively, as Ravi adviced we can use the Built-In Data type that suits the requirement.

Kind Regards

Eswar

Re: Data element for integer

Former Member — Wed, 21 Feb 2007 09:16:32 GMT

Is it the field name is 'NUM' or it is a numeric field??

If the field name is NUM give its data type as 'INT4'. It will store Integer values.

There is also a Data Element by name 'INT4', you can use this.

Even if data type is NUMC it also stores integers but in character format. In this case you can also provide decimals. You have already declared Data Elements for NUMC for various lengths such as 'NUMC2' (It takes 2 digits) similarly 'NUMC3',...

Regards,

Paul.

Re: Data element for integer

Former Member — Wed, 21 Feb 2007 21:03:44 GMT

u can go to SE15 and can look out for the pre-defined data elements there ... SE15 is SAP repository u can put INT* and can look out ... it will give u a list and u can select one u needed.

hope this will help

bbye taccare

Ashwani

Re: Data element for integer

Former Member — Thu, 22 Feb 2007 04:55:54 GMT

these are the data elemennts for integer

INT1 Dummy for B20 int1 (Local Everywhere)

INT2 2 byte integer (signed)

INT2_DATA Data for the Call of "SAPOSCOL" with RF

INT3 3-Character Integer Field

INT4 Natural number

regards

Shiva

Re: Data element for integer

abdul_hakim — Sun, 25 Feb 2007 23:43:39 GMT

you could very well use INT types for dataelement???

Cheers,

Hakim