Check table with 2 key fields MDG Data Model

[mohd_riyajuddin]

Dear Experts,

I a trying to extend data model with MAEX table in MDG.So MAEX table has following feilds in SAP:

1. ALAND( Key Field)

2. GEGRU (Key Field)

3. ALNUM (Non Key Field)

ALNUM has a check table assigned with 2 key fields GEGRU and ALNUM

Now when I extend the data model in MDG I created following.

1. ZMAEX SUT4

2. ALAND SUT3

3. GEGRU  SUT3

4. ALNUM as attriubute for ZMAEX(SUT4).

Issue is i am getting following error

"There is an attribute with a data element assigned that refers to a check table.

Besides the client, the check table can only have one key field that corresponds to the attribute."

I can think its because of ALNUM check table has 2 key fields .

How to extend the data in such situation.This is quite urgent ,your valuable suggestion required.

Regards,

Riyaj

[former_member704030]

Hi Riyaj,

Could you please share the full solution here?

[d024348 · Accepted solution]

http://scn.sap.com/message/16662484

Hi, as the ALNUM check table T606H contains the GEGRU as additional key fields, my answer from this threat also applies:
Two Type3 entities GEGRU, ALNUM with a leading relationship between them.

Include via referencing/qualifying relationship (as the case may be).

Good luck, Ingo Bruß

[mohd_riyajuddin · Accepted solution]

Thanks

I have done it...

[Former Member]

Hi Riyaj,

You cannot assign a Data Element with domain referring to value table which has multiple key fields for an attribute in the Data Model . This is a standard MDG rule and cannot be violated.

So create and use a custom Domain and custom search help in the data model for the attribute ALNUM to meet your requirement.