topic Re: Database Table related in Application Development and Automation Discussions

Database Table related

Former Member — Sat, 24 Nov 2007 10:28:54 GMT

Hi all,

I have a table ZPPSFCTSTPDET in which i have i added some fields and i want to insert data in that. when i go to T-code sm30 -> Disply it is showing names of some of the fields only and remaing are shwon as ' + ' sign . I dont know why it is not showing name of somefields. please tell me why it is not showing in that.

In table display in se11 it showing properly and in delivery maintance tab i hv given maintence allowd. but still i dont know the prob.

<b>useful answer rewarded.</b>

regards,

sunil kumar.

Re: Database Table related

former_member195698 — Sat, 24 Nov 2007 10:31:07 GMT

You have to assign DATA ELEMENTS to the Fields for which + sign is appearing in SM30.

Fill the Field Label also for these data elements and regenerate the table maintenance

This issue happens when you assign direct types to the fields while defining the database. Instead of Direct type use DATA ELEMENTS for these fields

Regards,

Abhishek

Message was edited by:

Abhishek Jolly

Re: Database Table related

Former Member — Sat, 24 Nov 2007 10:31:14 GMT

Maintain field label for the data element which you have used to define type of the added field.

Regards,

Amit

*Always reward points for helpful answers

Re: Database Table related

Former Member — Sat, 24 Nov 2007 10:52:35 GMT

HI ABHISHEK,

i have assigned already datalements to the fields and field lables were missing for some and i hv given the field lables but it is still showing the same. why i dont know. please tell me...

Thanks & Regards,

sunil kumar.

Re: Database Table related

former_member195698 — Sat, 24 Nov 2007 11:03:24 GMT

Have you regenerated the table maintenance?

Try the regeneration. The new changes will be updated only with Regeneration of the maintenance.

Utilities -> Table Mainteance Generator.

save the settings in a notepad. Delete the maintenance. Re-Create the maintenance with the same settings.

Then again /nSM30 and see the table.

<b>Reward Points if useful</b>

Regards,

Abhishek

Message was edited by:

Abhishek Jolly