Join CRHD (0WORKCENTER_ATTR) on MSEG (2LIS_03_BF)

[igorpw]

Hi everyone,

I try to join CRHD and MSEG tables with extractors, I tried the steps in this link but without success:

MSEG and CRHD Table joining. | SAP Community

I don't see how it is possible to join the 0WORKCENTER_ATTR with the 2LIS_03_BF extractors.

In there the AFVC route is mentioned, but it is unclear to me how I can join AFVC with MSEG without ending up having duplicate records.

I have the following order extractors that hold AUFNR that MSEG also holds, but none of them hold 'ARBID':

2LIS_04_P_MATNR

0PRODORDER_TEXT

0PRODORDER_ATTR

Any help would be greatly appreciated!

Cheers,

Igor

[igorpw]

Can anyone point me in the right direction?
I assumed it would be a quite common thing to want to know what material movements belong to which workcenters?

If no-one knows the answer related to the extractors, maybe someone can write what the SQL Code would be of joining the CRHD onto the MSEG? Via which tables and which necessary columns?

Kind regards,

Igor