How to add a 1000 Char field

[Former Member]

Guys correcct me if i am wrong

I need to add a field of 1000 characters in the table , but how should i add it and hwo can i enter data in that field.

[RichHeilman]

When activating the table, you will get an error saying that the field is too long. Not sure how to handle this. Can you do this with a cluster table or pooled table?

Regards,

Rich Heilman

[former_member181962]

Hi Seshi,

Go to se11 in change mode if it is a custom table and use the data type char and length as 1000.

and then activate it.

To populate, you can either write a z program or enter using table maintenance screen defined for your table.

Regards,

Ravi

[RichHeilman]

Try using the data element LRAW1000 for you field.

Regards,

Rich Heilman

[RichHeilman]

Ok, I just created this table

<b>Field   Data Element</b>

MANDT	MANDT
TEXTL	SYBIN2
TEXT	EDI_SDATA

Use EDI_SDATA as your data element for the 1000 character field.

Here is a short program, updating and reading from the new database table.

report zrich_0001.

data: xztest type ztest.
data: iztest type table of ztest with header line.

xztest-text = 'Hey there, this is some text'.
xztest-textl = strlen( xztest-text ).

insert ztest from xztest.


select * into corresponding fields of table iztest
          from ztest.

loop at iztest.
  write:/ iztest-text.
endloop.

Regards,

Rich Heilman

[Former Member]

Seshi,

Use the follwoing Data Elements:

1. CHAR1000SF (eg: Dict elemnt: SFPARAM)

2. LINE1000 (eg: Dict elemnt: BDI_LINE)

U have use the ABAP program to populate the Table.

Thanks

Kam