Method and computer program product for performing an off-line product availability check at a user computer

• US 7,620,571 B2
• Filed: 04/30/2004
• Issued: 11/17/2009
• Est. Priority Date: 10/29/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Dust, Stephan, Gieselmann, Thomas
• Primary Examiner(s): Smith; Jeffrey A.
• Assistant Examiner(s): Misiaszek; Michael A.
• Application Number:
  US10/835,063
• Publication Number:
  US 20050096998A1
• Time in Patent Office: 2,027 Days
• Field of Search: 705/26, 705/27
• US Class Current: 705/26.5
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0621 Item configuration or customization
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders

Abstract

Techniques describe providing product availability information for use by offline computers. More particularly, a category of product availability for a product is determined at one computer system, often a central logistics or sales system, and transmitted to another computer, typically, though not necessarily, a mobile computer. The category of product availability is accessible at the mobile computer even when the computer is offline—that is, is not connected to the computer that determined the category of product availability.

Claims

1. A computer program product tangibly embodied in a computer readable medium, the computer program product including instructions that, when executed, perform an off-line product availability check at a user computer, the computer program product configured to:

in an on-line mode in which a user computer system is able to receive information from a host computer system, receive, at the user computer system, product availability data associated with a plurality of different products, the product availability data comprising, for each of the plurality of different products, a determined one of multiple different availability categories as determined by the host computer system, the received product availability data not also comprising a quantity of product available for each of the plurality of products;

store the received product availability data in a data collection stored on the user computer system, the received product availability data comprising the determined one of multiple different available categories for each of the plurality of products;

receive an input identifying one or more particular products corresponding to the stored product availability data in the data collection stored on the user computer system;

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system;

perform, on the user computer system an off-line product availability check for the one or more particular products, the off-line product availability check comprising retrieving, from the data collection, the stored product availability data for the one or more particular products of which the off-line product availability check is being performed including the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, and

provide a visual display on the user computer system of the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, the displayed availability categories being the availability category for the product as determined by the host computer system.

2. The computer program product of claim 1 further configured to:

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system, access a second data collection on the host computer system, the second data collection including;

product availability data including product availability entries, each product availability entry being associated with an amount of product that is available and a determined one of multiple different availability categories based on the amount of product that is available, and

threshold information that includes a threshold entry for each of the multiple different availability categories wherein each threshold entry is associated with a product availability entry;

use threshold entries to determine, based on an amount of a product that is available, the determined one of multiple different availability categories for the product availability entry that is associated with the product;

associate the determined one of multiple different availability categories with the product availability entry; and

transmit the product availability entry including the determined one of multiple different availability categories for the product availability entry to the user computer system.

3. The computer program product of claim 2 further configured to store the determined one of multiple different availability categories and the association of the determined one of multiple different availability categories with the product availability entry in the second data collection.

4. The computer program product of claim 2 wherein:

the second data collection includes product group information, each product group entry is associated with (a) product availability entries, and (b) threshold entries for determining one of multiple different availability categories for product availability entries that are associated with the product group entry; and

the computer program product is further configured to use the threshold entries associated with a particular product group entry to determine a one of multiple different availability categories for at least one product availability entry that is associated with the particular product group.

5. The computer program product of claim 2 further configured to determine a one of multiple different availability categories based on an implicit threshold for the one of multiple different availability categories derived from at least one threshold entry of the second data collection.

6. The computer program product of claim 2 wherein:

each product availability entry in the data collection is associated with a distribution channel;

each product availability entry in the product availability data of the second data collection is associated with an amount of product that is available in one of multiple distribution channels;

threshold information includes threshold entries for each of the one of multiple different availability categories wherein each threshold is associated with a product availability entry that includes a particular distribution channel; and

the computer program product is further configured to;

use the threshold entries for each one of multiple different availability categories for a product availability entry and an associated distribution channel to determine, based on an amount of product that is available in the distribution channel, the determined one of multiple different availability categories for the product availability entry;

associate the determined one of multiple different availability categories and the associated distribution channel with the product availability entry, and

transmit the determined one of multiple different availability categories for the product availability entry associated with the distribution channel to the user computer system.

7. The computer program product of claim 2 wherein:

each product availability entry in the data collection is associated with a location,

each product availability entry in the product availability data of the second data collection is associated with an amount of product that is available in one of multiple locations,

each threshold entry in the threshold information is associated with a product availability entry that includes a particular location; and

the computer program product is further configured to;

use the threshold entries for each one of multiple different availability categories for a product availability entry and an associated location to determine, based on an amount of product that is available in the location, the determined one of multiple different availability categories for the product availability entry,

associate the determined one of multiple different availability categories and the associated location with the product availability entry; and

transmit the determined one of multiple different availability categories for the product availability entry associated with the location to the user computer system.

8. The computer program product of claim 2 further configured to use a middleware messaging system for routing messages that include multiple different availability categories between the user computer system and the second computer system.

9. A computer-implemented method for performing an off-line product availability check at a user computer, the method comprising:

in an on-line mode in which a user computer system is able to receive information from a host computer system, receiving, at the user computer system, product availability data associated with a plurality of different products, the product availability data comprising, for each of the plurality of different products, a determined one of multiple different availability categories as determined by the host computer system, the received product availability data not also comprising a quantity of product available for each of the plurality of products;

storing the received product availability data in a data collection stored on the user computer system, the received product availability data comprising the determined one of multiple different available categories for each of the plurality of products;

