Systems and methods for automatically selecting a plurality of specific order items from a plurality of order items

Abstract

Systems and methods are provided for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria. In one implementation, the system includes an inbound interface for interfacing with a plurality of data storage devices, in at least one of which the plurality of order items are stored as data. The system also includes an execution memory operable to hold a software system and a processor coupled to the inbound interface and the execution memory, the processor being operable to execute the software system such that the software system operates: to generate one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria, to fill the order due lists via the inbound interface with the data corresponding to the plurality of specific order items, and to store the filled order due lists in a database.

Description

TECHNICAL FIELD

The present invention generally relates to the field of data processing and, more particularly, to computerized systems and methods for automatically selecting a plurality of specific order items from a plurality of order items.

BACKGROUND INFORMATION

Supply chain management software systems are known, for example, SAP's Supply Chain Management system. Such supply chain management systems include a plurality of applications for implementing the management of the supply chain. These applications include, for example, SAP Advanced Planning and Optimization (SAP APO) and Extended Warehouse Management (EWM). A core interface (CIF) connects SAP SCM with online transaction processing systems (OLTP), such as SAP Customer Relations Management (SAP CRM) and Enterprise Resource Planning (ERP). In particular, the core interface connects the OLTP to the SAP APO.

In supply chain management, when a product is available to be promised to a customer it is “available to promise” (ATP). Supply chain management systems including available to promise (ATP) functionality are known. Supply chain management applications, such as SAP APO, include ATP functionality. Such systems include software for determining whether a product is available to promise. The determination may include performing an availability check when a customer calls to place an order.

Document data from an OLTP system, for example, the sales orders data, may be stored in databases, such as LiveCache and several other database tables in SAP SCM.

A problem with conventional supply chain management systems having available to promise functionality is that when an application requires a selection to be made of specific order items fulfilling specific criteria, conventional selection software obey the selection criteria without automatically considering the item priority. Under these conventional selection criteria, due to the large data volume and its dispersal over several possible database tables, a quick search of the affected items is not possible. Thus, the quality of the application availability check is compromised.

In view of the foregoing, it is desirable to address one or more drawbacks present in conventional systems, such as those identified above. In particular, it is desirable to improve the availability check. It is further desirable to increase the speed with which specific order items can be selected.

SUMMARY

In view of the foregoing, systems and methods are disclosed herein for overcoming one or more of the above-mentioned problems. In accordance with embodiments of the invention, systems and methods may be provided for automatically selecting a plurality of specific order items from a plurality of order items.

In accordance with an embodiment of the invention, a system is provided for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria. The system includes an inbound interface for interfacing with a plurality of data storage devices, in at least one of which the plurality of order items are stored as data. The system also includes an execution memory operable to hold a software system and a processor coupled to the inbound interface and the execution memory, the processor being operable to execute the software system such that the software system operates: to generate one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria, to fill the order due lists via the inbound interface with the data corresponding to the plurality of specific order items, and to store the filled order due lists in a database.

By providing order due lists which are used as an index, the selection can take place faster than a search using conventional techniques. Thus, the speed of the system can be increased, i.e., a technical advantage may be achieved.

According to another embodiment of the present invention, there is provided a computer-implemented method for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria. The method includes interfacing an inbound interface with a plurality of inbound data storage devices, in at least one of which the plurality of order items are stored as data. The method further includes generating one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria, filling the order due lists via the inbound interface with the data corresponding to the plurality of specific order items, and storing the filled order due lists in a database.

According to an embodiment of the present invention, a user terminal may be provided that includes means operable with systems and methods consistent with the invention, such as those previously described.

Embodiments of the present invention further relate to a computer readable storage medium that stores a program which, when run on a computer, controls the computer to perform systems and methods consistent with the present invention, such as those previously described.

Additional objects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objects and advantages of the invention will be realized and attained by means of the elements and combinations particularly pointed out in the appended claims.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.

BRIEF DESCRIPTION OF THE DRAWINGS

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate various embodiments and aspects of the present invention. In the drawings:

FIG. 1 illustrates an example of back order processing (BOP) and its triggering events;

FIG. 2 shows an exemplary formation and use of order due lists (ODL), according to an embodiment of the invention;

FIG. 3 shows an exemplary ODL definition, according to an embodiment of the invention;

FIG. 4 shows an exemplary ODL definition including a filter variant definition, according to an embodiment of the invention;

FIG. 5 shows an example of the generation of an ODL table, according to an embodiment of the invention;

