Distributed handling of associated data sets in a computer network

• US 7,693,893 B2
• Filed: 09/27/2004
• Issued: 04/06/2010
• Est. Priority Date: 10/10/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kemmer, Johann, Sala, Paola, Jadanovski, Andrei, Gurevich, Elena, Reiner, Robert
• Primary Examiner(s): Vo; Tim T.
• Assistant Examiner(s): Mobin; Hasanul
• Application Number:
  US10/949,331
• Publication Number:
  US 20050086291A1
• Time in Patent Office: 2,017 Days
• Field of Search: None
• US Class Current: 707/705
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

A networked database includes the automatic creation of follow-on data sets from initial data sets. A dialogue routine is implemented for initiating a dialogue-type communication that includes inputting and confirming data required for creating the follow-on data sets. The database is provided with a plurality of data sets and is capable of generating and displaying a list of data sets according to user-defined criteria. For a data set in the generated list that allows for the automatic creation of a follow-on data set, a related, configurable, user-activated control element is displayed. Upon user-activation, the control element, generates a control signal for initiating the automatic creation of the follow-on data set based on data derived from the selected data set and/or any data set associated with the selected data set. The newly created follow-on data set is then associated with the selected data set.

Claims

1. A computer-implemented method for handling procurement-related data sets accessible from a plurality of network components, the method comprising:

providing a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

generating a first list of data sets from the at least one data item in response to receiving a user-defined selection criteria;

displaying the purchase order and a second list of data sets, the second list of data sets comprising at least a portion of the first list of data sets, wherein each data set included in the second list of data sets is configured to generate a follow-on data set;

displaying, for a first data set included in the second list of data sets, a related first control element configured to automatically generate, in response to activation of the first control element, the first follow-on data set;

storing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the purchase order and a dependency between a first processing stage associated with the purchase order and a second processing stage associated with the first follow-on data set; and

outputting the first follow-on data set to at least one of the plurality of network components.

2. The method of claim 1, further comprising defining a plurality of follow-on data set types associated with at least one procurement item, the procurement item including at least one of goods and services.

3. The method of claim 2, further comprising consecutively creating two or more follow-on data sets during a process involving consecutive processing stages, wherein each processing stage is associated with one of the plurality of follow-on data set types.

4. The method of claim 1, further comprising providing the input of the at least one user-defined criteria for generating the first list of data sets.

5. The method of claim 4, further comprising:

providing a selection of a follow-on data set type; and

generating a purchase order list from purchase orders that create a follow-on data set of a selected type.

6. The method of claim 5, wherein generating the purchase order list from purchase orders that create the follow-on data set of the selected type includes:

receiving an input by a second control element configured to generate a control signal to select and to display only data sets configured to generate a specific follow-on data set type; and

evaluating the second control signal prior to generating the list of purchase orders.

7. The method of claim 2, further comprising:

defining, for each follow-on data set type, an individual type of the first control element;

assessing the purchase orders of the list to determine the type of follow-on data set that can automatically be created for a particular purchase order; and

displaying a purchase order for which a follow-on data set of a specific type is created together with the corresponding type of first control element.

8. The method of claim 1, wherein the list also includes other purchase orders for which an associated follow-on data set are only created using a dialogue routine and

wherein, for each of such other purchase orders, the first control element, when displayed, is configured as non-active.

9. The method of claim 1, further comprising relating a third control element with each displayed data set of the list of purchase orders, wherein, upon activation of the third control element, additional information about the selected data set is displayed together with the first control element.

10. The method of claim 1, wherein upon activation of the first control element by a user, at least one of the displayed purchase order and any data set associated therewith is locked from other users at least partially with respect to changing data comprised therein.

11. The method of claim 1, wherein the data required for automatically generating the follow-on data set is derived from at least one of the selected data set and any data set associated with the displayed purchase order prior to displaying the list of purchase orders.

12. The method of claim 1, further comprising:

controlling a printing device arranged in the network to generate a document from the information included in the first follow-on data set.

13. The method of claim 1, wherein the computer network includes an application server and at least one presentation server communicating with the application server according to the hypertext transfer protocol (HTTP).

14. The method of claim 1, wherein the first follow-on data set includes at least one of invoice data and delivery confirmation data.

26. The method of claim 1, wherein the user-defined selection criteria comprises:

at least one attribute of the purchase order stored in the header, and

a data set type, wherein the data set type includes a purchase order that generates follow-on data sets.

27. The method of claim 26, wherein the first control element is displayed based on a selection of at least one purchase order according to the user-defined selection criteria.

28. The method of claim 1, wherein the first follow-on data set is derived by evaluating a data set history associated with the purchase order.

15. A method for handling procurement-related data sets accessible from a plurality of network components, the method comprising:

providing a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

generating a first list of data sets from the at least one data item in response to receiving a user-defined selection criteria;

displaying the purchase order and a second list of data sets, the second list of data sets comprising at least a portion of the first list of data sets, wherein each data set included in the second list of data sets is configured to generate a follow-on data set;

displaying, for a first data set included in the second list of data sets, a first control element configured to automatically generate, in response to activation of the first control element, the first follow-on data set; and

storing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the purchase order and a dependency between a first processing stage associated with the purchase and a second processing stage associated with the first follow-on data set.

16. The method of claim 15, further comprising:

defining a plurality of follow-on data set types, including at least an invoice data set type and a delivery confirmation data set type.

17. A computer program product, embodied on a computer readable medium, comprising program code portions for being executed on one or more components of a computer network, the computer program product including:

