02-21-2007 9:08 AM
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.
02-22-2007 4:55 AM
Hi
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
02-21-2007 9:11 AM
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
02-21-2007 9:15 AM
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
02-21-2007 9:16 AM
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.
02-21-2007 9:03 PM
hi
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
02-22-2007 4:55 AM
Hi
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
02-25-2007 11:43 PM
hi
you could very well use INT types for dataelement???
Cheers,
Hakim