Split item and conduct pricing for each line item

[Former Member]

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 ?

[Former Member · Accepted solution]

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

[Former Member]

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 !!

[reazuddin_md]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Venkat,

Can you tell me the step by step procedure please.

[Former Member]

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

[Former Member]

Hi Pavan,

Did you manage to split the line item. I have the same scenario but need to split with batch numbers.

I tried to spli xvbap in USEREXIT_MOVE_FIELD_TO_VBAP but cannot get the result.

Can you please share with me the codes which can append the new line item.

Thanks in advance.