MDMGX error while Transporting entries

[Former Member]

Hi Guru's

I Have created a port call LT_Promotions in SAP t-code MDMGX and trying to transport this in test sytem ,while i try to save the transport it errors with message

"Key entry for table MDMGXC1 may only be generic"

Dont know what this is ..

Will you Please let me know how can i go around this..

Regards

Vikrant M Kelkar

[Former Member · Accepted solution]

Use this report MDM_GX_UPLOAD_MDMGXC1 to upload all port configs for MDMGX no need to transport.

-Sudhir

[Former Member · Accepted solution]

Hi Sudhir ,

Thanks for ur reply..But issue while using this program is ..whenever u upload a port settings for an object it replaces (instead of updating) all other Ports created for that Object type..

I hope i have not confused u..

Regards

Vikrant M Kelkar

[Former Member · Accepted solution]

Hi Vikranth,

This error happens if there are wrong entries in MDMGXC1 table. go to this table and maintain the ports and check tables.

Ports would be the ports of MDM where you want the data to be present. check tables are the tables from where you want to extract the data.

Mandatory details to be entered in MDMGXC1 are as below

Remote System Type - Remote system type in which the generic extractor is used.

Object Type -Object type for which you want to extract reference data.

Port Name - Code of the target MDM port.

Table Name - Name of a table.

Language - Independent Fields -Field names of language-independent fields to be extracted.

SQL Constraint - SQL constraint or selection criteria for selecting data from the table

The syntax to be followed is as below

Table Name - Name of a table.

Example

T005

Language - Independent Fields

Syntax

<Fld in R/3> = <Fld in MDM>, <Fld in R/3> = <Fld in MDM>,u2026

Example

LAND1=Country_key,INTCA3=Legacy_Code.

SQL Constraint

TableName~FieldName = u2018Eu2019

Example

T005T~SPRAS = 'Eu2018

Note : Maintain the above values instead of uploading.

Hope it resolves the issue

Kindly award points

Regards

[Former Member · Accepted solution]

Hi Sudheendra,

Thanks for ur reply..But not always all the systems are open ,so that you can maintain ports ,..thats the reason we maintain port in dev and trnsport it in quality and then in prod..

Regards

Vikrant M Kelkar

[Former Member · Accepted solution]

vikrant,

I would say have all the ports defined for one object in an excel sheet and always keep that version current, and using the report upload it one shot.

-Sudhir

[Bhushan_hs]

Giving Answer to a very old post, but i see still lot of people facing this problem.

the solution for this is you have to Give * at the end of name, would solve the issue.

[Former Member]

Thanks everyone..

[Former Member]

We have same issue. How did u do this? please share