Data processing system and method for supply chain management

• US 7,730,022 B2
• Filed: 06/17/2004
• Issued: 06/01/2010
• Est. Priority Date: 12/12/2003
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Kühner, Ralf, Laub, Udo, Metz, Manfred
• Primary Examiner(s): Pham; Khanh B
• Application Number:
  US10/869,070
• Publication Number:
  US 20050131947A1
• Time in Patent Office: 2,175 Days
• Field of Search: 707/104.1
• US Class Current: 707/603
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

The data processing system has an online transactional processing (OLTP) system for receiving of reporting data from work centers of a production line. The production line is logically divided into shop areas. At the exits of each shop area where an intermediate product is completed one reporting point serves as exit point in order to report the completion of an intermediate production step. This data is stored in the OLTP system and retrieved at a later point of time in order to generate a table containing aggregated intermediate product quantities per shop area. This table is transferred to a financial data server for calculation of the value of work in progress.

Claims

1. A data processing system, comprising:

an online transactional processing system for receiving reporting data from a set of reporting points of work centers of a production line for producing a product, wherein the production line is logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the online transactional processing system comprising;

a) a database for storing the reporting data,

b) first processing means for generating a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database, and

c) first storage means for storing the first table, and

a server computer comprising;

a) second storage means for storing a second table comprising value increments per shop area,

b) second processing means for calculating a total value of the work in progress by means of the first and second tables, and

c) means for transferring the first table from the first storage means of the online transactional processing system to the second processing means of the server computer.

2. The data processing system of claim 1, wherein the reporting data comprises data indicative of an originating reporting point and of a quantity of an intermediate product.

3. The data processing system of claim 1, wherein the database comprises a relational database.

4. The data processing system of claim 1, wherein the online transactional processing system further comprises:

means for querying the database to retrieve quantities of the intermediate products.

5. The data processing system of claim 1, the online transactional processing system further comprising:

timer means for initiating the generation of the first table.

6. The data processing system of claim 1, wherein the server computer further comprises:

an electronic ledger coupled to the second processing means.

7. The data processing system of claim 1, further comprising:

a master data server for storing routing data and data descriptive of the shop areas and exit points, the master data server being coupled to the online transactional processing system and to the server computer.

8. The data processing system of claim 7, wherein the server computer further comprises:

means for calculating the second table on the basis of master data stored on the master data server.

9. A computer readable medium comprising program instructions embodying a method for calculating of a value of work in progress, the program instructions comprising:

a first set of instructions for execution by a first processor of an online transactional processing system for receiving reporting data from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the reporting data being stored in a database, the first set of instructions operable to generate a first table comprising aggregated quantities of intermediate products at the exit points on the basis of the reporting data stored in the database and operable to store the first table in a first storage means of the online transactional processing system, and

a second set of instructions for execution by a second processor of a server computer coupled to the online transactional processing system, the server computer having second storage means for storing a second table comprising value increments per shop area, the second set of instructions operable to calculate a total value of the work in progress by means of the first and second tables.

10. The computer readable medium of claim 9, further comprising:

a third set of instructions for initiating a transfer of the first table from the first storage means of the online transactional processing system to the server computer.

11. The computer readable medium of claim 9, further comprising:

a fourth set of instructions for performing a database query in order to retrieve quantities of the intermediate products.

12. The computer readable medium of claim 9, further comprising:

a fourth set of instructions for calculating the second table on the basis of master data stored on a master data server.

13. A method of calculating of a value of work in progress on the basis of reporting data received from a set of reporting points of work centers of a production line for producing a product, the production line being logically divided into shop areas, one reporting point of each shop area being an exit point corresponding to an intermediate production step, the method comprising the steps of:

receiving the reporting data by an online transactional processing system;

storing the reporting data in a database of the online transactional processing system;

generating a first table comprising aggregated quantities of intermediate products and aggregated scrap quantities reported from the exit points on the basis of the reporting data stored in the database;

storing the first table in first storage means of the online transactional processing system;

transferring of the first table from the first storage means to a server computer, the server computer having second storage means for storing a second table comprising value increments per shop area; and

calculating a total value of the work in progress by means of the first and second tables by the server computer.

14. The method of claim 13, further comprising:

performing a database query to retrieve quantities of the intermediate products and scrap quantities.

15. The method of claim 13, further comprising:

initiating the transfer of the first table from the first storage means of the online transactional processing system to the server computer at pre-scheduled time intervals or in response to a request received from the server computer.