Controlling Free Goods Quantity in Delivery Document

February 26, 2013 | 758 Views |

Jignesh Mehta

SAP ERP enterprise resource planning sap erp sales and distribution

Free Goods determination happens in Sales Order based on Free Goods Condition Records maintain in T-Code VBN1.

Now while creating Delivery, system just copies the Main Item quantity & Free Goods Item Quantity from Sales Order & does not access the Free Goods condition again.

In case of complete (single) Delivery for one Sales Order, there is no problem because full quantity of main & free item is delivered at one go.

But let us imagine a scenario where partial deliveries are done.

For Example, say in a Sales Order:

Main Item – 100 Tons

Free Item – 10 Tons

Delivery:

Main Item – 50 Tons (system proposes 100 Tons, which is reduced to 50 Tons)

Free Item – 10 Tons (system does not reduce the Free Goods proportionately)

As seen above, system does not reduce the Free Goods quantity even if the Main Item quantity is reduced in Delivery.

To control this situation SAP System has given following options to control partial Deliveries (to be maintained in under “Free Goods delivery Control” VBN1 Condition Record):

– Delivery takes place regardless of main item

A – Delivery only if main item is partially delivered

B – Delivery only if main item is fully delivered

C – Delivery if main item is part. delivered, only with main itm

E – Delivery proportional to quantity in main item

Normally E “- Delivery proportional to quantity in main item” is maintained to ensure that any reduction to main item will make proportionate reduction in Free Items. But the Main Item & Free Item quantity field is modifiable & user can further increase the Free Goods Item quantity to Sales Order Free Goods quantity.

To control the above, we have recently made the Free Goods Item Quantity Non-Modifiable in Delivery document by inserting a ABAP code in Badi – LE_SHP_DELIVERY_PROC.

ABAP Code:

METHOD if_ex_le_shp_delivery_proc~change_field_attributes.
….       sy-tcode = ‘VL01N’ OR sy-tcode = ‘VL02N’.
      ….         IF screen-name = ‘LIPSD-G_LFIMG’.
                         IF is_lips-pstyv = ‘TANN’.
            screen-input = 0.
            screen-active = 1.
                 ……
ENDMETHOD.

This will ensure that the Free Good Item in Delivery Document is Non-Modifiable & any reduction to Main Item quantity will reduce the Free Item Quantity proportionately, which cannot be changed by the users.

To report this post you need to login first.

21 Comments

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

' MoazzaM ' February 26, 2013 at 9:34 am

Dear Jignesh Mehta

Thanks for sharing this valuable information.

like (0)
1. Jignesh Mehta Post authorFebruary 26, 2013 at 11:20 am
  
  Hello Mozzam,
  
  Thank you for the appreciation.
  
  like (0)
Former Member February 26, 2013 at 9:29 pm

Hi Jignesh,

