topic Re: function module in Application Development and Automation Discussions

function module

Former Member — Tue, 24 Apr 2007 07:03:09 GMT

i want funtion module for the convert the quantity in sales unit into the base unit

and the condition is the retrive the base unit of measure, if the base UOM is not equal to sales UOM..

inputs are the material number and sales unit and quantity

regards

VIjay Pawar

Re: function module

Former Member — Tue, 24 Apr 2007 07:06:23 GMT

better to make use of table MARM .

based on the conversion factor of(UMREZ & UMREN) for a given material

Regards

Prabhu

Re: function module

Former Member — Tue, 24 Apr 2007 07:08:36 GMT

Use the function module

UNIT_CONVERSION_SIMPLE

OR md_convert_material_unit

REWARD IF USEFUL

REGARDS,

Anji

Re: function module

Former Member — Tue, 24 Apr 2007 07:10:11 GMT

Use table MARM.Write a select query based on material number and do the necessary calculations based on fields UMREZ and UMREN.

Plz reward points if answer is helpful.

Thanks.

Chinmay

Re: function module

Former Member — Tue, 24 Apr 2007 07:14:47 GMT

you can get clear picture of this if you go thru MM03

->basic view . here on the application tool bar "additional data" button will be there.

if you click on this, you will see a new screen with different tabs. select "Units of Measure".

here you can see the alternative UOM for each material.

the same values are stored in MARM table.

for example : if Base UOM is EA, then

(for example a material "A", will have these)

1 EA each <=> 1 EA each

1 CAS Case <=> 1 EA each

1 SFC Singles <=> 1 EA each

1 PC Piece <=> 1 EA each

1 KG kg <=> 23 EA each

1 BX Box <=> 80 EA each

1 PAL Pallet <=> 2,880 EA each

from the above picture,

1 box = 80 eaches.

so to get this value in program, go to MARM

pass MATNR & 'BX'.

you will get a record with

UMREZ = 80

& UMREN = 1.

so if you do UMREZ/UMREN, WILL give you the quantity in Alternative UOM. in this case BX.(box).

OR

Use function module MATERIAL_UNIT_CONVERSION.

If you are having simple UOM conversion, you can do something like this.

report zrich_0001.

parameters: p_qtyi type p decimals 2,

p_uomi type t006a-msehi,

p_uomo type t006a-msehi,

p_qtyo type p decimals 2.

at selection-screen.

call function 'UNIT_CONVERSION_SIMPLE'

exporting

input = p_qtyi

NO_TYPE_CHECK = 'X'
ROUND_SIGN = ' '

unit_in = p_uomi

unit_out = p_uomo

importing

ADD_CONST =
DECIMALS =
DENOMINATOR =
NUMERATOR =

output = p_qtyo

EXCEPTIONS
CONVERSION_NOT_FOUND = 1
DIVISION_BY_ZERO = 2
INPUT_INVALID = 3
OUTPUT_INVALID = 4
OVERFLOW = 5
TYPE_INVALID = 6
UNITS_MISSING = 7
UNIT_IN_NOT_FOUND = 8
UNIT_OUT_NOT_FOUND = 9
OTHERS = 10

if sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

Regards,

navjot

reward if helpfull

Message was edited by:

navjot sharma

Message was edited by:

navjot sharma

Re: function module

Former Member — Tue, 24 Apr 2007 07:29:44 GMT

thanks