FIG. 6 shows an example of the activation of an ODL table, according to an embodiment of the invention;

FIG. 7 shows an example of the preparation of ODL table data by an ODL agent, according to an embodiment of the invention, and

FIG. 8 shows an example of data selection from an ODL, consistent with an embodiment of the present invention.

DESCRIPTION OF THE EMBODIMENTS

The following detailed description refers to the accompanying drawings. Wherever possible, the same reference numbers are used in the drawings and the following description to refer to the same or similar parts. While several exemplary embodiments and features of the invention are described herein, modifications, adaptations and other implementations are possible, without departing from the spirit and scope of the invention. For example, substitutions, additions or modifications may be made to the components illustrated in the drawings, and the exemplary methods described herein may be modified by substituting, reordering, or adding steps to the disclosed methods. Accordingly, the following detailed description does not limit the invention. Instead, the proper scope of the invention is defined by the appended claims.

As mentioned above, SAP CRM or ERP are OLTP systems. SAP CRM and ERP are systems for the daily online transaction processing where, for example, the sales orders are entered. SAP APO is a component of SAP SCM. SAP APO is a logistic planning system. ATP is a component of SAP APO. A core interface CIF connects the OLTP to the SAP APO. It provides functions to transfer the business data between the two types of systems. An availability check may be carried out when a customer enquires about placing an order. ATP is the component that executes the availability check. The availability check may take into account existing stock and also the quantities of future incoming or outgoing orders that should be delivered by the date of the order to determine whether the product is available to promise. If a quantity (of stock or an incoming order) is promised to a first customer, a second customer cannot access the reserved quantity. If there is not enough quantity to honor a complete order as requested, the order can be confirmed at a later date or may stay unconfirmed respectively partially confirmed.

Further, in a situation where there are several orders which cannot all be confirmed, those order which cannot be confirmed become back orders. Back orders are sales documents whose order items cannot be completely confirmed as requested due to lack of availability or material shortages. Orders, including back orders, may be assigned a priority rating. For example, a high priority order and a low priority order. If a high priority order cannot be confirmed immediately, it becomes a back order.

Back order processing (BOP) is one technical vehicle for dealing with back orders. BOP is a tool of the ATP component, for example in SAP APO. Using BOP, an available quantity of one or more products can be reallocated using a quantity of selected requirements. BOP may be carried out as an interactive BOP or as a batch BOP. A processor, such as a back order kernel 3 (see FIG. 1), may carry out the back order processing which includes carrying out an availability check including a rules based ATP check (RBA), for example. At first, the process decides which items of the back order are to be checked and in which sequence. In order to do this, at least one filter may be defined. In one embodiment, the filter has a filter type which defines which criteria are used to select the items to be processed. Criteria may include, for example, customer type, product/location, item type (for example, sales order), etc. The filter may also have a filter variant which defines which values of defined criteria meet the conditions of the filter. The order items can be stored in the OLTP system. They may also be stored in SAP APO. In operation, the filtering selects items corresponding to the particular filter to the particular database. For example, the filter type may define a parameter—customer type—. The filter variant may define the parameter value—customer type—“very important” or “medium important.” In this way, the filter is defined. This filter then selects only items having a “very important” or “medium important” customer. In one embodiment, the filter can be designed to define back orders.

Two further situations are now described. In event driven quantity assignment (EDQA), back order processing including global ATP may be used as an internal tool. If several orders cannot be confirmed and a quantity is received that the system can assign, back order processing may be started. For example, if a sales order is cancelled, the released quantity can be reassigned. Such a quantity assignment is called EDQA. In addition to the cancellation of an order, the event may include incoming stock and a changed order. In a second situation, an order confirmation is reassigned. Reassignment of order confirmation (ROC) takes places if, for example, a very important order for a very important customer is created or changed and no quantity is available. In such a situation, quantities can be “stolen” from unimportant orders even if they are confirmed. For example, for orders that may be defined as a low priority order, their quantities may be reassigned to high priority orders. In one embodiment, ROC is generally not carried out in a batch process. It may be done independently of back order processing. It may be carried out online.

EDQA and ROC may use order due lists (ODL), which are described in more detail hereinafter. In general, order due lists use a filter to select orders. The ODL filtering is used if the order is saved. At the time that the order item is saved, all filters of order due lists are scanned. If an ODL is activated, it is being filled by the system via inbound interface with corresponding OLTP documents.

