SAP table OIU_CM_MAT_PRCD (Material and Product Code (processing) Xref)

SAP table OIU_CM_MAT_PRCD has 2 primary key fields being MANDT,MATNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
MAJPD_CD Major product code CHAR 1 0 OIU_MAJPD_CD
1 Oil
2 Natural Gas
3 Condensate
4 Plant NGLS
5 Water
7 Sulfur
9 Injectants
PD_CD Minor Product Code CHAR 2 0 OIU_CM_PDCD OIU_PD_CD

OIU_CM_MAT_PRCD foreign key relationships

Table Field Check Table Check Field
0 OIU_CM_MAT_PRCD MANDT T000 Clients MANDT
1 OIU_CM_MAT_PRCD MATNR MARA General Material Data MANDT
1 OIU_CM_MAT_PRCD MATNR MARA General Material Data MATNR
0 OIU_CM_MAT_PRCD PD_CD OIU_CM_PDCD Product Codes - Tblcm003 MAJPD_CD
0 OIU_CM_MAT_PRCD PD_CD OIU_CM_PDCD Product Codes - Tblcm003 PD_CD