Header condition type with condition record?
There is some confusion – In a sales order, can header condition type value be entered manually only? Can an access sequence be assigned to a header condition type? Can condition record be maintained for a header condition type? http://scn.sap.com/thread/359898
Business requirement: “requirement of referral bonus. A one time $100 bonus to customer irrespective of material or order type. The best way i found was to create a condition record for customer master against a discount condition type.” This requirement is from http://scn.sap.com/thread/3726747
As in the above requirement, some business scenarios require that a header discount or surcharge populate automatically in the sales order when some criteria are met. This discount should be applicable for the entire order and it should not be duplicated in every item.
So to populate a condition type automatically we need a condition record. For header condition type can we maintain condition records?
Can access sequence be assigned to a header condition type? Yes
In Condition type V/06, there are two fields Header condition, Item condition; as explained in the note, it does not imply that for header condition type one needs to activate Header condition field and leave Item condition field blank.
OSS note 17217 No access sequences for header conditions is beneficial.
“You do not classify a condition as a header or item condition by selecting the above fields but rather by selecting the key fields for this condition which you will find either at header level (for example, customer) or at header and item level (division).
Note: If you check both the above fields, the system does not display the error message.”
If we select Header condition and keep Item condition blank, system will not allow to assign access sequence. As the note suggests both fields should be activated, with this setting the condition records can be created.
Both fields activated: Header and Item conditions; access sequence maintained
VK13, condition record maintained. Note: As the note suggests choose order header level fields
Header discount condition value populating automatically because condition record is maintained and this value is not duplicated because Group condition field is activated
VA01, sales order created with 2 line items. Expected result is to get a header discount of 10 EUR
Item level: This header discount is not duplicated. It is distributed proportionate to the quantity in each line item; because of group condition functionality
Is there a way to prevent the amount to be distributed to the line items ?
Because if at the outbound delivery the picked / delivered quantity is changed - the invoice will not have the same amount !
By changing the quantity in delivery, I do not think the header condition type value will change in the billing document.
The header condition type value comes from the condition record; next step this gets proportionally distributed among the line items; and not the other way round. Even if the quantity changes, this header will remain the same.
Well I'm asking this precisely because that's how the system reacts within our system and I did some test about that situationrecently. The amount is distributed to line items at sales order creation. According to the configuration we have here, the prices are not re-determined when copying from sales order to delivery to invoice. - So what happens is that the distributed amount is updated by the new quantity when the invoice is created.
The difference from your example is that we don't have a condition record because the request was to always manually input an amount at header level.
Since I saw this document I guess will help to solve an issue, and now after tested we implement it succesful.
Hi Jose ;
Well defined and informative.. Thanks for sharing.
Thank you so much for sharing your innovative thoughts 🙂
But I have known about header condition if we maintain condition record it will update the wrong amount some time in sales order
Is it correct ?
Thats right. The condition type behaves strangly when its both Header and item condition. There is no solution i found till today. It gets duplicated sometimes and distributes incorrect values, etc..,
Thanks for sharing this.
I think the major important part is not to be duplicated is controlled by Group condition which we normally do for such condition types.
Now the beauty is to make it available for header and we are getting the solution for the header condition with condition records.
Similar to distribution of value based on line item quantities, please add, how to distribute proportionately based on the line item values. Because, in this process a line item that has a quantity of 99 EA with total value of 9.9 Euros gets 9 Euros discount and the line item that has a quantity of 1 EA with value of 100 Euros will get 0.1 Euro discount.
Good & Informative.
I think this was not new-Because already standard condition type WK00 will have both Header&Item Conditions active at V/06(But without Acc.Seq).
Really Interested to know--the Condition record received at Header should divide the Total value to line items """NOT ON QTY-BUT ON VALUE"""(Recently we want this But dropped due to some other reasons)
Dear TW-Can you provide some SAP note numbers on this...(we can google-But your Practical experience Can add some more important things)
Thanks for the informative document.
We have created a similar condition type except that the condition category is Freight.
At times we wanted to enter this condition manually(when condition record did not exist) in sales order, which we were able to do successfully and the amount got distributed proportionally among the items.
However when we created a Invoice wrt order the condition had a value zero and it did not copy the manual value which we had entered in order.
refer a serperate dicussion created with reference to this
Manual freight Header condition - Copy Control ... | SCN
Thank you so much for the Excellent Informative share..
What would we do for a similar scenario where condition update flag is checked on the condition type defenition, we maintain the condition record with out amount (manually entered in SO) and condition record has a maxmimum condition value set. We want to give the user to enter the discount amount manually but set a limit on how much he/she could give out with in a time frame (condition record validity) for a combination ( access sequence).
So the amount entered will be split between the lines but this amount will be captured in a bucket like cumulative value and error when the toatl limit given away reached the limit.
Hi Typewriter TW ,
I tried to benefit from this functionality but is not ok in material management purchasing side.
That's why we used user-exit RV61AFZB .
Thank you Typewriter TW
for a useful post. But i am still facing problem in my calculation my data calculated on item level, I should want this data calculate by header level scale basis.