In addition to those drawbacks mentioned above, in conventional back order processing systems, the system typically has to search for back ordered items. To do this, conventional systems often filter the whole database to find the affected items. ODLs provide an index function, and allow affected items to be stored immediately after being saved. In this way, affected items can be retrieved also quicker than in conventional systems.

In one embodiment, the ODL is an additional database element. It has a restricted number of fields. It performs the function of an index. It is assigned to a process, for example, EDQA. It performs a pre-selection. The function performed is that of a sorter. The ODL pre-selection can be edited manually. The pre-selection may be at least one of edited, deleted or overruled. The ODLs can be used as a reference for searching items under consideration of its priority. The order types of the handled items, the criteria to filter, and to sort them can be freely configured. Filter and sorter are defined independent from the ODL.

In one embodiment, selection can be aborted after the number of necessary items is reached. The selection from the ODL obeys the corresponding sort profile.

Consistent with an embodiment, the ODL has a type. The ODL type defines the nature of items that can be contained in the ODL. For example, the types “Obtain Confirmation (RCV),” “Lose Confirmation (SPL),” and “Free Work List (WLS)” may be supported. The filter assigned to the ODL may comprise a filter type and a filter variant. The filter type defines the criteria and the variant contains the values of the criteria to select the items. Per filter type several variants can be defined. The sorter assigned to the ODL contains the criteria to sort the items. Database objects as well as source code is generated out of the settings of an ODL. In one embodiment, an ODL comprises a database table with a specific database index and specific source code for table access. The generated database table depends on the criteria that are used to calculate the item priority (sorter). The generated source code for selection from the ODL can be used, for example, by any SAP SCM application.

The ODLs of the type “Free Work List” may be defined without specifying a filter. The assignment of the sorter is optional. They are filled manually and can be used like a notepad for order items. Items can be added to this ODL in the display of the explanation component of the availability check, in the display of the backorder processing (BOP) result, or in the display of the work list. The situations where items can be added to work list ODLs are not restricted. These work list ODLs can be used as a work list of BOP.

In conventional systems, the complete selection of affected items from several database tables and LiveCache was necessary. Sorting the items was only possible after filtering them from database. No sort/filter based reference was available. In contrast, in accordance with embodiments of the present invention, it is possible to let the customizable filter work before storing the data in a reference table. Further, a quick item search by creating a customized database object is also possible. It is possible to allow creation of ODLs only if it is needed.

ODLs can be used at any place where pre-selected lists of orders or order items are necessary (e.g. out of performance reasons). ODLs can be used, for example, in SAP SCM: during event driven quantity assignment (EDQA) and also in back order processing as a reference to items that should be confirmed, during reassignment of quantity confirmations (ROC) as a reference to items that can lose their confirmations, and during backorder processing as a work list. Using ODLs a list of items fulfilling the criteria of the filter are selected. The ODL provides an index in the database table, so that all data in the table can be accessed. For example, a sales order that may be stored in LiveCache or 10 database tables where there are around 500 to 800 fields. ODL are linked to the databases, the order ID is used as a key. Accessing the database by using a key is fast. The index is used to pre-select very quickly. The index is defined by customizing based on the sorter definition. In this way, the system finds all items associated with the order for BOP.

FIG. 1 shows an example of back order processing (BOP) and its triggering events. As shown in FIG. 1, there is a flexible assignment of pre-defined events and triggering modules to start workflows that are related to back order processing (BOP). EDQA Agent 2 handles this assignment. The EDQA agent may be provided as a tool that is related to BOP. The EDQA agent may use ODLs as input for confirmation of back ordered items after being triggered, by an event, for example, by goods receipt. EDQA Agent 2 may use a processor, in particular, BOP kernel 3 (a BOP based process step) and its output mechanism during the workflow. For example, in FIG. 1, the triggering event 1 may be a process/event in an external system, for example, a goods receipt. Once the goods are received, EDQA is triggered, as the triggered activity 2. EDQA Agent 2 reads the stored data in the data storage system 4 (in this case ODL). Subsequently, BOP is carried out by the BOP kernel 3. BOP is carried out when necessary. It may be carried out as a batch. The result list 5 of the BOP may be provided to an output buffer 6, which is the SAP APO storage system, for example. The result list in the output buffer may then be subsequently sent to the OLTP system.

