Pricing of Material based on another material in sales document

[Former Member]

Hi

We have a requirement that the price of one material in sales document would depend upon the price of another material in Sales Document.

Say I have Material A whose price is 15000 USD in sales Document SALESDOC1 (determined thru pricing).
       I have another material  B (subitem of A) in sales document. Price of this material depends upon price of A.

If i have Quantity of 1 for B. The price of B is = (15000) / 4 i.e Price of A / 4

If i have Quantity of 2 for B. The price of B is = (15000) / 10    Price of A / 10

If i have Quantity of 3 for B. The price of B is = (15000) / 20    Price of A / 20

I know that I can achieve this by writing a Alt Condtion Type formula and can read price of Material A and then apply some calculation.

But, I m looking if there is way without writing down any formula.

Please let me know if there is a standard way to achieve this.

Thanks
Manish

[former_member182378]

In a sales order, at item level which is for material B, how shall the system know the price of material A, to do further calculation?

Is the price of material A fixed over time? e.g. 15000 like you have mentioned above.

Or to get the price of A, system has to get to PR00 of material A?

As of now, I donot think this can be achieved with standard configuration.