cancel
Showing results for 
Search instead for 
Did you mean: 

Impossible to Link MSEG to CRHD without duplicating records?

igorpw
Explorer
0 Kudos

Hello everyone,

I try to link MSEG and CRHD via AFVC, but so far the posts on the community didn't solve my problem unfortunately, hence I post it here.

MSEG has only the Aufpl field to link to AFVC table, but the AFVC table has only unique records with Aufpl and Aplzl combined.

Via AFVC I can get to Arbid to link the Workcenter in CRHD, but linking AFVC to MSEG results in duplicating records.

Is there another way to get to the Workcenter field or do I miss something important here?

Kind regards,

Igor

Accepted Solutions (1)

Accepted Solutions (1)

raymond_giuseppi
Active Contributor
0 Kudos

MSEG also contains the field APLZL. Is this field initial in your system, in this case use table AUFM between MSEG and AFVC.

MSEG --(MBLNR, MJAHR, ZEILE)-- AUFM --(AUFPL, APLZL)-- AFVC --(ARBID)-- CRHD

Answers (0)