Transfer Selling Price of Sub Item to Main Item

[Former Member]

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.

[Former Member]

Any suggestion???

[moazzam_ali]

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$

[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