problems in values of z table

[Former Member]

hi

i am creating a table with 4 columns

column #1 = source_city                           (type p22j_rctvc from table t5j63)

column #2 = dest_city                               (type p22j_rctvc from table t5j63)

column #3 = source_c_desc                     (type p22j_ctxkn from table t5j63)

column #4 = dest_c_desc                         (type p22j_ctxkn from table t5j63)

columns 1 and 2 are keys columns

the problem is when i am creating a maintainence view column 1 and 2 are open for input and the rest columns only for output,

when i choose value for column 1 i get the correct description to column #3 after that i choose value to column dest_city and the description of the city that i get is displayed in coulum #3 and not in column #4 as i want

can some tell me what can i so in order to fix this ?

thanx

ami

[Former Member]

Hi

Hope u are using events in TMG and fetching the required data.

Check whether u are populating the value to column#4 or not..

Regards

Vamshi

[manish_shankar]

Hi Ami,

While creating Maint view, Go to 'View Fields' tab and click on table fields.

Select all field and press ok.

Create Table maint. generator for this view (Utilities -> TMG).

Now Utilities -> Table Contents -> Create entries.

- Regards,

Manish Shankar.

[Former Member]

hi

thanks for your help

i know how to creat TMG this not my problem

the problem is that i have 2 fields from the same type, both are table keys and have check table to table t5j63. when i put data in column #1 - code of some city it automaticly put city name in column 3 and 4 and i want it only to put in column 3

do have a way to comtrol it ?

[ThomasZloch]

The problem is that you have two different fields with different values linking to the same foreign key table. DDIC views cannot handle this, you would need to link to the same check table twice using different aliases, which are not available in DDIC view maintenance.

I guess you need to use TMG events to solve this, look at 05 or AD, check in table TVIMF for already existing implementations to get an idea.

Thomas

[raymond_giuseppi]

- SE11 - Only put the two key fields in your table definition. Define foreign keys with table control t5j63. (remove the descriptions fields)

- SE11 - Now build a maintenance view, and add the two descriptions (changing the name of those fields) (Creating Maintenance Views)

- SE54 - Now build you maintenance dialog

Regards,

Raymond