first program code for searching a database for purchase orders according to at least one user-defined selection criteria, and for generating a purchase order list thereof, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

second program code for displaying the purchase order list at least partially, wherein, for a displayed purchase order of the list, a related first control element is displayed that automatically creates a first follow-on data set, the related first control element being configured for activation by a user-operated input device that generates a first control signal for initiating the automatic creation of the first follow-on data set for the displayed purchase order; and

third program code, responsive to generation of the first control signal, for skipping an implemented dialogue routine for the first follow-on data set to be created, for automatically creating the first follow-on data set based on data derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order, and for associating the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

18. A computer program product, embodied on a computer readable medium, comprising program code portions for being executed on one or more components of a computer network, the program code portions controlling the one or more components to handle procurement-related purchase orders in a computer, the computer code product comprising:

first program code to provide a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

second program code to generate a list of purchase orders from the database according to at least one user-defined selection criteria;

third program code to at least partially display the list, wherein, for a displayed purchase order of the list a related first control element is displayed that automatically creates a first follow-on data set, the first control element being configured for activation by a user-operated input device that generates a first control signal for automatically creating the first follow-on data set for the displayed purchase order; and

fourth program code to skip an implemented dialogue routine for the first follow-on data set to be created upon generation of the first control signal, and to automatically create the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order, and to associate in the database the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set displayed.

19. A network component of a computer network, the network component comprising:

a processor for executing an instruction for searching at least one database for purchase orders according to at least one user-defined criteria, each of the purchase orders including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart, and for generating a list thereof, wherein, for a displayed purchase order of the list, a related first control element is provided that automatically creates a first follow-on data set, the related first control element being configured for activation by a user-operated input device for initiating the automatic creation of the first follow-on data set for the displayed purchase order;

wherein, upon activation of the control element, the executed instruction skips a dialogue routine for the first follow-on data set to be created, for automatically creating the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order, and for associating the displayed purchase order with the first follow-on data set, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

20. The network component of claim 19, further comprising:

a first interface to the at least one database and a second interface to a display device.

21. A method for handling data sets in a computer network, the method comprising:

generating a list of purchase orders according to at least one user-defined criteria, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, at and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

displaying the list at least partially, wherein, for a displayed purchase order of the list a related first control element is displayed that enables the automatic creation of a first follow-on data set; and

skipping a dialogue routine for the first follow-on data set to be created upon activation of the first control element, to automatically create the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order and to associate the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

22. A method for handling procurement-related data sets in a computer network by automatically creating, for a data set, at least one associated follow-on data set, the method comprising:

providing a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

generating a list of purchase orders from the database according to at least one user-defined criteria;

displaying the list at least partially, wherein, for a displayed purchase order of the list, a related first control element is displayed that enables the automatic creation of a first follow-on data set, the related first control element being configured for activation by a user operated input device to generate a first control signal for initiating the automatic creation of the first follow-on data set for the displayed purchase order; and

skipping a dialogue routine for the follow-on data set to be created upon generation of the first control signal, automatically creating the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order and to associate in the database the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

23. An apparatus of a computer network, the apparatus comprising:

processing means for generating an instruction for searching a database for purchase orders according to at least one user-defined criteria, the purchase orders including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart, and for generating a list thereof for presentation on a display, wherein, for a displayed purchase order of the list a related first control element is provided that enables the automatic creation of a first follow-on data set, the first control element being configured for activation by a user-operated input device to initiate the automatic creation of the first follow-on data set for the displayed purchase order;

wherein the processing means, upon activation of the first control element, skips a dialogue routine for the first follow-on data set to be created, automatically creating the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order and associating the displayed purchase order with the first follow-on data set, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

24. A system comprising a computer processor and a memory coupled to the processor, where the memory is encoded with one or more programs that perform a method for handling procurement-related data sets in a computer network, the method comprising:

providing a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

generating a list of purchase orders according to at least one user-defined selection criteria

displaying the list at least partially, wherein, for a displayed purchase order of the list, a related first control element is displayed that enables the automatic creation of a first follow-on data set;

skipping a dialogue routine for the first follow-on data set to be created upon activation of the control element, to automatically create the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order; and

associating the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

25. A system comprising a computer processor and a memory coupled to the processor, where the memory is encoded with one or more programs that perform a method for handling procurement-related data sets in a computer network, the method comprising:

providing a database with a plurality of purchase orders, each purchase order including at least one data item and associated with a shopping cart, the shopping cart comprising a header including a timestamp, and a follow-on data set table configured to store a reference to each follow-on data set related to the shopping cart;

generating a list of purchase orders from the database according to at least one user-defined selection criteria;

displaying the list at least partially, wherein, for a displayed purchase order of the list, a first control element is displayed that enables the automatic creation of a first follow-on data set, the first control element being configured for activation by a user-operated input device to generate a first control signal for initiating the automatic creation of the first follow-on data set for the displayed purchase order;

skipping a dialogue routine for the follow-on data set to be created upon generation of the first control signal, automatically creating the first follow-on data set based on data automatically derived from at least one of the displayed purchase order and any data set associated with the displayed purchase order; and

associating in a database the first follow-on data set with the displayed purchase order, wherein associating the first follow-on data set with the displayed purchase order includes writing information relating to the first follow-on data set in the follow-on data set table, the information including a reference to the displayed purchase order and a dependency between a first processing stage associated with the displayed purchase order and a second processing stage associated with the first follow-on data set.

29. The method of 28, wherein evaluating the data set history includes comparing an initially ordered quantity specified in the purchase order with a quantity that has already been invoiced, wherein the follow-on data set includes a quantity that is based on the comparison.