SAP Note 28477 - KEA0: message E175: error in foreign key generation

Symptom:

Generating the environment of an operating concern ends with the error message
E606 (KE)operating concern xxxx: Not all objects of the
environment generated
The log contains the error message:
E175 (KX/KF) Error in the foreign key generating field "CE1...
F4 help and the derivation for the characteristic "Product hierarchy" (field PRODH) do not function.
If you use SE12 to display table CE1xxxx (xxxx = operating concern), a '*' is entered as a check table for field PRODH.

Solution

1. Please insert the following report in your system and then execute it. It completes the entry in the field catalog for the characteristic "Product hierarchy". Please ensure that the literals contained in the program text (they are enclosed in single quotes '') are entered in UPPERCASE LETTERS. report zzprodh.
tables: tkef.

update tkef set rolnm = 'PRODH'
chtab = 'T179'
chfie = 'PRODH'
retab = 'T179T'
refie = 'VTEXT'
viewn = 'V_T179'
ortab = 'MVKE'
orfie = 'PRODH'
where fienm = 'PRODH'
and usgfl = 'D'.

commit work.

2. Maintain the foreign key relationship in tables/structures CEOxxxx,

CE1xxxx, CE2xxxx, CE4xxxx, CE7xxxx and CE8xxxx for field PRODH. To do
so, start transaction SE11, position the cursor on field name
PRODH and press F8. Accept the suggested default. Afterwards, the
table must be reactivated.
Tables -> Activate

3. Repeat the generation of the environment for the operating concern.

If you already included this field in your operating concern prior to 3.0C, the error is not eliminated by an upgrade to 3.0C or above. In this case, you have to proceed as described in this note.

Additional key words
Cause and prerequisites

The characteristic "Product hierachy" is contained in the list of default characteristics. It is not contained in an operating concern at the time of a release upgrade to 3.0, or the installation is a new installation. In these cases, the corresponding entry is incomplete in the field catalog. No foreign key relationship is created in the tables/structures for the field.