topic Data Type with reference and view maintenance in Application Development and Automation Discussions

Data Type with reference and view maintenance

Former Member — Fri, 20 Mar 2009 05:05:10 GMT

Dear all,

There are two questions that I want to ask.

1. Error when referencing a table with data type = u2018STRINGu2019.

I have a Z table with some fields = u2018stringu2019, when I use this as a reference, an error prompted.

"ZTBL_ABC" must be a flat structure. You cannot use internal
tables, strings, references, or structures as components.-

2. Error in generating the View maintenance for field length > 255.

Actually, I want to create fields with

1. data type = char(255),

2. data type = text

3. data type = char(3000)

It is okay if I create the field with the selected size, however, when I generate the View maintenance (which can be access through SM30); it does not allow me to do so. It still not working if I change it into string. How can I create such table and use the table maintenance, as well as using that as the reference type of an internal table for another program?

Regards,

Mandy Au

Re: Data Type with reference and view maintenance

Former Member — Fri, 20 Mar 2009 05:11:44 GMT

hi:

I would advice to use standard data elements for it like

for char - 3000 Data Element is CHAR3000

char -255 Data Element is CHAR255

etc and then generate the table generator and enjoy.

Regards

Shashi

Re: Data Type with reference and view maintenance

Former Member — Fri, 20 Mar 2009 05:17:16 GMT

Hello,

1st of all a table which has a field of type string can be converted in to table maintenance because TM does not support string type as it becomes a very big field to be displayed on screen ... so u need to change that.

and then about the CHAR of length 3000 is too big ... to have a max limit of 255.

If you change this both u will be able to generate TM.

Incase after changing the field length it it gives error in activatin your table then go to SE14 put your table name EDIT and then Adjust n activate it....

hope this was helpful

--- Close the post once you get the solution

Re: Data Type with reference and view maintenance

Former Member — Fri, 20 Mar 2009 05:47:16 GMT

Thanks a lot to both shashi jha and Ajantha Ratnakumar.

Ajantha: You did answer my question about the table maintenance. I will try to solve the case. And thank you for reminding me about the SE14, I've totally forgot this T-code. ^^

shashi: I think this may not be the case about using what data element is it, since I am creating and new data element for that. Will there be any difference in using the built-in data element and the self-defined one?

Regards,

Mandy

Re: Data Type with reference and view maintenance

Former Member — Fri, 20 Mar 2009 05:51:37 GMT

Mandy,

Welcome. It was just my experience which i shared ....and 1 thing u need to close the post i hope u will be do that....