on 04-05-2007 6:36 AM
Hi Gurus,
I have a requirement wherein I need to split the item in a sales order based on quantity.
For example: If the material quantity is over 50, it should create a new line item for the same material for the remaining quantity.
Material ABCD Quantity 65
Should appear as
Material ABCD Quantity 50
Material ABCD Quantity 15
In the sales order
Can we do this ?
Hi,
The line item qty's cannot be split. Use scales to have a different pricing. This can be given in Pricing cond records VK11.
Reward if it helped!
Chandru
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
pavan, if u want to split line item based on quantity then ,probably this can be achieved thru abap route.
u have to write bbusiness logic for splitting in MV45AFZZ .
reward if helps !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavan ,
have understood ur requirement.
but can u tell me why u want to split the item for a specied quantity.
if u want to give it for only pricing.
it can be done at create condition record level itself.
eg: as per ur eg,
material X - 65 ea,
pricing should take for first 50 ea,
then in second line for the rest of 15 ea,,
ist so?
it can be done in condition type itself.
goto V/06- condition type details,PR00(if u want to give diff pricing upto a specified qtty), -scales--scale type- D (Graduated to interval scale)
& save it.
Now create condition record for PR00 in Vk11,
choose ur key combination,
while maintainuing scales, maintain the range as
upto 50 ea -
$1000
upto 100 ea -
$ 900
n so on,
now whenever u create order for that specific material,
now ur order qtty is 65,
in item conditions u ll get the price in 2 line items,
1) PR00 -- 50 qtty -- 50*1000 = $ 50,000
2) PR-00--15 qtty -
15-900 = $ 4,500
in Market,
this is known as slab rates , which is used widely in Electricity bills, as per the consumption base will get the bill amount. ( u can chek out the backside of any electricy bill )
But no different line item will appear in sales overview as u said,in ur post.
it can be seen only at item conditions level.
*Hope this will def solve ur issue
*Provide reward points,if u convinced
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
Thanks for the reply. Below is my requirement.
Generally the full pallet is billed in less than the standard price and half pallet is billed at regular price.
Line1: Material Full Pallet (50) -
100 $ -
Payment Term 1
Line2: Material - Half Pallet (25) - -
55 $ -
Payment Term 2
When we enter Material quantity as 75 & SAP should split the material into two line items 50 qty line 1 & 25 qty line 2
The order should be derive the price (reduced = 100 $) for the full pallet and half pallet price (55$) automatically
Any help would be much appreciated.
Thank you
Hi Pawan,
This can be achieved only by activating the user exits in MV45AFZZ.
You can do it by activating this user exit USEREXIT_MOVE_FIELD_TO_VBAP and by maintaining graduated scales in Pricing.
For your scenario your should do the both.
USEREXIT_MOVE_FIELD_TO_VBAP - For Splitting the Line item.
Graduated Scales - For maintaining pricing.
Award points if useful.
Thanks,
Venkat
Hi Pawan,
For splitting the line item:
Go to SE38 - display the prog MV45AFZZ
Code according to your requirements in USEREXIT_MOVE_FIELD_TO_VBAP.
But this is a technical consultant's work.
For Maintaining Graduated Scales, follow the step which Raj had already explained.
Please get back to me if you need more info.
Thanks
Venkat
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.