Maintenance View

[Former Member]

Hello,

I have created an maintenance view for a Z table. that z Table has 2 same data elements as Source and destination, now I am not able to get description for both the fields, however I hav created 2 fields , but its showing the description for Source only and destination check table is also same as source check table.

My Z Database Table Structure:

Route

From Plant

To Plant

Material

Data Elements:

Route

WERKS_D

WERKS_D

MATNR

I have created Database table succesfully, actual requirements needs to be mapped in following way:

Route

Route Desc

From Plant

From Plant Desc

To Plant

To Plant Desc

Matnr

Material Desc

to acheive the above output i created MAintenance view and i am not getting relationships for the plant twice, its giving me only once. It is only allowing as :

T001W MANDT = Z_TABLE1 MANDT

T001W WERKS = Z_TABLE1 TERMINAL_FROM(Plant From)

T001W will get me From Plant Desc.

Maintenanve view is successfully created but the same Plant Description is coming twice for the "From Plant" and "To Plant" both are holding values for "From Plant" only.

Can any1 please help me out to get this solution.

Thanks & Regards,

Narendra.

[Former Member]

Hi,

Try creating two separate custom data elements for From Plant and To Plant with the same domain in WERKS_D data element (Domain is WERKS). Maintain the Field Label for both the data elements accordingly as From Plant and To Plant.

Now assign the data elements accordingly against the table fields and recreate the table maintenance. You can also map the From and To Plant check table as T001W.

Regards,

Harish

Edited by: harishkumar.d on May 1, 2011 10:17 AM

[Former Member]

Hello Harish,

I have already done so.

I created 2 different data elements with same domains.

now in Maintenance view for the From Plant mapping is done, and for "To Plant" it shows like

"Relationships with unsuitable cardinality"

and hence doest allows me to do the reference for "To Plant"

Regards,

Narendra.

[Former Member]

Hi,

Check your Foreign Key Relationship.

[Former Member]

Hi Jshree,

I have already added foregin relationships in that table for plants.

Regards,

Narendra.