Typewriter TW

April 24, 2015 2 minute read

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

Typewriter

17 Comments

You must be Logged on to comment or reply to a post.

Former Member

April 27, 2015 at 3:25 pm

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 !

Typewriter TW

Blog Post Author

April 27, 2015 at 5:01 pm

Maxime,

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.

Former Member

April 27, 2015 at 6:35 pm

Dear TW,

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.

Thanks

Jose Antonio Martinez

May 28, 2015 at 1:48 pm

Thanks TW.

Since I saw this document I guess will help to solve an issue, and now after tested we implement it succesful.

Regards

Jose Antonio

Mehmet Ozgur Unal

July 28, 2015 at 5:11 pm

Hi Jose ;

Well defined and informative.. Thanks for sharing.

Regards.

M.Ozgur Unal

venu gopal

May 30, 2015 at 7:58 pm

Dear TW,

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 ?

Team Account Competency Centre

January 28, 2022 at 8:05 am

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..,

Suman Sardar

August 3, 2015 at 9:54 am

Hi TW,

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.

Simply great.

Ravi Sankar

August 3, 2015 at 1:53 pm

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.

Phanikumar V L

August 6, 2015 at 12:07 pm

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)

Phanikumar

Pradeep Mani

August 31, 2015 at 6:20 am

Informative..Well explained.

K P

February 13, 2016 at 10:15 am

Hi TW,

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

Prasad S Dev

March 3, 2016 at 5:15 pm

Dear TW,

Thank you so much for the Excellent Informative share..

Regards,

Devi Prasad

p m

February 7, 2018 at 4:50 pm

Dear TW

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.

Thanks

Mehmet Ozgur Unal

February 11, 2020 at 9:59 pm

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 .

Example :

FORM userexit_xkomv_fuellen_o_konp.

*/ 12.02.2020 - M.Ozgur Unal - Ömer Ekşi - ZFC2 Düzenleme

  DATA: lv_tot   TYPE kawrt,
        lv_kwert TYPE kwert,
        lv_kawrt TYPE kawrt,
        lv_oran  TYPE zmm_oran.

  IF sy-tcode(3) EQ 'ME2' AND tkomv[] IS NOT INITIAL.

    LOOP AT tkomv WHERE kschl EQ 'ZFC2' AND kinak EQ ''.
      lv_tot = lv_tot + tkomv-kawrt.
    ENDLOOP.

    IF lv_tot IS NOT INITIAL.
      LOOP AT tkomv ASSIGNING FIELD-SYMBOL(<fs1>)
                    WHERE kschl EQ 'ZFC2'.

        IF tkomv-kinak IS INITIAL .
          TRY.
              lv_kawrt = <fs1>-kawrt.
              CALL FUNCTION 'ZMM_001_KBETR_DONUSUM'
                EXPORTING
                  iv_param1 = lv_kawrt
                  iv_param2 = lv_tot
                IMPORTING
                  ev_oran   = lv_oran.

              lv_kwert = ( <fs1>-kbetr * lv_oran ) / 1000.
              <fs1>-kwert = lv_kwert / 1000000.

            CATCH cx_sy_zerodivide.
            CATCH cx_sy_arithmetic_overflow.
          ENDTRY.
        ENDIF.

      ENDLOOP.
    ENDIF.

    LOOP AT tkomv ASSIGNING FIELD-SYMBOL(<fs2>)
                  WHERE kschl EQ 'ZFC2' AND kinak <> ''.
      <fs2>-kwert = '0.00'.
    ENDLOOP.

  ENDIF.
*/ End of region -> 12.02.2020 - M.Ozgur Unal - Ömer Ekşi - ZFC2 Düzenleme

ENDFORM.

Rohit Bahl

July 21, 2021 at 4:31 pm

Hi TW

Useful Post

Regards

Rohit

Ratnesh Musale

December 7, 2021 at 7:14 am

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.

Regards,

Ratnesh

Header condition type with condition record?

Assigned Tags