Weight Update During Outbound Delivery
We want to incorporate following scenario in SAP to meet the business requirement:
For an configurable product(In house Manufactured) Qty., weight and volume will be updated manully during inbound delivery creation and these data is saved in VEPO & VEKP tables respectivily. The same Qty., weight and volume should be copied during outbound delivery creation(the required selction data are maintained in programme).
Now, the system is correctly updating the Qty.,Weight & volume, only if the sale order & the qty.in VEPO table are same ( Example: Sale Order Qty is 10 Nos. and the inbound deliveries (against sale order) Qty. is 10) If the same is not matching then system dividing the weight & voulme by the sale order Qty & multipling with the VEPO table Qty.
Sale Order Quantity : 10 Nos.
Weight in VEKP table: 1000 Kgs
Volume in VEKP table : 1000 MM3
Qty.in VEPO table : 05 Nos.
The correct weight & volume for 05 nos is 1000 KGS & 1000MM3 respectivily. Where as in out bound delivery system shows 500KGS & 500MM3.
System calculating the Values in following manner:
OBD Weight = 1000(KGS) / 10(qty In SO) * 05(Qty.in OBD)
OBD Volume = 1000(MM3) / 10(qty In SO) * 05(Qty.in OBD)
Hope my requirement is clear and I need your guidance in fixing this issue.
Thanks in Advance