US 12,346,314 B1
Intelligent query response in ERP systems using generative AI
Rodrigo Guerra, Schwetzingen (DE); and Rudolf Wenzler, Besigheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Jul. 16, 2024, as Appl. No. 18/774,702.
Int. Cl. G06F 7/00 (2006.01); G06F 16/23 (2019.01); G06F 16/242 (2019.01)
CPC G06F 16/2428 (2019.01) [G06F 16/235 (2019.01); G06F 16/243 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A computing system with intelligent query response in an enterprise resource planning (ERP) system, the computing system comprising:
memory;
one or more hardware processors coupled to the memory; and
one or more computer readable storage media storing instructions that, when loaded into the memory, cause the one or more hardware processors to perform operations comprising:
receiving, from a user interface of an ERP system, a natural language user query for processing data of a target object maintained by the ERP system;
determining, in runtime, an intent based on the natural language user query;
invoking, in runtime, a function call through an application programming interface of the ERP system based on the natural language user query, wherein invoking the function call comprises:
extracting, in runtime, denormalized data from one or more database tables associated with the target object;
generating, in runtime, a prompt using a selected prompt template, wherein generating the prompt comprises replacing one or more parameters in the selected prompt template with the denormalized data retrieved from the one or more database tables;
prompting, in runtime, a large language model using the prompt; and
receiving a response generated by the large language model; and
generating an output on the user interface of the ERP system based on the response generated by the large language model,
wherein extracting the denormalized data comprises replacing, in runtime, at least some attributes or data values stored in the one or more database tables with respective text descriptions from a metadata store associated with the one or more database tables,
wherein invoking the function call comprises setting an operation mode of the application programming interface of the ERP system, wherein the selected prompt template is specific to the operation mode.