FIG. 2 shows an example of the formation and use of order due lists (ODL), according to an embodiment of the invention. In order to make a selection of potential order due lists during the EDQA efficient, an order due list is built. Generating of corresponding database tables may be performed by the ODL builder 10 and based on customizable filter and sort parameters 12. The ODL builder 10 generates the selection source code, which is used during the EDQA and filter source code that is used for filling the ODL. Once the ODL is activated, the generated tables are filled by an ODL agent 14, for example, in SAP APO. The data to be filled in the generated tables may prepared by ATP rules within the sourcing process/availability check 16 caused by order processing in the OLTP system, for example, the Order Management system SAP CRM 18. The data to be filled in the tables may be buffered in an ATP buffer 20 prior to being filled in the tables by the ODL agent 14. The ATP check will store the potential order due items and corresponding product/location replacements in a temporary data buffer, ATP buffer 20. In the example of FIG. 2, the data is stored in the ATP buffer 20 until the document is saved, as indicated by circle 21, in the OLTP system and passed to the SAP APO inbound interface 22, where the ODL agent uses this data for creating ODL entries. The ODL agent may also update and delete ODL.

In accordance with an embodiment, the ODL is a database table with corresponding ODL access source code. The table is generated by the ODL builder according to sort profiles to allow fast data selection. The ODL builder 10 builds the database tables of ODL in the SAP APO. The table structure depends on the sort profile which is used during the selection of the orders. The sort profile defines the sequence in which the items are to be processed. The sort profile specifies the characteristics, their sequence (or weighting) and the sort direction.

FIG. 3 shows an example of an ODL definition, according to an embodiment of the invention. In the example of FIG. 3, the ODL definition 30 includes a predefined filter type 32, for example, a filter type: GR_YARD (Goods Receipt In Yard), which allows orders according to the criteria defined in it. The ODL definition 30 may also include a sort profile 34, for example, a sort profile: SORT 2. The filter type 32 and the sort profile 34 may be customizable. The ODL definition 30 may further include an identifier 36 and a name 38. Also, a filter variant 40 with filter conditions for a filter type can be created and used. As mentioned above, the filter selects items corresponding to the particular filter to the particular data base. For example, the filter type may define a parameter—customer type—. The filter variant may define the parameter value—customer type—“very important” or “medium important.” The variant can be maintained by clicking on the maintain variant icon 41. The predefined sort profile 34 is chosen. In the example shown, the sort profile 34 is SORT2. Once the ODL is defined, the corresponding table can be generated by clicking on generate icon 42. A generated table can be activated by clicking on the activate icon 44. It can be activated and filled by data stored in a database by clicking on the icon activate and fill 46. In the example shown, it is seen that the ODL definition 30 includes a status 48 which shows that the ODL is defined.

In accordance with an embodiment, the ODL builder 10 database may comprise the following object groups: structure for definition of fields valid for all filter types and sort profiles, database tables for filter definition and generation of corresponding program code statements, database tables for sort profile definition and generation of corresponding program code statements, and database tables for assigning of filter/sort to ODL tables and generation/activation of the tables.

FIG. 4 shows an example of an ODL definition 30 including a filter variant definition, according to an embodiment of the invention. Having chosen a filter type 32, a filter variant 40 that is valid for the filter type can be chosen. The variant may be predefined, i.e. already created and maintained. Further, the filter variant can be maintained. It is also possible to create a filter variant. The filter variant includes the filter conditions according to the filter type parameters. The filter variant 40 and the filter type 32 build together the actual filter 32, 40. Further, a sort profile 34 can be chosen from one of the predetermined, maintained sort profiles. Within the maintenance view screen it is also possible to change ODL description, delete ODLs, generate ODLs, drop and refresh code, activate ODLs 44, activate and fill tables 46, deactivate ODLs. As mentioned, the filter type definition, the sort profile definition can be customized.

In the example of FIG. 4, below the ODL definition 30 a screen shot shows an example of a filter variant. The filter parameters “product” and “source location” are chosen and can be maintained.

FIG. 5 shows an example of the generation of an ODL table, according to an embodiment of the invention. Based on the sort profile 34, a database table with appropriate database index is generated by clicking on the generate icon 42. Based on the chosen filter 32 and program code template, a program name 50, for example, XYZ, and program code for filling the table by the ODL agent 14 is generated. Based on the chosen sort profile 34 and program code template, a program name 50 and program code for selection from the table by EDQA is generated. Once generated, the status 48 of the ODL becomes “GENERATED” 52, as illustrated in FIG. 5. It is noted that the ODL table, although generated, does not contain any entries at this point.

