topic Re: DB custom table (Z-table) in Application Development and Automation Discussions

DB custom table (Z-table)

Former Member — Tue, 18 Jul 2006 12:22:48 GMT

I have ZGDES table.

1). I have to add 7 fields to my ZGDES table .In se14 only I have to do that ( how to add ) ?

I just forgot which way I did previuosly...

Could you please help me in this regard.

2). I have to add the last field ( 7th field ) as with text of unlimited length to write comments (is it possible)?

other wise atleast a few hundred lines long...

How to achieve this.

you help will be APPRECISTED.

Re: DB custom table (Z-table)

Former Member — Tue, 18 Jul 2006 12:28:24 GMT

1. Add the fields in SE11.

2. Adjust the table in SE14.

Coming to long text field, you should ideally store this text using LONG TEXT and then READ the data using READ_TEXT function. You can save this text using SAVE_TEXT function, followed by COMMIT_TEXT.

All you need is a unique key to identify the text. The text object can be TEXT and id can be ST. You can even see this text in SO10 transaction.

REgards,

Ravi

Note : Please mark all the helpful answers

Re: DB custom table (Z-table)

Former Member — Tue, 18 Jul 2006 12:32:07 GMT

Hi ,

1. I have to add 7 fields to my ZGDES table .In se14 only I have to do that ( how to add ) ?

I just forgot which way I did previuosly...-->SE11.

Regards

Prabhu

Re: DB custom table (Z-table)

Former Member — Tue, 18 Jul 2006 12:37:13 GMT

Hi Sam,

Use long text. First yoy have to go se75 & create text id & object.After that you have to check there is data or not so u have to call init_text. After that save_text.

If u want to read use read_text.

If helpful reward points.

Regards

Abhishek

Re: DB custom table (Z-table)

Former Member — Wed, 19 Jul 2006 10:43:01 GMT

I don’t understand how to use LONG TEXT ….This is the first time I came across this scenario. And it is Urgent.

Could you please explain the procedure in brief how can I do ? Thanks.

I need one field to be unlimited length what to do .Atleast the filed should be of few hundred characters length please.

Re: DB custom table (Z-table)

Former Member — Thu, 20 Jul 2006 07:40:40 GMT

Ravikumar,

Could you please explain in detial...I did not get you .I Dont understand ideally store the text using LONG TEXT and then how to so this ..

Please help me. I dont know how to give , But i should give bonus points for this . Please help me.

If you can give ur cell number I can even call u.

Thanks.