11-17-2006 9:50 AM
Hi,
I need to calculate number of pallets and cases from Qty.
Pallets = QTY * MARM-UMREN / MARM-UMREZ
Now how to calculate the Number of cases in a Pallet?
Pls help
Thanks
Ram
11-17-2006 10:00 AM
no of cases can vary from system to system...U should ask the functional owner what will be the no of cases in a pallet or how to define it.
11-17-2006 10:36 AM
Hi,
Try something like this :
- For a pal :
SELECT SINGLE * FROM marm WHERE matnr = itab-matnr
AND meinh = 'PAL'.
IF sy-subrc EQ 0 AND marm-umrez NE 0.
nb_pal = qty DIV marm-umrez.
nb_car = qty MOD marm-umrez.
- for nb of st in a KAr
SELECT SINGLE * FROM marm WHERE matnr = itab-matnr
AND meinh = 'KAR'.
IF sy-subrc EQ 0 AND marm-umrez NE 0.
nb_car = Qty DIV marm-umrez.
Hope this helps
Erwan
11-17-2006 10:54 AM
Hi
Thanks for the reply.
Pallets = TRUNC( G_QTY_BU * MARM-UMREN / MARM-UMREZ ).
G_REM = G_QTY_BU * MARM-UMREN MOD MARM-UMREZ.
The integer value will be the full pallets and the remainder(G_REM) will be used for the loose cases calculation.
You then multiply the remainder (G_REM) by the number of cases in a pallet (UMREZ) and this will give you the number of loose cases.
Pls let me know if this is correct...............
Thanks
Ram
11-17-2006 10:56 AM
hi
good
go through this links i hope these ll help you to solve your problem
http://help.sap.com/saphelp_nw04/helpdata/en/5f/071eed117c11d5b37d0050dadef62b/content.htm
thanks
mrutyun^