Application Development and Automation 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: 
Read only

Characters

Former Member
0 Likes
2,308

Hi,

I want to upload text lines of 350 characters in a db table.

How do I create the domain?

Regards,

Netra

10 REPLIES 10
Read only

Sm1tje
Active Contributor
0 Likes
1,553

in se11 enter name of your data element and create it. In here use either built in type, or create a domain by double clicking on the name you are entering.

Read only

Former Member
0 Likes
1,553

Hi,

Put the data type as char and length as 350.

Thank you.

Read only

0 Likes
1,553

hello,

it allows length of only 255

Read only

0 Likes
1,553

better to take the data type as STRING

Read only

0 Likes
1,553

instead of a data element, use a predefined type STRING

but for some technical reasons, i think you can use at most three string type fields in your table.....just FYI

Edited by: Priyank Jain on May 14, 2008 5:41 AM

Edited by: Priyank Jain on May 14, 2008 5:41 AM

Read only

Former Member
0 Likes
1,553

Hi,

Use LCHAR.

Predefined Types in the ABAP Dictionary

The following table lists the predefined types in the ABAP Dictionary. These types cannot be used directly in ABAP programs, and are therefore known as external data types. Instead, they are used in the ABAP Dictionary for the definition of data types to which ABAP programs can refer. The predefined data types of the ABAP Dictionary must also be taken into account in Open SQL statements and when working with screens: Open SQL statements work with database tables defined in the ABAP Dictionary whose colums have external data types. Screen fields are also declared in the Screen Painter with reference to external data types.

Type Permitted Places m Meaning ABAP Type

ACCP 6 Accounting period n(6)

CHAR 1-255 Character string c(m)

CLNT 3 Client c(3)

CUKY 5 Currency key c(5)

CURR 1-31 Currency field p((m+1)/2)

DATS 8 Date d

DEC 1-31 Calculation/amount field p((m+1)/2)

FLTP 16 Floating point number f(8)

INT1 3 1 byte integer b

INT2 5 2 byte integer s

INT4 10 4 byte integer i

LANG 1 Language c(1)

LCHR 256-... Long character string c(m)

LRAW 256-... Long byte string x(m)

NUMC 1-255 numerischer Text n(m)

PREC 2 Accuracy of a quantity field s

QUAN 1-31 Quantity field p((m+1)/2)

RAW 1-255 Byte sequence x(m)

RAWSTRING 256-... Byte sequence xstring

SSTRING 1-255 Character string string

STRING 256-... Character string string

TIMS 6 Time t

UNIT 2-3 Unit key c(m)

For types LCHR and LRAW, the maximum number of places in a transparent database table is the value of the preceding INT2 field.

The types RAWSTRING and STRING have a variable length. A maximum length for these types can be specified, but has no upper limit.

The type SSTRING is available as of release 6.10 and it has a variable length. Its maximum length must be specified and is limited to 255. The advantage of this type compared with CHAR, is that it is assigned to the ABAP type string.

The table below shows the data types of the ABAP Dictionary that are based on the predefined types in the above table, and that can be addressed in an ABAP program. The elementary components of these data types are converted to predefined ABAP data types according to the final column in the above table, whereby the number of places m of each type is converted to lengths.

Data types in the ABAP Dictionary Data types in ABAP

Data element Elementary data type, Reference type

Structure, Database table, View Structured data type

Table type Table type

Reward If Helpfull,

Naresh

Read only

Former Member
0 Likes
1,553

Hi Netra,

Yes, you are correct. SAP allows a maximum of 255 length in any field . You can create a domain of any size, but when you use it for displaying purpose, it displays a maximum of 255 only, as it can hold only 255 at max. So always better try to use within 255 length only.

Hope this is helpful to you. If you need further information, revert back.

Reward all the helpful answers.

Regards

Nagaraj T

Read only

Former Member
0 Likes
1,553

Hi,

To create domain do the following:

goto se11 -> create a domain -> in Data Type put 'string'.

Data type char can be set maximum 255 characters. So give data type as 'String'. It will not ask for output lenght.

Please try the above solution and reply if anything is needed.

Reward if useful.

Thanks and regards,

Ashlesha

Read only

Former Member
0 Likes
1,553

Use a predefined type STRING with length 350.

Set the enhancement catagories to can be enhanced.

This will allow you create a table with field of 350 characters .the table will be a deep structure.you can't use the table field for ranges but can do other stuff's.

extras>enhancement catagoeries>can be enhanced.

Read only

fabio_passoni
Explorer
0 Likes
1,553

Check type; RAWSTRING