Impossible to Link MSEG to CRHD without duplicating records?

[igorpw]

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

[RaymondGiuseppi · Accepted solution]

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