topic Re: Maintaince Table in Application Development and Automation Discussions

Maintaince Table

Former Member — Mon, 01 Nov 2010 14:51:53 GMT

Hi all,

i generated table but when i maintain table (SM30), i can't see fields. i defined technical settings, enhancement category, table maintenance generator but when i try to entry new data, screen is disappearing and it goes back first screen..

How can i solve that?

thanks a lot.

regards.

Re: Maintaince Table

SuhaSaha — Mon, 01 Nov 2010 15:03:36 GMT

Hello,

Try regenerating your TMG & check in SM30 again! Have you defined a single-step or a double-step maintenance for the table?

BR,

Suhas

Re: Maintaince Table

Former Member — Mon, 01 Nov 2010 15:14:43 GMT

Hi Suhas,

i have defined one step. i have tried but there is no difference

thanks.

regards

Re: Maintaince Table

nabheetscn — Mon, 01 Nov 2010 15:16:38 GMT

How many fields does your table has..? Secondly click on screen layout and check what fields are displayed there..

Nabheet

Re: Maintaince Table

Former Member — Mon, 01 Nov 2010 15:17:54 GMT

how have you defined the table? wich keys fields have u used?

Max

Re: Maintaince Table

Former Member — Mon, 01 Nov 2010 15:20:52 GMT

hi,

i have defined just mandt field.

regards

Re: Maintaince Table

SuhaSaha — Mon, 01 Nov 2010 15:23:12 GMT

You don't have any key fields other than MANDT 😮 ??

How do you think that the system will identify the unique records in the table? I am suprised ABAP compiler doesn't give an error when activating the table

BR,

Suhas

Re: Maintaince Table

Former Member — Mon, 01 Nov 2010 15:30:52 GMT

That's the problem

You have defined a table without keys, it's not enough to use MANDT as only key field: you needs to insert other fields as key, at least another one.

Which information u need to insert in your table?

Max

Edited by: max bianchi on Nov 1, 2010 4:31 PM

Re: Maintaince Table

Former Member — Mon, 01 Nov 2010 15:44:46 GMT

There is no need another key field. Because table contain 2 fields , matnr and menge. They could be more than once.

is it mandatory defining another key field.

Re: Maintaince Table

SuhaSaha — Mon, 01 Nov 2010 15:50:05 GMT

Hello,

I think you are not aware of basic RDBMS concepts.

MANDT is used for client-dependent tables & it's value is same (in the same client). Table Keys are used to identify unique reocrds in the table, in your case you'll have only one record. Hope you get the point.

BR,

Suhas