Point of Time Table

Point of time table is a time table containing planning points specified in days, hours, and minutes. The table type determines how the time table is used. The table defines how to group orders into time buckets, affecting the planning dates of planned orders, the requested delivery date of planning purchase order, the generation of forecast pacing items and the expiration date of lot item when received.

Time tables are created in 'Point of Time Table. Open' (RPS080). When defining a time table, you can use facility, warehouse, and table type to control the extent of its validity. This means that the same time table ID can be used in different situations and have different settings. To define a time table:

The time table for a specific point of time type is displayed in (RPS081). The date buckets can be generated monthly, weekly, or daily depending on the cycle days and day defined in (RPS080).

Maintaining Point of Time Table

Point of time table is maintained in programs where functions and setup are described.

A. Create point of time table

Point of time table is created in 'Point of Time Table. Open' (RPS080). This table shows the settings to be defined to maintain the time table:
Program/Panel Field The field indicates...
(RPS080/B1) Facility ...the facility used.
  Warehouse ...the warehouse ID.
  Point of time type ...the time type contained in the table.

The valid alternatives are:

10 = is used to total the requirements when order policy 15 is used in MRP. All the demands between two point in times are grouped together to be in one supply order.

In 'Item. Connect Warehouse' (MMS002), the order policy 15 is used and point of time table to be used to set. The placement of planned order is controlled by parameter 425 Proposed time for order policy 15 in 'Planning Policy. Open' (MMS037).

20 = is used as supplier shipment calendar when planned purchase orders are created in MRP. The requested delivery date of the planned purchased order is adjusted according to the time table in (RPS081).

In 'Supplier. Define Purchase Financial' (CRS624), the shipment table is set to 2-'Calendar contr' and point of time table to be used. The calendar control checks for the distribution/supplier calendar setup in (MMS002) to determine the adjusted delivery date from the point of time table.

30 = is used for collecting deliveries to allow forecast pacing in delivery windows. This is used in fresh food planning.

40 = is used to collect orders to monitor orders and forecast pacing. This is used in fresh food planning.

In 'Forecast Pacing Item Selection. Open' (FCS360) is where the point of time table is set to be used to generate the forecast pacing.

50 = is used to calculate the expiry date within a period bucket. It generates time buckets to be used to determine the adjusted expiry date of lots that is within the range.

The calculation of expiry date per bucket is performed during manufacturing order or purchase order receipt when the expiry date table in (MMS002) is set.

  Point of time table ...the ID of time table containing planning points specified in days, hours, and minutes.
  Start Date ...the date from which the time table is valid and to be used as the start date to generate the time table.
(RPS080/E) Finish Date ...the finish date for the point time table generated.
  Day Type

...the type of day used in the point of time table.

The valid alternatives are:

1 = Calendar Days

2 = Working Days

3 = Shipment Days

4 = Goods receiving days

  Cycle Days ...the length in days of the cycle (a repeating specified pattern).
  Name ...a name of the current identity.
  Description ...a description of the current identity.
  Day ...the day in the cycle that the specified time is valid for. The day cannot be greater than the number of days in the cycle.
  Planning time ...the time within the planning date that the transactions affects the material plan.
  Share ...the percentage of the requested shortage quantity to be supplied from the replenishment source specified.
  Number of days demand ...how many days demand the extra safety stock should cover. This is used according to the selected demand source.
  Expiry Day ...the number of days to be added from the start date of the bucket to identify final expiry date. This can only be used when the point of time type is 50 (Expiry date). The value cannot be greater than the cycle days.

B. Workflow

  1. Start 'Point of Time Table. Open' (RPS080), sorting order 1 or 2 can be used.
  2. On the B1 panel, complete these requirements:
    1. Specify and select the value for either 'Warehouse' or 'Facility'. These two fields can be blank. You have different settings:
      • for an entire company, leave facility and warehouse blank.
      • for a specific facility, specify the facility ID and leave warehouse blank.
      • for a specific warehouse, specify the warehouse ID and leave facility blank.
      • with different time periods, define the time table ID twice and use different start and end dates.
      • with different table types, define the time table ID twice and use different table types.
    2. Select point of time type:
      • 10 = Points of time used when order policy 15
      • 20 = Points of time used for supplier calendar
      • 30 = Points of time used for collecting deliveries
      • 40 = Points of time used for collecting orders
      • 50 = Points of time used for expiry date
    3. Specify value for point of time table (identity).
    4. Specify start date.
  3. On the E panel, complete these requirements:
    1. Specify finish date.
    2. Select day type.
    3. Specify value for name and description.
    4. Specify value for the cycle days.
    5. Specify value for day.
    6. Specify value for planning time, share, number of days demand, or expiry day (whichever is applicable).
  4. On the Action menu, click F14='Generate Data'.
  5. In the 'Point of Time Table. Open' (RPS081), time buckets are generated.
Related topics