FIG. 6 illustrates an example of the activation of an ODL table, according to an embodiment of the invention. In this embodiment, activation of a table by clicking on the activate icon 44 immediately enables filling it by necessary and eligible index date. The function activate and fill 46 can be used for filling the table with index data of possibly already existing backorder items, which are eligible for the table. The ODL (filter/sort) can be valid for greater than or equal to 1 trigger events 1. Reassigning a filter/sort makes ODL reorganization necessary. For example, if it is decided to use a different filter but the existing data does not meet the conditions of reorganizing.

FIG. 7 shows an example of the preparation of ODL table data by an ODL agent, according to an embodiment of the invention. Having generated and activated one or more ODL tables, as described above, the following functionality may be achieved. At the time global ATP is called, a data set is prepared. The ODL agent 14 uses this data set for filling the ODL tables. The data set includes, for example, the following information: a list of product/location combinations that are valid for the item and result from the RBA, product/location combination where the replenishment indicator from master data has an appropriate value. Collected data is assigned to corresponding items and saved in the ATP buffer 20 until the order is saved in the OLTP system and the ODL agent 14 in, for example, SAP APO inbound read them and extract the list of possible product/location combinations. By way of example, FIG. 7 shows the interaction between SAP CRM and SAP APO according to an embodiment of the invention. In SAP CRM, a new order is entered (step 60) in order processing. For example, the new order may include a product, an amount and a date for delivery. Once entered, SAP APO carries out an availability check, for example, a RBA (step 62). Within the availability check valid location product replacements, as well as the location product where the backorder is created, are collected per item (step 63). The prepared, collected data set is saved in the ATP buffer 20 assigned to an item (step 64). On the basis of the availability check, SAP APO returns a proposed date and quantity back to the SAP CRM (step 66). In SAP CRM, order processing processes the amended order on the basis of the proposed date and quantity (step 68). For example, the amended order may have a new request date. Once amended, SAP APO carries out an availability check for the amended order. Again, valid location product replacements, as well as the location product where the backorder is created, are collected per item (step 72). Subsequently, the prepared data set in the ATP buffer 20 assigned to an item is overwritten and saved (step 74). A new proposed date and quantity, on the basis of the availability check (step 70) is provided to SAP CRM (step 76). In order processing in SAP CRM, if the new proposed date and quantity are ok, the order is saved (step 78). Once the order is saved, inbound processing occurs (step 80). The ATP buffer 20 is read (step 82). The ODL table is filled (step 84) by ODL agent 14. The filled table is stored in a storage medium 4 (step 86). As mentioned previously, in this way, the ODLs provide an index function which allows affected items to be stored immediately after being saved. In this way, affected items can be retrieved also quicker than in conventional systems.

If rules based ATP (RBA) is applied on an item, ATP rules evaluation will compile the product/location list which is needed by the ODL agent 14 after the order was saved in the OLTP system. By way of example, the compilation of the list may be influenced by: customizing of a rule strategy list. In order to avoid unnecessary data transfer by the ODL agent 14, the process customizing defined which rule strategies are to be taken into account for replacements list creation during the ATP check/rules evaluation. The list of valid product/location combinations is compiled for each rule strategy (one or more per item), which is maintained for EDQA. It can be further influenced by the business transaction . The business transaction parameter can furthermore control the list compilation. Data set preparation is, for example, carried out during online/batch order processing and postponed sourcing. It can be further influenced by: rules evaluation tolerance. A flag, which controls the completeness of the product/location replacement list that results from the RBA. If switched on, only product/location combinations that result from executed rules evaluation will be considered. If switched off, all possible product/location combination that could result from RBA will be considered.

FIG. 8 shows an example of data selection from an ODL, according to an embodiment of the invention. In particular, FIG. 8 shows how with the ODL providing an index 90 to the database 4, affected items in the ODL data 92 may be found without having to search entire databases. As illustrated in this example, the application SAP APO selects 1,000 pieces. Using the ODLs, the database index sorts the ODL data by priority (step 94). Only the first eligible (affected) items are taken (step 96). The items are fetched (step 98) and the process in the application continue (step 100). In this way, if there are 40,000 potential receivers of the 1,000 pieces, but only 3 items eligible according to the sort profile, the 3 eligible (affected) items are found first, since the database index allows the database to order the ODL data by priority.

It is to be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternatives without departing from the scope of the appended claims. For example, the computational aspects described here can be implemented in digital electronic circuitry, or in computer hardware, firmware, software, or in combinations of them. Where appropriate, aspects of these systems and techniques can be implemented in a computer program product tangibly embodied in a machine-readable storage device for execution by a programmable processor, and method steps can be performed by a programmable processor executing a program of instructions to perform functions by operating on input data and generating output. The mere fact that certain measures are recited in mutually different claims does not indicate that a combination of these measures cannot be used to advantage.

