SD Pricing

[former_member193505]

Hi All,

Please find the attached business problem and kindly give your ideas.

US Client is in computer hardware and in institutional sales. Product line consists of Laptop, desktop, printer etc. The existing process they are using as follows:

Existing process:

• They are having mainly 4 manual condition type, lets for example: ZQA1 and ZQA2 (Item level condition type) and ZQA3 and ZQA4 (Header level condition type).
• To comply with US GAAP rules client created one Condition Type, called ZQ00.
• ZQ00 is a statistical, Header and Manual Condition Type.
• There is a sub total field in the Pricing procedure, which is just taking total of all 4-condition types as mentioned above. ( ZQA1 to ZQA4)
• User needs to copy the value of sub-total field manually and paste it to ZQ00 field.
• ZQ00 is required for re-spreading of discount to the appropriate GL a/c and its also comply with US accounting laws.
• Having said that due to change in sales order line item business needs to re-adjust the ZQ00 every time if any changes happen in sales order (new line item addition/ Quantity Change etc.)

Business Requirement

• Business needs to automate the entire process of ZQ00 addition/deletion related activities.
• It is not a good idea to put the ZQ00 as part of automatic pricing procedure as it can’t has the access sequence/ condition record also.

We understand that it can be achieved through programmatic changes as required. Having said that, we also need to keep in mind that ZQ00 is a manual condition type so far.

Any idea how we can achieve that requirement is appreciated.

Thanks

AB

[jobis]

Hi Arindam,

Why dont you paste the screen shot of your pricing procedure and the condition tab from the sales order header, so that we understand it better and suggest some solution...

Regards

Jobi

[former_member184771]

Dear Arindam,

Can you please re explain the process by taking example in numbers, you can achieve this by standard pricing configuration only.

Thanks.

SS

[former_member193505]

Hi All,

Thanks for reviewing the problem. Please find the attached numerical example for the reference.

Qty : 100 pc

Net Price : 1500 USD

                   Condition type :      Value/ Amount :               Remarks

1.                ZQA1                      5%                            This condition type is item condition/ Manual
2.                ZQA2                      100 USD                  Item condition/ Manual type
3.                ZQA3                       10%                         Header Condition/ Manual type/ distributed proportionately based on total value.
4.                ZQA4                        50 USD                   Header Condition/ Manual type/ distributed proportionately based on total value.

• Lets take for example the sum of above 4 Condition type is USD 400 and the value transferred to a subtotal field G in step no. 100 as Sum of Disc.
• User needs to copy the value of USD 400 as above manually and needs to add another condition type call ZQ00 , which is header/ statistical condition type. And that condition re-spread the discount per with accounting rules to post into the appropriate GL a/c.

Problem : If a new line item needs to add or quantity need to change of any line items then user needs to delete the ZQ00 condition type first because otherwise it will calculate the value wrongly. Then add again ZQ00 after adding the line item. In this case user has to follow the same steps i.e. copy from step no. 100 as Sum of Disc ( Subtotal G) and paste the value to ZQ00.

Requirement : Business needs to automate this ZQ00 addition/ deletion process. So that if user puts the value from sl no. 1 to 4 ( ZQA1 to ZQA4) manually then ZQ00 value should come automatically. No user interfirence should be required for ZQ00 calculation. please keep in mind that ZQ00 is Header condition with Statistical type.

Appreciate your time. 

[former_member184771]

Dear Arindam,

What I understood is: condition type ZQA1, ZQA2, ZQA3, ZQA4 is different pricing component in you calculation and you need to pass the entries calculation in ZQ00.

Why you are not passing the value of step 100 in ZQ00 and make that condition non editable.

Ideally the pricing procedure should be

Basically you need to play with different combination of condition type to reach to you final calculation. Try to minimize the manual input option.

Thanks

SS

[former_member193505]

Hi Sumeet,

I really appreciate your reply ! Can you please explain how you want to pass the value from step 100 to ZQ00.....

And to reply your next advise, I think, manual input for 4 condition type from ZQ01 to ZQ04 can't be minimized as it always requires business inputs for discount based on every orders.

on a same note as mentioned before, ZQ00 is a important condition type from FI perspective as it doing the re-spreading of discounts to the appropriate GL account.

Thanks in advance.

AB

[former_member184771]

Dear AB,

As shown above you are already adding up all the 4 condition in step no. 100 as 10200. Now in step 110 i.e. for condition type: ZQ00 - Put step no 100 in From field of pricing procedure.

Thanks

SS

[former_member193505]

Hi All,

Thanks for the reply. That's the existing set up we already have in the system. But having that,  user need to copy the value from step no. 100 and also need to put the value to step no. 110. Hence as header condition type ZQ00, the value get distributed proportionately. ZQ00 also marked as Manual in pricing procedure.

Now, solution is required by business as follows :

1. ZQ00 need to be automated . Here automation means by business is user need not to touch the condition type ZQ00. It will automatecitally fetch the value from step 100 ( Subtotal). I think its not possible through standard SAP as ZQ00 is a header condition.

Also manual insertion of condition type ZQ00 is at least required ( apart from Value part). If you have any different idea please let me know.

Thanks

AB

[former_member184771]

Dear AB,

Have to tried the step which is suggested by me earlier post?

Thanks

SS

[vidyasagar24]

Have you tried to put From to To field by combing all four conditions in pricing procedure