Exclude holidays in requirement date calculation for Subcr. component
I would really appreciate if someone could help me with this requirement.
To make the calculation of Requirement Date for Subcontracting component exclude holidays.
Assembly Material 'A' with Planned delivery lead time of 7 Days.
Material 'B' is a Component for Assembly Material 'A'.
Subcontracting Scheduling agreement is created for Assembly Material 'A'.
When MRP creates a delivery line for Assembly Material 'A', the component's Requirement Date (the date on which the component material is supplied to the vendor) is calculated as follows.
Requirement Date of Component material 'B' = Delivery date of Assembly Material 'A' - Planned delivery lead time of Material 'A'.
The problem is that this calculation takes even Saturdays and Sundays into consideration. We want the system to exclude holidays from the calculation (based on any factory calender).
For example, if the planned delivery time is 7 days and the delivery date for the assembly is 14.06.2011, system calculates the component requirement dateas 07.06.2011 This calculation is including Saturday and Sunday (11th and 12th).
Is there any way to change this using any configuration or badi/exit so that the calculation will exclude the holidays maintained in factory calendar?