Skip to Content
avatar image
Former Member

Transfer Selling Price of Sub Item to Main Item

Dear Experts,

This the requirement of our management, please find the details below.

In our Order BOM Concept,

Main Item:

Which is a Dummy code

i.e. It is Not Inventory Related, Deliverable. But it is Billable and Price Price Related.

Sub Item:

Inventory Related and Billable.(For this requirement, i think we need to maintain as Price related)

In Our company, the main item will have the combination of both Excisable and Non Excisable Material as Sub Item. Please Refer the Below Example.

Line item Hlvl It. Item Code Item.cat

10 0 xxxxxx Main Item

20 10 aaaaaa Sub Item – Excisable

30 10 bbbbb Sub Item – Non Excisable

40 10 cccccc Sub Item – Excisable

50 10 ddddd Sub Item – Non Excisable

The requirement is, whenever the user enters the sub item and maintain selling Price(Basic Price Condition PR00), the selling price of that sub item should get transferred to the respective main item. Please refer the Below Example.

Line item Hlvl It. Item Code Item.cat Selling Price(Condition Type PR00)

10 0 xxxxxx Main Item 100,000.00

20 10 aaaaaa Sub Item – Excisable 1,000.00

30 10 bbbbb Sub Item – Non Excisable 20,000.00

40 10 ccccccc Sub Item – Excisable 50,000.00

50 10 ddddd Sub Item – Non Excisable 29,000.00

In the Above example,

When I enter the main item, the selling price will be 0.00

When I enter first sub item, the selling price of main item will be 0.00 + 1,000.00 = 1,000.00

When I enter second sub item, the selling price of main item will be 1,000.00 + 20,000.00 = 21,000.00

When I enter third sub item, the selling price of main item will be 21,000.00 + 50,000.00 = 71,000.00

When I enter fourth sub item, the selling price of main item will be 71,000.00 + 29,000.00 = 100,000.00

Therefore the accumulated selling price of Main item is 100,000.00. The same should be reflected in Billing.

In the Case of Excise duty, Only the excise duty of excisable Sub item should get transferred to the Main item Excise duty condition. For example,

In our pricing procedure, the excise duties are calculated as percentage from Basic Price(PR00) i.e. selling price.

In the above example of transferring of sub item selling price to main item, the basic price(PR00) i.e. selling is accumulated as 100,000.00. But it also includes the selling price of non-excisable material.

Please refer the below example,

Line item Hlvl It. Item Code Item.cat Selling Price(Condition Type PR00) Excise Duty(Condition Type JEXP)

10 0 xxxx Main Item 100,000.00 120.00 + 6,000.00 = 6,120.00

(It should not be 12% 100,000.00 = 12,000.00)

20 10 aaaaaa Sub Item – Excisable 1,000.00 @12% 120.00

30 10 bbbbb Sub Item – Non Excisable 20,000.00

40 10 ccccccc Sub Item – Excisable 50,000.00 @12% 6,000.00

50 10 ddddd Sub Item – Non Excisable 29,000.00

I was successful in transferring the Cost of Sub items to Main items.

But for this i really confused. Which condition type to use and what formulas are routines to follow.

Dear Experts please guide me to achieve this. If this is not possible kindly explain the reasons so that i can present those reasons in front of my Management.

Regards

Rakesh K.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 06, 2013 at 11:13 AM

    Hi

    I like the way you explained the process but one suggestion is when you need to enter some calculation or table always do that in excel first and from Excel copy table and paste here. It will not distrub the allignment and users like me will be able to understand easily 😊

    You are saying that you are succeeded in transfering cost of sub items to main item. How did you do that? You are talking about selling price which is PR00 not cost which VPRS. Did you transfer PR00 or VPRS and how?? Based on your reply I will be able to comment further.

    Thank$

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks MozzaM, From Next time onwards i will follow the procedure described by you.

      And regarding that i succeeded in transferring cost of sub items to main item.

      You are talking about selling price which is PR00 not cost which VPRS. Did you transfer PR00 or VPRS and how??

      I Transferred VPRS . That is Internal Cost of the material.

      You are saying that you are succeeded in transfering cost of sub items to main item. How did you do that?

      I used the Condition Type KUMU. I did this by referring the following Document.

      http://scn.sap.com/docs/DOC-32501

  • avatar image
    Former Member
    Sep 09, 2013 at 05:43 AM

    Any suggestion???

    Add comment
    10|10000 characters needed characters exceeded