Skip to end of metadata
Go to start of metadata

What do we need to know?

Dates:-

Order Date

 Date on which the sales order is entered. System proposes the current date by default.

Material Availability Date

 The date on which the material must be available. On the material availability date, the vendor must start the activities relevant for delivery, such as picking and packing the goods. The material availability date must be sufficiently early enough so that the goods are prepared by the loading date.

Transportation Planning Date

 We must arrange transportation by this date, so that the delivery can be sent to the customer. The date from which the organization of goods transport must begin. The transportation planning date must be selected early enough so that the transport is available on the loading date to load the goods.

Loading Date

Picking and packing must be completed by this date so that the goods are ready for loading.

Goods Issue Date

 Goods must physically leave the shipping point by this date. The date on which the goods must leave the company to arrive at the customer location in time.
 

Delivery Date

Customer should receive delivery of the goods by this date. The date on which goods are to arrive at the customer's premises. Example: The delivery date can be the delivery date requested by the customer (desired delivery date) or the date confirmed in the vendor's order acknowledgment or shipping confirmation (confirmed or acknowledged delivery date).

Times:-

Pick/Pack Time

 Difference between the material availability date and loading date.

Transportation Lead Time

 Number of days required for organizing a shipment for an item to be delivered.

Loading Time

 Difference between loading date and goods issue date.

Transit Time

 Number of days required for delivering an item from your company to the customer via a certain route.

How do we View Availability Situation?

Run Transaction: CO09

Enter Plant & Checking Rule, against which the Availability is to be checked. For Sales Order Checking Rule = A, Delivery = B, Back Order = BO

 

In this screen, we can see:

  • Availability Checking Group (Avail Check): 02
  • Check Rule : A
  • End Lead Time Refers to the end of Replenishment Lead Time. If that is not included in the Configuration, then this field is not visible.
  • Totals Display:** Receipts = Sum of all +ve Quantities in Rec./Reqd qty Column
    (Leave out the last row, MRP Element 001, since it is a total)
    These are all the Planned Incoming Movements
    • Issues = Sum of all -ve Quantities in Rec./Reqd qty Column
      These are all the Planned Outgoing Movements
    • Confirmed issues = Sum of all (+ve) Quantities in Confirmed Column
      These are the confirmations against ATP.

When is Availability Check Triggered?

While creating a Sales Order, Production Order, Delivery, etc. Below is a screen from Sales Order. At the bottom is a button for Check Material Availability. Also while creating the order, if the Availability situation cannot meet the requested delivery date, the system goes to Availability screen automatically. (Discussed later)
Run Transaction: VA01

How we arrive at a Confirmed Delivery Date?

Below is the logic the system uses to check availability:

  • Using the Scheduling data from Delivery & Transportation Scheduling, the system does the backward calculation from the Requested Delivery Date. This is used to arrive at Material Availability Date.
  • On the Material Availability Date, system checks the Available Qty, as seen in CO09 in column Cum. ATP Qty. If the Available Qty is > than Required Qty, Requested Delivery Date is confirmed. Otherwise,
  • System moves into the future till it finds the required Available Qty. The new date is then the new Material Availability Date.
  • On getting the confirmed Material Availability Date, system does the Forward Scheduling to arrive at a Confirmed Delivery date.

Backwards Scheduling


Control of Availability Check

 


Forward Scheduling

 

Result of Availability Check: Some Sample Scenarios


Above is the Availability Screen as seen in Sales Order. It has following Buttons:

One-time delivery

In the results of Availability, we have 3 options to choose from. This is Case 1, when we can confirm the Customer's Requested delivery Date. The details of this are visible in the first sub screen below.

Complete dlv.

This is Case 2, when we can confirm the Customer's Requested complete delivery at a future Date. The details of this are visible in the second sub screen below.

Delivery proposal

This is Case 3, when we can confirm the Customer's Requested delivery in partial quantities at future dates. The details of this are visible in the third sub screen below.

Continue

If we select one of the above options, the same gets saved in the ATP results. Otherwise, we can select this button. In that case, system leaves the ATP screen without saving the ATP results.

Case: Confirmation on Requested Delivery Date



Case: Confirmation after Requested Delivery Date (Complete Delivery)

Case: Confirmation after Requested Delivery Date (Partial Delivery)



