Multi-Item Access of Pricing Condition Tables

摘要

Various embodiments herein each include at least one of systems, methods, and software for multi-item access of pricing condition tables. Such embodiments generally retrieve applicable pricing conditions from each relevant pricing condition table in a single query for each product included in an order or invoicing document, or other document within which pricing data is provided. The retrieved pricing condition data may then be written to a buffer in memory and utilized in pricing products included in an order or invoice document. Such embodiments generally reduce a number of queries that are executed against pricing condition tables thereby increasing the efficiency of pricing activities.

主权项

1. A method comprising:
determining, through execution of instructions on at least one processor of at least one computing device, a pricing procedure for a document based on at least one of a document type and a customer identifier, the pricing procedure identifying ordered pricing condition types to apply to document items to be priced; for each identified pricing condition type, determining an access sequence of one or more pricing condition tables to obtain a sequence of pricing condition table identifiers for each identified pricing condition type; for each identified pricing condition type and according to the sequence of pricing condition table identifiers:
retrieving, in a single query from a pricing condition table of the respective pricing condition table identifier, a pricing condition record identifier for each document item to be priced; andfor each retrieved pricing condition record identifier, writing, to a first data structure buffered in a memory, a pricing condition type identifier, an order identifier of the respective pricing condition type, an identifier of the document item to be priced, and the pricing condition record identifier; and for each pricing condition record identifier included in the first data structure buffered in memory, retrieving pricing condition record data and writing the retrieved data to a second data structure buffered in memory; pricing each document item to be priced based on the data of the first and second data structures buffered in memory.