topic Matchcode in a view in Application Development and Automation Discussions

Matchcode in a view

Former Member — Tue, 19 Jun 2007 20:47:23 GMT

Hi Experts,

I've a table with a field 'FIELD'. This table has a view too.

When I test the view, the field must have a matchcode. When I click on the matchcode it opens, ask me for a table name, displays the fields of it, I select one of them and this name and its description must appear on the view.

The table has not a field for the description.

The long description of the field is DD04T-SCRTEXT_L.

Tabname is DD03L-TABNAME

Fieldname is DD03L-FIELDNAME

Rollname is DD03L-ROLLNAME

But no way of connecting DD03L and DD04T through the join conditions.

I used DD03M view...when I open the matchcode, fields name are displayed but when I choose one, it doesn't appear on the field view. And I don't know how to add the description field to the view.

Please help me out in this.

Thanks in Advance,

Lilian.

Re: Matchcode in a view

Former Member — Wed, 20 Jun 2007 05:23:29 GMT

You can connect the tables DD03l and DD04T

using the field ROLLNAME (dataelement)

it is there in both tables

take the tablename, field name , and dataelement from DD03L and

pass the ROLLNAME field of dd03l to dd04t and take the description field

Reward points for useful Answers

Regards

Anji

Re: Matchcode in a view

Former Member — Wed, 20 Jun 2007 13:31:02 GMT

Thanks Anji, I know that, but I can't do it.

When I go to Dictionary - Mantain View, I can add DD03L (fieldname), press Relationships Button, choose DD04L (Rollname) which is an option in the Referenced Tables.

After that, when I select DD04L (in the table list) and Relationships, table DD04T is displayed but as "Relationships with unsuitable cardinality", so I can't choose from this list.

Can you help me?

Regards,

Lilian.