See the screens below corresponding to this situation.

The first screen shows the Availability (CO09) Overview. We have an incoming PO on 19 Jan.
!image034.jpg!In the second screen

We have created a SO (VA01) on 09 Feb, with requested Delivery date for 09 Feb.

Now we change the Availability situation, by changing the PO Date to 12 Feb. See the screens below corresponding to this situation.

The first screen shows the Availability (CO09) Overview. We have an incoming PO on 12 Feb. See the new Cum ATP qty. date wise accordingly.


!image038.jpg!In the second screen
We have created a SO on 09 Feb, with requested Delivery date for 09 Feb.
See that the Delivery got staggered according to the new Availability situation.



Case: Confirmation after Requested Delivery Date (Replenishment Lead Time)



In the screens below, we have simulated the RLT.
In the first scenario RLT is not activated, see below: 'Check without RLT'. The system considers only the confirmed inward movements. So out of 500 only 21 is confirmed.
See IMG Guide > SD > BF > AC & TOR > AC > AC with ATP > Control of Availability Check


See VA01


 

In the second scenario RLT is activated, but corresponding data in material master is not maintained. Material is procured In-House (E), but In-house Production time (1st screenshot) & RLT (2nd screenshot) are not maintained. The system assumes both these times as Zero. So, complete 500 are confirmed immediately. See MM01


 

 In the third scenario RLT is activated, corresponding data in material master is maintained. Material is procured In-House (E), In-house Production time (10 days) & RLT (not maintained). The system confirms 21 on basis of incoming material. Rest 479 is confirmed after 14 days. This is because 10 working days for in-house production + 4 holidays (Sat-Sun).


 

 

In the fourth scenario RLT is activated, corresponding data in material master is maintained. Material is procured In-House (E), In-house Production time (10 days) & RLT (20 days). The system confirms 21 on basis of incoming material. Rest 479 is confirmed after 14 days. This is because 20 working days for in-house production + 8 holidays (Sat-Sun).



What Configuration & Data do we need?

Controlling Elements:-

Requirements Type

Requirements Class

Schedule Line Category

Delivery Item Category

Checking Group

Checking Rule

Scope of Check

Strategy Group

Partial Delivery Agreement

Replenishment Lead Time

Material Master Data:-

MRP 1 > MRP Group

MRP 2 > Planned Delivery Time

MRP 2 > GR Processing Time

MRP 3 > Checking Group for Availability Check

MRP 3 > Strategy Group

MRP 3 > Total Replenishment Lead Time 

Scheduling Data:-

Transit Time

Loading Time

Pick/Pack Time

Transportation Planning Lead Time


  • No labels

6 Comments

  1. Unknown User (j2vdyyz)

    Hi Manu,

     Appreciate if you can provide some of the missing images as follows:

    !image034.jpg

    !image038.jpg

    See the screens below corresponding to this situation.

    The first screen shows the Availability (CO09) Overview. We have an incoming PO on 19 Jan.
    !image034.jpg!In the second screen

    We have created a SO (VA01) on 09 Feb, with requested Delivery date for 09 Feb.

    Now we change the Availability situation, by changing the PO Date to 12 Feb. See the screens below corresponding to this situation.

    The first screen shows the Availability (CO09) Overview. We have an incoming PO on 12 Feb. See the new Cum ATP qty. date wise accordingly.


    !image038.jpg!In the second screen

  2. Former Member

    Nice Work, Thansk

     

    Just one question... Is there any other report or any other way (Maybe a function) that we can use to extract this information...

    I'm having a requiriment to export CO09 to Excel, but the developer says that there isn't exits or BADIs to do that. I do some google and research and get a lot of functions for MD04 and similar but nothing close to CO09, please can you help me?

     

    Thanks

  3. Superb Contribution....Thank you.

  4. Former Member

    @ Ricardo Wey-Choi Leon Chiang

    Dear,

     

    did you get any answer to your question? I'm searching for similar link, and having the same problem..

     

    Sincerely,

    Lea

  5. Former Member

    I dont know your exact requirement, but

    I only found this BAPI_MATERIAL_AVAILABILITY in a post like this one https://blogs.sap.com/2007/04/26/function-module-bapimaterialavailability/

    in my case we ended up doing a copy of the standart....