# US 11,442,957 B2 · Cloud-based fiscal year variant conversion > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,442,957 B2 - Document ID: US11442957B2 - Status: Granted - Kind: B2 - Application number: 16/691,350 - Filed: 2019-11-21 - Published: 2021-03-04 - Granted: 2022-09-13 - Earliest claimed: 2019-09-03 - Assignees: Sap SE - Applicants: Sap SE - Inventors: Naveen Kumar R C; Sameer Singh Virdi - Web page: https://patentgrep.com/patent/US11442957B2 ## CPC - G06F 16/258: {Data format conversion from or to a database} - G06F 16/2282: {Tablespace storage structures; Management thereof} - G06Q 10/0631: Resource planning, allocation, distributing or scheduling for enterprises or organisations - G06Q 40/12: Accounting - H04L 9/3242: {involving keyed hash functions, e.g. message authentication codes [MACs], CBC-MAC or HMAC} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) ## Abstract A computer-implemented method is disclosed. In a deployed enterprise resource planning system implementing a first fiscal year variant, the method can configure a second fiscal year variant that is different from the first fiscal year variant. The method can identify a list of target tables in the deployed enterprise resource planning system that contains the first fiscal year variant. The method can convert the first fiscal year variant to the second fiscal year variant in the list of target tables. In certain embodiments, the method can replace the first fiscal year variant with the second fiscal year variant in a reference framework interfacing with the list of target tables. ## Claims ### Claim 1 A computer-implemented method, implemented by one or more computing devices comprising at least one hardware processor and one or more tangible memories coupled to the at least one hardware processor, the method comprising: in a deployed cloud-based enterprise resource planning system implementing a first fiscal year variant, configuring a second fiscal year variant through a computer interface of the deployed cloud-based enterprise resource planning system, wherein the second fiscal year variant is different from the first fiscal year variant; identifying a list of target tables in the deployed cloud-based enterprise resource planning system that contains the first fiscal year variant; converting the first fiscal year variant to the second fiscal year variant in the list of target tables; replacing the first fiscal year variant with the second fiscal year variant in a reference framework interfacing with the list of target tables, wherein the reference framework comprises runtime data, wherein the runtime data comprises a plurality of storage entities containing references to the first fiscal year variant or the second fiscal year variant; and updating a hashed key after replacing the first fiscal year variant with the second fiscal year variant in the reference framework. ### Claim 2 (depends on 1) The method of claim 1, wherein the plurality of storage entities comprise respective keystrings, wherein a keystring comprises a predefined text pattern followed by a first fiscal year variant identifier representing the first fiscal year variant or a second fiscal year variant identifier representing the second fiscal year variant, and wherein the keystring corresponds to a unique identifier that remains constant after changing the first fiscal year variant identifier to the second fiscal year variant identifier. ### Claim 3 (depends on 2) The method of claim 2, wherein updating the hashed key comprises applying a hash function to the keystring containing the predefined text pattern followed by the second fiscal year variant identifier which replaces the first fiscal year variant identifier. ### Claim 4 (depends on 1) The method of claim 1, wherein converting the first fiscal year variant to the second fiscal year variant in the list of target tables and replacing the first fiscal year variant with the second fiscal year variant in the reference framework are scheduled to occur in a period when no business transaction involving the first fiscal year variant. ### Claim 5 (depends on 2) The method of claim 2, wherein replacing the first fiscal year variant with the second fiscal year variant in the reference framework comprises: identifying the plurality of storage entities in the reference framework; searching for the predefined text pattern in the identified plurality of storage entities that are followed by the first fiscal year variant identifier; and for one or more found predefined text patterns in the identified plurality of storage entities that are followed by the first fiscal year variant identifier, replacing the first fiscal year variant identifier with the second fiscal year variant identifier. ### Claim 6 (depends on 1) The method of claim 1, wherein configuring the second fiscal year variant comprises changing a start date of the first fiscal year variant to a new start date of the second fiscal year variant through the computer interface of the deployed cloud-based enterprise resource planning system. ### Claim 7 (depends on 1) The method of claim 1, wherein configuring the second fiscal year variant comprises changing a set of bookkeeping periods of the first fiscal year variant to a new set of bookkeeping periods of the second fiscal year variant through the computer interface of the deployed cloud-based enterprise resource planning system. ### Claim 8 (depends on 7) The method of claim 7, further comprising: responsive to changing the start date of the first fiscal year variant to the new start date of the second fiscal year variant, constructing a shortened fiscal year that has less than 365 days before converting the first year variant to the second fiscal year variant in the list of target table and replacing the first fiscal year variant with the second fiscal year variant in the reference framework. ### Claim 9 (depends on 1) The method of claim 1, wherein identifying the list of target tables comprises: in a repository in the deployed enterprise resource planning system, searching for a domain parameter that contains a predefined identifier representing the first fiscal year variant, wherein the repository comprises a schema containing a complete list of database tables and respective fields in the database tables. ### Claim 10 (depends on 1) The method of claim 1, wherein: the list of target tables are located in a cloud-based backend tenant of the deployed enterprise resource planning system; and the reference framework is configured to modify the list of target tables upon receiving an upgrade directive from a service provider, wherein the upgrade directive specifies new features or functionalities to be implemented in the deployed enterprise resource planning system. ### Claim 11 A system comprising: one or more processors; and memory coupled to the one or more processors comprising instructions causing the one or more processors to perform operations comprising: in a deployed cloud-based enterprise resource planning system implementing a first fiscal year variant, configuring a second fiscal year variant through a computer interface of the deployed cloud-based enterprise resource planning system, wherein the second fiscal year variant is different from the first fiscal year variant; identifying a list of target tables in the deployed cloud-based enterprise resource planning system that contains the first fiscal year variant; converting the first fiscal year variant to the second fiscal year variant in the list of target tables; replacing the first fiscal year variant with the second fiscal year variant in a reference framework interfacing with the list of target tables, wherein the reference framework comprises runtime data, wherein the runtime data comprises a plurality of storage entities containing references to the first fiscal year variant or the second fiscal year variant; and updating a hashed key after replacing the first fiscal year variant with the second fiscal year variant in the reference framework. ### Claim 12 (depends on 11) The system of claim 11, wherein the plurality of storage entities comprise respective keystrings, wherein a keystring comprises a predefined text pattern followed by a first fiscal year variant identifier representing the first fiscal year variant or a second fiscal year variant identifier representing the second fiscal year variant, and wherein the keystring corresponds to a unique identifier that remains constant after changing the first fiscal year variant identifier to the second fiscal year variant identifier. ### Claim 13 (depends on 12) The system of claim 12, wherein the operations further comprise: identifying the plurality of storage entities in the reference framework; searching for the predefined text pattern in the identified plurality of storage entities that are followed by the first fiscal year variant identifier; and for one or more found predefined text patterns in the identified plurality of storage entities that are followed by the first fiscal year variant identifier, replacing the first fiscal year variant identifier with the second fiscal year variant identifier. ### Claim 14 (depends on 12) The system of claim 12, wherein updating the hashed key comprises applying a hash function to the keystring containing the predefined text pattern followed by the second fiscal year variant identifier which replaces the first fiscal year variant identifier. ### Claim 15 (depends on 11) The system of claim 11, wherein configuring the second fiscal year variant comprises changing a start date of the first fiscal year variant to a new start date of the second fiscal year variant through the computer interface of the deployed cloud-based enterprise resource planning system. ### Claim 16 (depends on 11) The system of claim 11, wherein configuring the second fiscal year variant comprises changing a set of bookkeeping periods of the first fiscal year variant to a new set of bookkeeping periods of the second fiscal year variant through the computer interface of the deployed cloud-based enterprise resource planning system. ### Claim 17 (depends on 15) The system of claim 15, wherein the operations further comprises: responsive to changing the start date of the first fiscal year variant to the new start date of the second fiscal year variant, constructing a shortened fiscal year that has less than 365 days before converting the first year variant to the second fiscal year variant in the list of target table and replacing the first fiscal year variant with the second fiscal year variant in the reference framework. ### Claim 18 (depends on 11) The system of claim 11, wherein identifying the list of target tables comprises: in a repository in the deployed enterprise resource planning system, searching for a domain parameter that contains a predefined identifier representing the first fiscal year variant, wherein the repository comprises a schema containing a complete list of database tables and respective fields in the database tables. ### Claim 19 (depends on 11) The system of claim 11, wherein: the list of target tables are located in a cloud-based backend tenant of the deployed enterprise resource planning system; and the reference framework is configured to modify the list of target tables upon receiving an upgrade directive from a service provider, wherein the upgrade directive specifies new features or functionalities to be implemented in the deployed enterprise resource planning system. ### Claim 20 One or more non-transitory computer-readable media having encoded thereon computer-executable instructions causing one or more processors to perform a method comprising: in a deployed cloud-based enterprise resource planning system implementing a first fiscal year variant, configuring a second fiscal year variant, wherein the second fiscal year variant is different from the first fiscal year variant; identifying a list of target tables in the deployed cloud-based enterprise resource planning system that contains the first fiscal year variant; converting the first fiscal year variant to the second fiscal year variant in the list of target tables; replacing the first fiscal year variant with the second fiscal year variant in a reference framework interfacing with the list of target tables, wherein the reference framework comprises runtime data, wherein the runtime data comprises a plurality of storage entities containing references to the first fiscal year variant or the second fiscal year variant; and updating a hashed key after replacing the first fiscal year variant with the second fiscal year variant in the reference framework, wherein the plurality of storage entities comprise respective keystrings, wherein a keystring comprises a predefined text pattern followed by a first fiscal year variant identifier representing the first fiscal year variant or a second fiscal year variant identifier representing the second fiscal year variant, and wherein the keystring corresponds to a unique identifier that remains constant after changing the first fiscal year variant identifier to the second fiscal year variant identifier; wherein identifying the list of target tables comprises: in a repository in the deployed enterprise resource planning system, searching for a domain parameter that contains a predefined identifier representing the first fiscal year variant, wherein the repository comprises a schema containing a complete list of database tables and respective fields in the database tables; wherein replacing the first fiscal year variant with the second fiscal year variant in the reference framework comprises: identifying the plurality of storage entities in the reference framework; searching for the predefined text pattern in the identified plurality of storage entities that are followed by the first fiscal year variant identifier representing; and for one or more found predefined text patterns in the identified plurality of storage entities that are followed by the first fiscal year variant identifier, replacing the first fiscal year variant identifier with the second fiscal year variant identifier; wherein updating the hashed key comprises applying a hash function to the keystring containing the predefined text pattern followed by the second fiscal year variant identifier which replaces the first fiscal year variant identifier.