Each material in SAP has its standard, base unit of measure (stored in MARA-MEINS). To allow using alternative units, those can be maintained per material in table MARM. A common requirement for ABAPer is to convert material quantity from one unit to another, most likely from an alternative unit to the base one, to be able to summarize the report results.<\/p>\n
To do the conversion, SAP provides the function module MATERIAL_UNIT_CONVERSION. Its parameter names are not self-explaining, and for my own purposes I have a simple wrapper form that I use to convert quantities from alternative to base UoM. The form is using data caching technique.<\/p>\n
form convert_to_base_uom\r\n using pf_matnr type matnr\r\n pf_menge_in type gsmng\r\n pf_meins_in type meins\r\n changing pf_menge_out type gsmng\r\n pf_meins_out type meins. \r\n\r\n* define internal table to cache the base UOM\r\n types: begin of lty_meins_rec,\r\n matnr type matnr,\r\n meins type meins,\r\n end of lty_meins_rec. \r\n\r\n types:\r\n lty_meins_tab type hashed table of lty_meins_rec\r\n with unique key matnr.\r\n data:\r\n ls_wa type lty_meins_rec. \r\n\r\n statics:\r\n lt_meins type lty_meins_tab. \r\n\r\n* first, find the base UOM\r\n clear pf_meins_out.\r\n read table lt_meins into ls_wa\r\n with table key matnr = pf_matnr.\r\n if sy-subrc = 0.\r\n pf_meins_out = ls_wa-meins.\r\n else.\r\n select single meins\r\n from mara\r\n into ls_wa-meins\r\n where matnr = pf_matnr.\r\n if sy-subrc 0. \"doesn't exist. try PC\r\n ls_wa-meins = 'ST'.\r\n endif.\r\n ls_wa-matnr = pf_matnr.\r\n pf_meins_out = ls_wa-meins.\r\n insert ls_wa into table lt_meins.\r\n endif. \r\n\r\n* now convert the qty\r\n if pf_meins_in = pf_meins_out.\r\n pf_menge_out = pf_menge_in.\r\n else.\r\n call function 'MATERIAL_UNIT_CONVERSION'\r\n exporting\r\n input = pf_menge_in\r\n kzmeinh = 'X'\r\n matnr = pf_matnr\r\n meinh = pf_meins_in\r\n meins = pf_meins_out\r\n type_umr = '3'\r\n importing\r\n output = pf_menge_out\r\n exceptions\r\n conversion_not_found = 1\r\n input_invalid = 2\r\n material_not_found = 3\r\n meinh_not_found = 4\r\n meins_missing = 5\r\n no_meinh = 6\r\n output_invalid = 7\r\n overflow = 8\r\n others = 9. \r\n endif. \r\nendform.<\/pre>\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Each material in SAP has its standard, base unit of measure (stored in MARA-MEINS). To allow using alternative units, those can be maintained per material in table MARM. A common requirement for ABAPer is to convert material quantity from one … Continue reading