‎2008 May 14 10:31 AM
Hi,
I want to upload text lines of 350 characters in a db table.
How do I create the domain?
Regards,
Netra
‎2008 May 14 10:36 AM
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.
‎2008 May 14 10:36 AM
‎2008 May 14 10:37 AM
‎2008 May 14 10:40 AM
‎2008 May 14 10:40 AM
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
‎2008 May 14 10:37 AM
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
‎2008 May 14 10:41 AM
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
‎2008 May 14 10:45 AM
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
‎2008 May 14 11:00 AM
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.
‎2016 Mar 09 6:00 PM