Multiple field look ahead and value help

• US 8,370,335 B2
• Filed: 12/07/2007
• Issued: 02/05/2013
• Est. Priority Date: 12/07/2007
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Ruth, Ralf, Klinger, Uwe
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US11/952,926
• Publication Number:
  US 20090150434A1
• Time in Patent Office: 1,887 Days
• Field of Search: 707/706, 707/715, 707/723, 707/735, 707/737, 707/769
• US Class Current: 707/723
• CPC Class Codes: G06F 16/3322 using system suggestions G06F16/3325 takes precedence

Abstract

Methods and apparatus, including computer program products, are provided for providing value help. In one aspect, there is provided a computer-implemented method. The method may include receiving, from a user interface, an input. Based on the received input, one or more fields may be determined from a plurality of columns of a table of a database. The determined one or more fields may be provided to the user interface for presentation as a value help to the input being presented at the user interface. Related apparatus, systems, methods, and articles are also described.

Claims

1. A non-transitory computer-readable medium containing instructions to configure a processor to perform a method, the method comprising:

receiving, from a user interface, a partial entry comprising one or more keyboard characters;

determining, based on the received partial entry, one or more first values determined by at least partially matching the partial entry to the one or more first values, the one or more first values coming from a plurality of columns of a table of a database; and

providing based on the determined one or more first values matched to the partial entry, one or more second values associated with the one or more first values, the one or more second values being from different columns than the one or more first values, the one or more second values being value help.

2. The non-transitory computer-readable medium of claim 1, wherein receiving further comprises:

receiving, from the user interface and a network, a message including the partial entry.

3. The non-transitory computer-readable medium of claim 1, wherein determining further comprises:

selecting from the plurality of columns the one or more first vales, the plurality of columns corresponding to one or more tables of the database implemented using Advanced Business Application Programming (ABAP).

4. The non-transitory computer-readable medium of claim 3, wherein selecting further comprises:

using a select command to select the one or more first values from the plurality of columns, the selection based on the partial entry.

5. The non-transitory computer-readable medium of claim 1, wherein determining further comprises:

generating an index from the plurality of columns.

6. The non-transitory computer-readable medium of claim 5 further comprising:

selecting the one or more first values from the generated index.

7. The non-transitory computer-readable medium of claim 1, wherein determining further comprises:

determining the one or more first values without an indication at the user interface indicating that value help is requested.

8. The non-transitory computer-readable medium of claim 1, wherein providing further comprises:

presenting at a window the input and presenting at the window the one or more second values as the value help.

9. The non-transitory computer-readable medium of claim 1 further comprising:

selecting, at the user interface, one of the one or more first values; and

inserting one of the one or more second values associated with the one of the one or more first values into the partial entry at the user interface.

10. A method comprising:

receiving, from a user interface, a partial entry comprising one or more keyboard characters;

determining, based on the received partial entry, one or more first values determined by at least partially matching the partial entry to the one or more

first values, the one or more first values coming from a plurality of columns of a table of a database; and

providing, based on the determined one or more first values matched to the partial entry, one or more second values associated with the one or more first values, the one or more second values being from different columns than the one or more first values, the one or more second values being value help, wherein at least one of the receiving, the determining, and the providing are implemented on at least one processor.

11. The method of claim 10, wherein receiving further comprises:

receiving, from the user interface and a network, a message including the partial entry.

12. The method of claim 10, wherein determining further comprises:

selecting from the plurality of columns the one or more first values, the plurality of columns corresponding to one or more tables of the database implemented using Advanced Business Application Programming (ABAP).

13. The method of claim 12, wherein selecting further comprises:

using a select command to select the one or more first values from the plurality of columns, the selection based on the partial entry.

14. The method of claim 10, wherein determining further comprises:

generating an index from the plurality of columns.

15. The method of claim 14 further comprising:

selecting the one or more first values from the generated index.

16. The method of claim 10, wherein determining further comprises:

determining the one or more first values without an indication at the user interface indicating that value help is requested.

17. The method of claim 10, wherein providing further comprises:

presenting at a window the partial entry and presenting at the window the one or more first values and the one or more second values as the value help;

selecting, at the user interface, one of a the one or more first values; and

inserting one of the one or more second values associated with the one of the one or more first values into the partial entry at the user interface.

18. A system comprising:

a processor; and

a memory, wherein the processor and the memory are configured to perform a method comprising;

receiving, from a user interface a partial entry comprising one or more keyboard characters;

determining, based on the received partial entry, one or more first values determined by at least partially matching the partial entry to the one or more first values, the one or more first values coming from a plurality of columns of a table of a database; and

providing, based on the determined one or more first values matched to the partial entry, one or more second values associated with the one or more first values, the one or more second values being from different columns than the one or more first values, the one or more second values being value help.

19. The system of claim 18, wherein receiving further comprises:

receiving, from the user interface and a network, a message including the partial entry.

20. The system of claim 18, wherein determining further comprises:

selecting from the plurality of columns the one or more first values, the plurality of columns corresponding to one or more tables of the database implemented using Advanced Business Application Programming (ABAP).