2006 Dec 29 10:44 AM
hi all
I've developed one report for delivery report. In that i want one field (Pick Quantity)
from VL01n --- Picking tab ---Pick Quantity field. let me know which table and field store in that field (Picking quantity). pls help me
2006 Dec 29 11:20 AM
2006 Dec 29 11:27 AM
2006 Dec 29 11:35 AM
2006 Dec 29 11:59 AM
U need to understand one thing .
Pick quantity is not maintained for the table . The reference for this is the Delivered Quantity.
Goto delivery (vl02n) and enter a delivery now see the delivery qty for a particular item .
say 16 for Del qty now keep pick qty as 0.
and save .
now see the over all pick status . this will be 'A'.
repeat the same process and now keep pick qty as 4 .
and save .
now see the over all pick status . this will be 'B'.
this becomes 'C' means completely picked if the pick qty is eq 16 in this scenario.
i cannot pick 17 as this is out of scope error will be triggered.
so pick qty as such is not maintained and the reference field is delivery qty.
pick qty is not referred anywhere in the tables.
so reference field for this is LFIMG.
regards,
vijay.
2006 Dec 29 12:06 PM
hi vijay
I know but i want pick qty, u mentioned u r mail see pick qty. s 4, thats only i want. 4 is store which table or field?
2006 Dec 29 12:16 PM
You will not find that 4 in any table .
Let me put it this way.
The process is suppose a sales order is there and that is scheduled
16 on dec 29
24 on dec 30
if i create a delivery as of today ie dec 29 then the pick qty is 16
and i create a delivery on dec 30 ie tommow then the pick qty is 24.
total quantity for that item is 40 (break 16+24).
For this break up u need to look into Vbep Entries .
This is the process of scheduling where in two deliveries are created for one sales order .(as example).You can seek functional help in this regard it will be clear to you.
Pick qty will be important only at the time of using a BDC where i need to maintian this field and comaring this with delivered qty the item is closed.
Pick and pack qty are referred to LFIMG.
So pick qty is referred to field LFIMG .
Explore about this still and you will understand .
regards,
vijay