Very use full document ,, thank`s for sharing 🙂 🙂

like (0)
Former Member February 27, 2013 at 1:46 am

Dear jiginesh sir,,, you have shared very good document

sir really i like your way of interest to share your knowledge and it motivates small fishes like me …. 🙂 have a good day

like (0)
Former Member February 27, 2013 at 3:52 am

Dear,

May I know ,Is this Process is What ? ( Inclusive or Exclusive ) .

Delivery proportional to Quantity in Main Item means If we maintain Main Item 100 in sale order and then we will be decreased to 50 in Delivery so Free Good Item also automatically will be decreased 10 to 5 in Delivery right .

Thanks,

Naren

like (0)
1. Jignesh Mehta Post authorFebruary 27, 2013 at 4:55 am
  
  Hello Narendra,
  
  Yes. In Delivery the Free Good quantity will be proportionately reduced, but the Free Goods Quantity field in Delivery is modifiable. Which means that user can increase the 5 quantity to 10 Quantity & post PGI. Which is incorrect because if the Main Item is reduced from 100 to 50 then Free Item should not be allowed to be increased from 5 to 10.
  
  Thanks,
  
  Jignesh Mheta
  
  like (0)
  1. Former Member February 27, 2013 at 5:24 am
    
    Dear Mr.Mehta,
    
    Ur inputs in SD query are really very useful. Free units modification ABAP query note sent has solved one of our long term problem.
    
    Rgds
    
    Anita
    
    like (0)
    1. Jignesh Mehta Post authorFebruary 27, 2013 at 6:05 am
      
      Thank you for your appreciation, Anita.
      
      like (0)
      1. Former Member February 27, 2013 at 10:49 am
        
        one more doubt, if it in the case of different exclusive free goods? if it is for inclusive then? have some patience on my doubts.
        
        warm regards,
        
        jagdeesh
        
        like (0)
        
        Jignesh Mehta Post authorFebruary 27, 2013 at 11:14 am
        
        Hello,
        
        See this is all about Controlling Free Goods Quantity in Delivery.
        
        Now as Free Goods are not re-determined in Delivery Doucment, this applies to partial deliveries in both inclusive & exclusive Free Goods.
        
        Thanks,
        
        like (0)
  2. Former Member February 27, 2013 at 10:44 am
    
    hi,
    
    its great and wonderful but i have one doubt…is it for partial delivery only right? you mean after avilablity check stock balance only 50 for for main item right? is it right? tell me the business case where you have faced in your project?
    
    warm regards,
    
    jagadeesh
    
    like (0)
    1. Jignesh Mehta Post authorFebruary 27, 2013 at 11:09 am
      
      Hello Jagadeesh,
      
      Yes. This is more for Partial Deliveries. Once again think of below scenario:
      
      Order:
      
      Main Item – 100 Tons
      
      Free Goods – 10 Tons
      
      Delivery:
      
      Main Item – 50 Tons
      
      Free Gods – 5 Tons (reduced proportionately by setting of E in VBN1).
      
      But as the Free Item Quantity is modifiable, use can increase the quantity of Free Goods from 5 to 10. This is not correct.
      
      Ideally Free Goods quantity should be non-modifiable in Delivery just as in Sales Order.
      
      Thanks,
      
      like (0)
      1. Former Member February 28, 2013 at 3:42 pm
        
        Hi jignesh,
        
        thanks for you patience, you have really passion to excel.
        
        warm regards,
        
        jagadeesh
        
        like (0)
        
        Jignesh Mehta Post authorMarch 4, 2013 at 11:14 am
        
        Thank you for the appreciation, Jagadeesh
        
        like (0)
  3. Former Member March 4, 2013 at 11:43 am
    
    Dear,
    
    When ever Main Item Quantity decreased in delivery from 100 to 50 the Free Goods will be Decreased from 10 to 5 .In this case ,when ever User going to decrease Free Goods Quantity then ,what about Main Item Quantity ? Is this Main Item Quantity will be Constant ?
    
    Note : Before ,I have asked as What is this process ( Inclusive or Exclusive ) ?
    
    Main Item = Free Good Item ( Proportionately changing equally )
    
    Thanks,
    
    Naren
    
    like (0)
Former Member February 27, 2013 at 11:16 am

Hi Jignesh,

What an explanation ..!!!!

Clear, precise and easily understandable.Great .

like (0)
1. Jignesh Mehta Post authorFebruary 28, 2013 at 12:18 pm
  
  Thank you Suresh
  
  like (0)
Former Member February 4, 2017 at 5:32 am

Hi Jignesh,

Thanks for sharing use full document, this is my first comment in SCN.

I have some issue regard Free good (Exclusive). I created condition record where customer buys material ‘A’ of 20 units and he will get free 10 unit of material ‘B’.

I created sales order with material ‘A’ 20 units and system determine free 10 unit of material ‘B’.

But we do have stock for material ‘A’ as 10 units only, so when I create OBD for SO, system generate line item with Material ‘A’ 10 unit and second line item for material ‘B’ 10 as free (as in SO free good determined as 20 + 10).

I want system should only deliver 10 qty of material ‘A’ and 5 qty of material ‘B’ as free, for this I maintain “E – Delivery proportional to quantity in main item” in condition record for Free goods delivery control.

But OBD still generate with 10 qty of ‘A’ & 10 qty of ‘B’. I do not want to change condition record material combination.

Please guide me, if I am doing something wrong.

I tried to search in SCN & Google, but did not found any solution.

Thanks in advance.

Regards

Jayant

like (0)
1. Jignesh Mehta Post authorFebruary 6, 2017 at 3:18 pm
  
  Hello Jayant,
  
  You may need a small enhancement in Sales Order user exit to check the main item availability and adjust the free good accordingly.
  
  Thanks,
  
  Jignesh Mehta
  
  like (0)
  1. Former Member February 7, 2017 at 9:45 am
    
    Hi Jignesh,
    
    Thanks for reply.
    
    I will check with my abaper.
    
    Regards
    
    Jayant 🙂
    
    like (0)
Former Member February 4, 2017 at 7:40 am

In Delivery the Free Good quantity will be proportionately reduced, but the Free Goods Quantity field in Delivery is modifiable. Which means that user can increase the 5 quantity to 10 Quantity & post PGI. Which is incorrect because if the Main Item is reduced from 100 to 50 then Free Item should not be allowed to be increased from 5 to 10.

hi Jignesh.. pls check the same settings if possible through copy controls…bcz once we faced issue as our client needed that price should be modified till delivery but not in invoice. Generally we can keep price modifiable in all phases that is SO, Del and Inv or neither of them through v/06

But this was achieved through copy control. In VTFL we have changed “Pricing Type” G= Copy pricing elements unchanged and redetermine taxes

to

E =Adopt price components and fix values

Hence in invoice price was fix and not modifiable….

like (0)