Z table TMG

[Former Member]

Hi all,

I have made a Z table. There are two fields in it. Mandt, Werks.

I have to maintain Plant entries in it.

When I insert any entry it is inserted, but when I try to insert another value and display the table contents then it always shows me just one entry.

Any solution?

[Private_Member_15166]

Are you saving the data after every insertion?

[Former Member]

Thanks Dhananjay.

Yes I save the data.

[Private_Member_15166]

Hey mandt will be only primary key... that's why this is happening.. make werks as the primary key..

[former_member206479]

Hi Acharya,

It should not be like that. After entering new value and save just click on back button. It will show you all the records. If you need more information just post your screenshots how you are doing, then we will help you on this.

Regards,

Venkat.

[Former Member]

This is what i get in TMG.

I am not getting an option of multiple entries.

[Private_Member_15166]

I also onced faced this problem but is the WERKS is the primary key??

[Former Member]

This is because in TMG you maintainance type as  the Two Step, Make it One Step and re create it , you will get.Make sure Mark WERKS filed as primary key.

Rgds,

Vijay SR

[Former Member]

Hi YAsh Acharya,

    Please Mark WERKS filed in database table as Primary Key, Because of WERKS filed not marked as primary key , this thing happen...

it will work

Thanks,

Vijay SR

[Former Member]

I have marked this field as primary field.

[Former Member]

This is because in TMG you maintainance type as  the Two Step, Make it One Step and re create it , you will get.Make sure Mark WERKS filed as primary key.

Rgds,

Vijay SR

[Former Member]

Thank You Vijay.

[Former Member]

Welcome Yash

[Former Member]

[former_member206479]

Acharya,

Again go to TMG through Utilities path and change the step as single screen and save it.

Then you will find new entries button while going through SM30, there you can able to insert multiple entries at a time.

Regards.

Venkat.

[nabheetscn]

Yash please regenrate the TMG so that both key fields are considered. InTMG you have chane option

Nabheet