Granted Patent B2

US 12,619,592 · App. 18/075,679 · Granted May 5, 2026

Inventors: Wulf Kruempelmann (Altlussheim, DE); Volker Zirkel (Mannheim, DE)

Assignee: SAP SE

G06F16/2282G06F16/219G06F16/2365

Abstract

Claims (49)

1 . A computer-implemented method comprising:

receiving, by one or more processors, a request to generate a second database table corresponding to a new version of a first database table associated with a cloud-based system hosting a cloud-based software application, wherein the request includes a customized template having one or more customizations that are specific to a tenant, wherein the one or more customizations modify data that is stored in a first column from a first datatype to a second datatype, wherein the customized template is created based on a template selected by the tenant among a set of default templates, the tenant applying the one or more customizations to the selected template, and wherein the second database table is generated based on a difference between one or more datatypes of data stored in a particular column of the first database table and one or more datatypes specified by the customized template for the particular column including one or more of a numerical datatype, a character datatype, a date datatype, and a logical datatype;

determining, by the one or more processors, in response to the request, a content of the second database table using a same data structure as the first database table;

generating, by the one or more processors, a version identifier corresponding to the second database table as a branch number;

providing, by the one or more processors to an external database, the branch number and the second database table for storage;

performing, by the one or more processors, a validation of the second database table by verifying each entry of the content of the second database table, wherein the validation comprises verifying the second datatype of the data stored in the first column;

storing, in the external database, the validated second database table mapped to the branch number;

alerting, by a database trigger of a customizing engine, a development system when the second database table is generated with the branch number to enable the second database table to be propagated to a test system and a productive system; and

controlling, by the one or more processors, a deployment, to the test system and the productive system, of the second database table, for the second database table to be used when executing the cloud-based software application,

wherein the deployment, to the test system and the productive system, of the second database table comprises reading entries of the second database table directly from the external database using the branch number without replicating the second database table.

2 . The computer-implemented method of claim 1 , wherein controlling, by the one or more processors, the deployment, to the test system and the productive system, of the second database table is based on a schedule associated with the branch number of the second database table, the schedule indicating a time for switching from an old version of the first database table to the new version of the first database table based on one or more factors including a rule change, a code change, or an entity change, and wherein the computer-implemented method further comprises:

generating a deployment approval for enabling the deployment, to the test system and the productive system, of the second database table to match a timing of a change associated with the one or more factors.

3 . The computer-implemented method of claim 2 , further comprising:

storing the first database table in an original database different from the external database.

4 . The computer-implemented method of claim 1 , wherein the request to generate the second database table is provided by an external customizing repository configured to directly write data in the external database.

5 . The computer-implemented method of claim 1 , wherein the one or more customizations applied to the selected template by the tenant modify a manner in which data is stored in the second database table.

6 . The computer-implemented method of claim 1 , wherein the difference is determined based on a comparison of the data stored in the particular column of the first database table against the customized template.

7 . A non-transitory computer-readable storage medium comprising programming code, which when executed by at least one processor, causes operations comprising:

receiving a request to generate a second database table corresponding to a new version of a first database table associated with a cloud-based system hosting a cloud-based software application, wherein the request includes a customized template having one or more customizations that are specific to a tenant, wherein the one or more customizations modify data that is stored in a first column from a first datatype to a second datatype, wherein the customized template is created based on a template selected by the tenant among a set of default templates, the tenant applying the one or more customizations to the selected template, and wherein the second database table is generated based on a difference between one or more datatypes of data stored in a particular column of the first database table and one or more datatypes specified by the customized template for the particular column including one or more of a numerical datatype, a character datatype, a date datatype, and a logical datatype;

determining, in response to the request, a content of the second database table using a same data structure as the first database table;

generating a version identifier corresponding to the second database table as a branch number;

providing, to an external database, the branch number and the second database table for storage;

performing, by the at least one processor, a validation of the second database table by verifying each entry of the content of the second database table, wherein the validation comprises verifying the second datatype of the data stored in the first column;

storing, in the external database, the validated second database table mapped to the branch number;

alerting, by a database trigger of a customizing engine, a development system when the second database table is generated with the branch number to enable the second database table to be propagated to a test system and a productive system; and

controlling a deployment, to the test system and the productive system, of the second database table, for the second database table to be used when executing the cloud-based software application,

wherein the deployment, to the test system and the productive system, of the second database table comprises reading entries of the second database table directly from the external database using the branch number without replicating the second database table.

8 . The non-transitory computer-readable storage medium of claim 7 , wherein controlling the deployment, to the test system and the productive system, of the second database table is based on a schedule associated with the branch number of the second database table, the schedule indicating a time for switching from an old version of the first database table to the new version of the first database table based on one or more factors including a rule change, a code change, or an entity change, and wherein the operations further comprise:

generating a deployment approval for enabling the deployment, to the test system and the productive system, of the second database table to match a timing of a change associated with the one or more factors.

9 . The non-transitory computer-readable storage medium of claim 8 , wherein the operations further comprise:

storing the first database table in an original database different from the external database.

10 . The non-transitory computer-readable storage medium of claim 7 , wherein the request to generate the second database table is provided by an external customizing repository configured to directly write data in the external database.

11 . A system comprising:

at least one processor; and

at least one memory storing instructions, which when executed by the at least one processor, cause operations comprising:

receiving a request to generate a second database table corresponding to a new version of a first database table associated with a cloud-based system hosting a cloud-based software application, wherein the request includes a customized template having one or more customizations that are specific to a tenant, wherein the one or more customizations modify data that is stored in a first column from a first datatype to a second datatype, wherein the customized template is created based on a template selected by the tenant among a set of default templates, the tenant applying the one or more customizations to the selected template, and wherein the second database table is generated based on a difference between one or more datatypes of data stored in a particular column of the first database table and one or more types specified by the customized template for the particular column including one or more of a numerical datatype, a character datatype, a date datatype, and a logical datatype;

determining, in response to the request, a content of the second database table using a same data structure as the first database table;

generating a version identifier corresponding to the second database table as a branch number;

providing, to an external database, the branch number and the second database table for storage;

performing, by the at least one processor, a validation of the second database table by verifying each entry of the content of the second database table, wherein the validation comprises verifying the second datatype of the data stored in the first column;

storing, in the external database, the validated second database table mapped to the branch number;

alerting, by a database trigger of a customizing engine, a development system when the second database table is generated with the branch number to enable the second database table to be propagated to a test system and a productive system; and

controlling a deployment, to the test system and the productive system, of the second database table, for the second database table to be used when executing the cloud-based software application,

wherein the deployment, to the test system and the productive system, of the second database table comprises reading entries of the second database table directly from the external database using the branch number without replicating the second database table.

12 . The system of claim 11 , wherein controlling the deployment, to the test system and the productive system, of the second database table is based on a schedule associated with the branch number of the second database table, the schedule indicating a time for switching from an old version of the first database table to the new version of the first database table based on one or more factors including a rule change, a code change, or an entity change, and wherein the operations further comprise:

generating a deployment approval for enabling the deployment, to the test system and the productive system, of the second database table to match a timing of a change associated with the one or more factors.

13 . The system of claim 12 , wherein the operations further comprise:

storing the first database table in an original database different from the external database.

14 . The system of claim 11 , wherein the request to generate the second database table is provided by an external customizing repository configured to directly write data in the external database.

Assignments (1)

Continuity (1)

References Cited (9)