topic Re: Table Maintainance Generator in Application Development and Automation Discussions

Table Maintainance Generator

former_member355168 — Thu, 08 Dec 2011 07:52:55 GMT

Dear Experts,

I hv created a ztable containing following fields.


MANDT	                MANDT                  Primary Key
ZVEHICLE 	                ZSDVEHICLE         Primary Key
ZDCODE 	               ZDCODE                 Primary Key
ZOUT_DATE	               ZDATUM                 Primary Key
ZOUT_TIME	               ZOUT_TIMS            Primary Key
ZOUT_READING          ZMTR_READ
ZIN_DATE	              ZDATUM_IN
ZIN_TIME	              ZIN_TIMS
ZIN_READING            ZMTR_READ
ZSTATUS	             ZSTAT                        ( IN , OUT values possible)
ZREMARKS	             ZCHAR50

Now i m trying to create a Table Maintainance Generator And the Problem is following two fields are not visible in TMC.


ZIN_DATE	              ZDATUM_IN
ZIN_TIME	              ZIN_TIMS

But if i add another field with other data type ( other than time and date), that field is visible.

And if i include above two field in primary key, then only it is visible.

Is ther any restriction with time and date format field with TMC.

Any idea.

thansks in advance.

Jaspal

Re: Table Maintainance Generator

former_member216611 — Thu, 08 Dec 2011 10:17:03 GMT

I think in the display mode those are not displayed wen you click on new entries or modify you will get these two fields.

to check invisible fields or to make any field invisible click on configuration (left top of the grid ) ,then click on administrator

then put check box or remove check box to the fields.

<removed by moderator>

Regards

Siva

Edited by: Thomas Zloch on Dec 8, 2011 11:55 AM

Re: Table Maintainance Generator

Former Member — Thu, 08 Dec 2011 11:12:10 GMT

Hi jaspal,

Here you had assigned TMG maintainance type as two step , if you assign this you cant see fields having same domain unless you make them as primary key. If you want to see all fields irrespective of same domain , assign maintainance type as one step.

Regards,

Ravi

Re: Table Maintainance Generator

Former Member — Fri, 09 Dec 2011 07:17:11 GMT

Hi,

Check below -

1. Is it a 1 step or a 2 step TNG (as i notice the fields not visible are non key fields) if 2 step, dbl click on any line, next screen will show the fields.

2, Check in the screen of the TMG, check if the fields you need are present there, if no regenerate the TMG,.

3. Have u added the fields later? if yes, regenerate the TMG.

thx viv

Re: Table Maintainance Generator

Former Member — Mon, 12 Dec 2011 10:01:27 GMT

Hi Jaspal,

There are two maintenance types available while creating a table maintenance generator.

1. One step

2. Two step

If the TMG is built in one-step, then all the fields (both key and non-key fields) will be displayed in a single screen. So, all your fields will get displayed.

Whereas if the TMG is built in two-step, the key fields will be displayed in a single screen and further details will be displayed in another screen. In this table, you have set the fields 'ZOUT_DATE' and 'ZOUT_TIME' as primary key. so it will be displayed in one screen and the non-key fields will be displayed in the second screen. So, if the fields 'ZIN_DATE' and 'ZIN_TIME' were to be dispalyed in the first screen, make it as a primary key.

Thanks and Regards,

Priya

Re: Table Maintainance Generator

former_member226225 — Tue, 20 Dec 2011 12:28:50 GMT

if we create the table with date and time and we select those as keys then we can able to see the fields

Re: Table Maintainance Generator

former_member355168 — Wed, 21 Dec 2011 05:05:28 GMT

If its a issue of key and non key fields for one step and two step,

then why i m able to see following fields.

ZMTR_READING

ZSTATUS

ZREMARKS

regards,

jaspal

Re: Table Maintainance Generator

Former Member — Wed, 21 Dec 2011 06:57:52 GMT

Dear Jaspal

Most of the times TMG does not show up the changes or does not display fields if anything is changed after creating TMG . so better re-create the TMG.

The reason this happens, bcoz the data element XFELD does not have any label in its characteristics.

Do the following steps.

a) create new data element

b) assign XFELD domain to it

c) give proper labels to it

d) in your Z table, put this data element

e) activate table

f) re-generate maintenance.

3. Now it will come alright

Warm Regards

NZAB