SAP table OIUREP_PRDCDXREF (MMS: Possible Material No/MMS Prod Cd Combinations)

SAP table OIUREP_PRDCDXREF has 3 primary key fields being MANDT,MATNR,MMS_PRODUCT_CD.

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 OIU_CM_MAT_PRCD MATNR
MMS_PRODUCT_CD Production: MMS Product Code CHAR 2 0 OIUREP_MMS_PRODUCT_CODE
01 Oil
02 Condensate
03 Processed (Residue) Gas
04 Unprocessed (Wet) Gas
05 Drip or Scrubber Condensate
06 Inlet Scrubber
07 Gas Plant Products
09 Nitrogen
12 Flash Gas
13 Fuel Oil
14 Oil Lost
15 Fuel Gas
16 Gas Lost - Flared or Vented
17 Carbon Dioxide Gas (CO2)
19 Sulfur
20 Other Liquid Hydrocarbons
22 Helium
25 Geothermal - Hot Water
26 Geothermal - Effluent Disposal
27 Geothermal - Steam
31 Geothermal - Electrical Generation, Kilowatt Hours
32 Geothermal - Electrical Generation, Thousands of Pounds
33 Geothermal - Electrical Generation, Millions of BTUs
34 Geothermal - Electrical Generation, Other
35 Geothermal - Direct Utilitzation, Millions of BTUs
36 Geothermal - Direct Utilitzation, Hundreds of Gallons
37 Geothermal - Direct Utilitzation, Other
38 Geothermal - Commercially Demineralized H2O
39 Coalbed Methane
61 Sweet
62 Sour
63 Asphaltic
64 Black Wax
65 Yello Wax

OIUREP_PRDCDXREF foreign key relationships

Table Field Check Table Check Field
0 OIUREP_PRDCDXREF MANDT T000 Clients MANDT
1 OIUREP_PRDCDXREF MATNR OIU_CM_MAT_PRCD Material and Product Code (processing) Xref MANDT