topic Re: data types in Application Development and Automation Discussions

data types

Former Member — Fri, 29 Dec 2006 19:27:20 GMT

Hello,

where can I find the different data types used in the database tables and their description

-char

-..

thanks

Re: data types

Former Member — Fri, 29 Dec 2006 19:32:01 GMT

Hi,

Check the domain DATATYPE value range for the data types and their descriptions..

THanks,

Naren

Re: data types

RichHeilman — Fri, 29 Dec 2006 19:34:48 GMT

Go to SE11, type CHAR01 into domain and click display, now do F4 help on the data type field, here are all of the data types that can be used. Here is a list.




ACCP	Posting period YYYYMM
CHAR	Character string
CLNT	Client
CUKY	Currency key, referenced by CURR fields
CURR	Currency field, stored as DEC
DATS	Date field (YYYYMMDD) stored as char(8)
DEC	Counter or amount field with comma and sign
FLTP	Floating point number, accurate to 8 bytes
INT1	1-byte integer, integer number <= 255
INT2	2-byte integer, only for length field before LCHR or LRAW
INT4	4-byte integer, integer number with sign
LANG	Language key
LCHR	Long character string, requires preceding INT2 field
LRAW	Long byte string, requires preceding INT2 field
NUMC	Character string with only digits
PREC	Precision of a QUAN field
QUAN	Quantity field, points to a unit field with format UNIT
RAW	Uninterpreted sequence of bytes
TIMS	Time field (hhmmss), stored as char(6)
VARC	Long character string, no longer supported from Rel. 3.0
STRING	Character string of variable length
RAWSTRING	Byte string of variable length
UNIT	Unit key for QUAN fields

Regards,

Rich Heilman

Re: data types

Former Member — Fri, 29 Dec 2006 19:36:43 GMT

Hi,

Go to SE11 -

Give the domain name DATATYPE

Then press display..

Then select the value range tab..There you can see all the data types and its descriptions.

Thanks,

Naren

Re: data types

Former Member — Fri, 29 Dec 2006 20:16:41 GMT

In this link you will find all the list of data types used in ABAP Data Dictionary.

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3138358411d1829f0000e829fbfe/content.htm

Thanks,

Santosh