IP Library Granted Patent US 8,412,673
Granted Patent B2
US 8,412,673 · App. 12/847,873 · Granted Apr 2, 2013

Persistence of master data in a multi-tenant software delivery architecture

Inventors: Christof Weissenberger (Sinsheim, DE); Christoph Lehner (Heidelberg, DE); Gururaj Raman (Bad Schoenborn, DE); Wolfgang Nieswand (Muhlhausen, DE)
Assignee: SAP AG
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,412,673
App. No.
12/847,873
Granted
Apr 2, 2013
Kind
B2
Abstract

A first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture can maintain a first record designating a first predefined generic field of a plurality of predefined generic fields. The first record can include an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server. Each customer tenant of the plurality of customer tenants can provide a discrete organization-specific business configuration of a core software platform. A second tenant-nonspecific database table maintained on the repository can maintain a second record that can include a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field. A calculation or determination based on master data can be performed that is relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value.

Claims (83)

1. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one processor, cause the at least one processor to perform operations comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

moving the first customer tenant to a second multi-tenant software architecture comprising a second application server and a second repository, the moving comprising:

moving the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository;

extracting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table; and

adding the extracted second record and any other records to a target second tenant-nonspecific database table on the second repository.

2. A computer program product as in claim 1 , wherein the operations further comprise: presenting, to an authorized user of the first customer tenant, a master data table comprising the organization-specific master data value and only other master data relevant to the first customer tenant.

3. A computer program product as in claim 2 , wherein the master data table comprises a master data record having at least one master data field, the at least one master data field comprising the organization-specific master data value.

4. A computer program product as in claim 1 , wherein the calculation or determination based on master data comprises a pricing calculation.

5. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one processor, cause the at least one processor to perform operations comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

copying the first customer tenant to a second customer tenant on the multi-tenant software architecture, the copying comprising:

creating a copy of the first tenant-specific generic field definition field in the first tenant-nonspecific database table;

duplicating the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant in the second tenant-nonspecific database table; and

changing the key values of the duplicated second record and any other records to designate the second customer tenant.

6. A computer program product comprising a machine-readable medium storing instructions that, when executed by at least one processor, cause the at least one processor to perform operations comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

deleting the first customer tenant from the multi-tenant software architecture, the deleting comprising:

deleting the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository; and

deleting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table.

7. A system comprising:

at least one processor; and

a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data that is relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

copying the first customer tenant to a second customer tenant on the multi-tenant software architecture, the copying comprising:

creating a copy of the first tenant-specific generic field definition field in the first tenant-nonspecific database table;

duplicating the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant in the second tenant-nonspecific database table; and

changing the key values of the duplicated second record and any other records to designate the second customer tenant.

8. A system as in claim 7 , wherein the operations further comprise: presenting, to an authorized user of the first customer tenant, a master data table comprising the organization-specific master data value and only other master data relevant to the first customer tenant.

9. A system as in claim 8 , wherein the master data table comprises a master data record having at least one master data field, the at least one master data field comprising the organization-specific master data value.

10. A system as in claim 7 , wherein the calculation or determination based on master data comprises a pricing calculation.

11. A system comprising:

at least one processor; and

a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

moving the first customer tenant to a second multi-tenant software architecture comprising a second application server and a second repository, the moving comprising:

moving the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository;

extracting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table; and

adding the extracted second record and any other records to a target second tenant-nonspecific database table on the second repository.

12. A system comprising:

at least one processor; and

a machine-readable medium storing instructions that, when executed by the at least one processor, cause the at least one processor to perform operations comprising maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

deleting the first customer tenant from the multi-tenant software architecture, the deleting comprising:

deleting the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository; and

deleting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table.

13. A computer-implemented method comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data that is relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

deleting the first customer tenant from the multi-tenant software architecture, the deleting comprising:

deleting the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository; and

deleting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table.

14. A computer-implemented method as in claim 13 , further comprising: presenting, to an authorized user of the first customer tenant, a master data table comprising the organization-specific master data value and only other master data relevant to the first customer tenant.

15. A computer-implemented method as in claim 14 , wherein the master data table comprises a master data record having at least one master data field, the at least one master data field comprising the organization-specific master data value.

16. A system as in claim 13 , wherein the calculation or determination based on master data comprises a pricing calculation.

17. A computer-implemented method comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server, each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

moving the first customer tenant to a second multi-tenant software architecture comprising a second application server and a second repository, the moving comprising:

moving the first tenant-specific generic field definition field from the first tenant-nonspecific database table on the repository to a target first tenant-nonspecific database table on the second repository;

extracting the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant from the second tenant-nonspecific database table; and

adding the extracted second record and any other records to a target second tenant-nonspecific database table on the second repository.

18. A computer-implemented method comprising:

maintaining, in a first tenant-nonspecific database table on a repository accessible to an application server of a multi-tenant software delivery architecture, a first record designating a first predefined generic field of a plurality of predefined generic fields and comprising an organization-specific master data field definition of the first predefined generic field maintained in a first tenant-specific definition field assigned to a first customer tenant of a plurality of customer tenants that are accessible via the application server each customer tenant of the plurality of customer tenants providing a discrete organization-specific business configuration of a core software platform;

maintaining, in a second tenant-nonspecific database table maintained on the repository, a second record comprising a key value designating the first tenant, a record designator, and an organization-specific master data value corresponding to the first predefined generic field;

performing a calculation or determination based on master data relevant to the discrete organization-specific business configuration provided by the first customer tenant using the organization-specific master data value; and

copying the first customer tenant to a second customer tenant on the multi-tenant software architecture, the copying comprising:

creating a copy of the first tenant-specific generic field definition field in the first tenant-nonspecific database table;

duplicating the second record and any other records in the second tenant-nonspecific database table having key values designating the first tenant in the second tenant-nonspecific database table; and

changing the key values of the duplicated second record and any other records to designate the second customer tenant.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0334 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 26, 2010
From: WEISSENBERGER, CHRISTOF; LEHNER, CHRISTOPH; RAMAN, GURURAJ; NIESWAND, WOLFGANG
To: SAP AG
Reel/Frame 024910/0705 →
Continuity (1)
Related Publication 20120030168A1 · Feb 2, 2012