Pricing condition

[Former Member]

Hi,

We have requirement where we have five different fields in material master to build a condition record. Each five fields refer to different condition record value. But we would like to show final condition value based on all five different value once in sales order pricing with condition type.

Example:

Material master data

Material field1 = 5

Material field 2= 6

Material field 3 = 7

Material field 4 = 8

Material field 5 = 9

Now we will have VK11 five records for these five values

For field 1 = $5.5

For field 2 = $6.5

For field 3 = $7.5

For field 4= $8.5

For field 5 = $9.5

Now finaly sales order pricing should have one condition showing final value ( 5.51+6.527.5*38.54+9.53) = 5.51322.53428.5 = 103.5

Please advise ideas to acheive this.

Thanks

[reazuddin_md]

What is your actual requirement?

Is Material field1 refers to "Material Group1" in MMR?

Example should have more clear, what is order qtty, How did you maintain condition recrods with entries?

What you want to achieve?

Answers to above all queries helpful to suggest input.

Regards,

Reazuddin MD

[Former Member]

Material master Z field data

Z Material field (perimeter type 1) = 5

Z Material field (perimeter type 2)= 6

Z Material field (perimeter type 3)= 7

Z Material field (perimeter type 4) = 8

Z Material field( perimeter type 5) = 9

Now we will have VK11 five records for these five values ( belong to same condition type)

Access sequence -

---

Customer/ Z Material field (perimeter type 1) = $5.5

Access sequence -

---

Customer/ Z Material field (perimeter type 2)= $6.5

Access sequence -

---

Customer/ Z Material field (perimeter type 3) = $7.5

Access sequence -

---

Customer/ Z Material field (perimeter type 4)= $8.5

Access sequence -

---

Customer/ Z Material field (perimeter type 5) = $9.5

Once the condition value found it should be times another Z field value from same material master as below

(All these both kind of Z field belong to same material for a order)

Now finaly sales order pricing should have one condition showing final value ( 5.51+ 6.52+ 7.53+ 8.54+ 9.5*3) = 5.51322.53428.5 = 103.5

I am thinking to maintain one condition type with above access sequence and lets say all five Z field has value in sales order material than code should read all the 5 records from respective access sequence table and times it with another respective five Z field value respectively and finaly add them together to dispaly final value in sales order for the condition type.

Please advise if maintaining five access record for one condition type and then get the logic driven from routine would be only way or do we have some standard way to achieve this.

Requirement - Need to show only one condition in sales order pertaining to various price posibility depending on five Z fields.

Thanks

[reazuddin_md]

I would rather suggest you to go with the Customized table to maintain Zfields instead to maintain in Material Master Record.

- If you already maintained Zfields in MMR, then create Ztable & maintain condition records in it.

eg: Ztable:

Customer + Material + Zfields = Amount / Rate

write a routine with the calcuation logic & assign this routine in price condition. it is as good as saying that maintaining condtion record in Ztable instead of VK11.

Hope it helps,

Regards,

Reazuddin MD

[Former Member]

Yes thanks that is correct may be reading seperate Z table and maintaing would be additional task and training so thought use access sequence 9XX tables to store data even though it would not utilise condition access sequence strategy.

Wanted to confirm if these are only two option available.

[reazuddin_md]

My suggestion would be to use Ztable instead disturbing the Master data screens.

- Fetching data also easy & maintanance of data can be given to authorized users only.

-Condition Master data maintanance will be huge.

- Better to have upload functionality ( eg: LSMW) to maintain entries.

Hope it adds info.

Regards,

Reazuddin MD

[Former Member]

Thanks for the tips

[Former Member]

I will assign marks