receiving an input identifying one or more particular products corresponding to the stored product availability data in the data collection stored on the user computer system;

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system;

performing, on the user computer system an off-line product availability check for the one or more particular products, the off-line product availability check comprising retrieving, from the data collection, the stored product availability data for the one or more particular products of which the off-line product availability check is being performed including the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, and

providing a visual display on the user computer system of the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, the displayed availability categories being the availability category for the product as determined by the host computer system.

10. The method of claim 9 further comprising:

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system, accessing a second data collection on the host computer system, the second data collection including;

product availability data including product availability entries, each product availability entry being associated with an amount of product that is available and a determined one of multiple different availability categories based on the amount of product that is available, and

threshold information that includes a threshold entry for each of the multiple different availability categories wherein each threshold entry is associated with a product availability entry;

using threshold entries to determine, based on an amount of a product that is available, the determined one of multiple different availability categories for the product availability entry that is associated with the product;

associating the determined one of multiple different availability categories with the product availability entry; and

transmitting the product availability entry including the determined one of multiple different availability categories for the product availability entry to the user computer system.

11. The method of claim 10 further comprising storing the determined one of multiple different availability categories and the association of the determined one of multiple different availability categories with the product availability entry in the second data collection.

12. The method of claim 10 wherein the second data collection includes product group information, each product group entry is associated with (a) product availability entries, and (b) threshold entries for determining one of multiple different availability categories for product availability entries that are associated with the product group entry;

and

the method further comprising using the threshold entries associated with a particular product group entry to determine a one of multiple different availability categories for at least one product availability entry that is associated with the particular product group.

13. The method of claim 10 further comprising determining one of multiple different availability categories based on an implicit threshold for the one of multiple different availability categories derived from at least one threshold entry of the second data collection.

14. The method of claim 10 wherein:

each product availability entry in the data collection is associated with a distribution channel;

each product availability entry in the product availability data of the second data collection is associated with an amount of product that is available in one of multiple distribution channels;

threshold information includes threshold entries for each of the one of multiple different availability categories wherein each threshold is associated with a product availability entry that includes a particular distribution channel; and

the method further comprising;

using the threshold entries for each one of multiple different availability categories for a product availability entry and an associated distribution channel to determine, based on an amount of product that is available in the distribution channel, the determined one of multiple different availability categories for the product availability entry;

associating the determined one of multiple different availability categories and the associated distribution channel with the product availability entry, and

transmitting the determined one of multiple different availability categories for the product availability entry associated with the distribution channel to the user computer system.

15. The method of claim 10 wherein:

each product availability entry in the data collection is associated with a location,

each product availability entry in the product availability data of the second data collection is associated with an amount of product that is available in one of multiple locations,

each threshold entry in the threshold information is associated with a product availability entry that includes a particular location; and

the method further comprising;

using the threshold entries for each one of multiple different availability categories for a product availability entry and an associated location to determine, based on an amount of product that is available in the location, the determined one of multiple different availability categories for the product availability entry,

associating the determined one of multiple different availability categories and the associated location with the product availability entry; and

transmitting the determined one of multiple different availability categories for the product availability entry associated with the location to the user computer system.

16. The method of claim 10 further comprising using a middleware messaging system for routing messages that include multiple different availability categories between the user computer system and the second computer system.

17. A system for performing an off-line product availability check at a user computer, the system being configured to:

in an on-line mode in which a user computer system is able to receive information from a host computer system, receive, at the user computer system, product availability data associated with a plurality of different products, the product availability data comprising, for each of the plurality of different products, a determined one of multiple different availability categories as determined by the host computer system, the received product availability data not also comprising a quantity of product available for each of the plurality of products;

store the received product availability data in a data collection stored on the user computer system, the received product availability data comprising the determined one of multiple different available categories for each of the plurality of products;

receive an input identifying one or more particular products corresponding to the stored product availability data in the data collection stored on the user computer system;

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system;

perform, on the user computer system an off-line product availability check for the one or more particular products, the off-line product availability check comprising retrieving, from the data collection, the stored product availability data for the one or more particular products of which the off-line product availability check is being performed including the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, and

provide a visual display on the user computer system of the determined one of the plurality of availability categories for each of the one or more of the plurality of particular products, the displayed availability categories being the availability category for the product as determined by the host computer system.

18. The system of claim 17 wherein the system is further configured to:

in an off-line mode in which the product availability data on the host computer system is not accessible by the user computer system, access a second data collection on the host computer system, the second data collection including;

product availability data including product availability entries, each product availability entry being associated with an amount of product that is available and a determined one of multiple different availability categories based on the amount of product that is available, and

threshold information that includes a threshold entry for each of the multiple different availability categories wherein each threshold entry is associated with a product availability entry;

use threshold entries to determine, based on an amount of a product that is available, the determined one of multiple different availability categories for the product availability entry that is associated with the product;

associate the determined one of multiple different availability categories with the product availability entry; and

transmit the product availability entry including the determined one of multiple different availability categories for the product availability entry to the user computer system.

19. The system of claim 18 wherein:

the second data collection includes product group information, each product group entry is associated with (a) product availability entries, and (b) threshold entries for determining one of multiple different availability categories for product availability entries that are associated with the product group entry; and

the system is further configured to use the threshold entries associated with a particular product group entry to determine a one of multiple different availability categories for at least one product availability entry that is associated with the particular product group.

20. The system of claim 18 wherein the system is further configured to determine a one of multiple different availability categories based on an implicit threshold for the one of multiple different availability categories derived from at least one threshold entry of the second data collection.