Other embodiments of the invention will be apparent to those skilled in the art from consideration of the specification and practice of the invention disclosed herein. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the invention being indicated by the following claims.

Claims

1. A system for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria, the system comprising: an inbound interface for interfacing with a plurality of data storage devices in at least one of which the plurality of order items are stored as data; an execution memory operable to hold a software system; and a processor coupled to the inbound interface and the execution memory, the processor being operable to execute the software system such that the software system operates: to generate one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria, to fill the order due lists via the inbound interface with the data corresponding to the plurality of specific order items, and to store the filled order due lists in a database.

2. A system according to claim 1, wherein the order due list is a database element.

3. A system according to claim 1, wherein the software system further operates to abort the selection when a predefined number of specific order items is reached.

4. A system according to claim 1, wherein the one or more order due list functions as an index.

5. A system according to claim 1, wherein the software system further operates to save the plurality of specific order items.

6. A system according to claim 1, wherein the plurality of specific order items are stored in a buffer.

7. A system according to claim 1, wherein the software system further operates to build the one or more order due lists in accordance with customizable criteria.

8. A system according to claim 1, wherein the definition includes a filter for filtering the plurality of order items.

9. A system according to claim 8, wherein the filter includes a filter type to select one or more order items according to predefined criteria.

10. A system according to claim 1, wherein the definition includes a sort profile to prioritize the plurality of specific order items.

11. A system according to claim 8, wherein the filter includes a filter variant.

12. A system according to claim 8, wherein the filter is customizable by at least one of a system and user in accordance with at least one of a system and user preference, respectively.

13. A computer-implemented method for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria, the method comprising: interfacing with a plurality of inbound data storage devices, in at least one of which the plurality of order items are stored as data; generating one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria; filling the order due lists via the inbound interface with the data corresponding to the plurality of specific order items; and storing the filled order due lists in a database.

14. A method according to claim 13, wherein the order due list is a database element.

15. A method according to claim 13, further comprising aborting the selection when a predefined number of specific order items is reached.

16. A method according to claim 13, wherein the one or more order due list functions as an index.

17. A method according to claim 13, further comprising saving the plurality of specific order items.

18. A method according to claim 13, wherein the plurality of specific order items are stored in a buffer.

19. A method according to claim 13, further comprising building the one or more order due lists in accordance with customizable criteria.

20. A method according to claim 13, wherein the definition includes a filter for filtering the plurality of order items.

21. A method according to claim 20, wherein the filter includes a filter type to select one or more order items according to predefined criteria.

22. A method according to claim 13, wherein the definition includes a sort profile to prioritize the plurality of specific order items.

23. A user interface adapted to perform, at least in part, the steps of a method according to claim 13.

24. A computer readable storage medium storing instructions which when run on a computer controls the computer to perform a method for automatically selecting a plurality of specific order items from a plurality of order items, wherein the plurality of specific order items meet one or more predefined criteria, the method comprising: interfacing with a plurality of inbound data storage devices, in at least one of which the plurality of order items are stored as data; generating one or more order due lists having a definition according to the one or more predefined criteria, using the one or more order due lists as an index to select the plurality of specific order items meeting the one or more predefined criteria; filling the order due lists via the inbound interface with the data corresponding to the plurality of specific order items; and storing the filled order due lists in a database

25. A computer readable storage medium according to claim 24, wherein the order due list is a database element.

26. A computer readable storage medium according to claim 24, wherein the method further comprises aborting the selection when a predefined number of specific order items is reached.

27. A computer readable storage medium according to claim 24, wherein the one or more order due list functions as an index.

28. A computer readable storage medium according to claim 24, wherein the method further comprises saving the plurality of specific order items.

29. A computer readable storage medium according to claim 24, wherein the plurality of specific order items are stored in a buffer.

30. A computer readable storage medium according to claim 24, wherein the method further comprises building the one or more order due lists in accordance with customizable criteria.

31. A computer readable storage medium according to claim 24, wherein the definition includes a filter for filtering the plurality of order items.

32. A computer readable storage medium according to claim 31, wherein the filter includes a filter type to select one or more order items according to predefined criteria.

33. A computer readable storage medium according to claim 24, wherein the definition includes a sort profile to prioritize the plurality of specific order items.