Understanding Based On Tables

You can set up calculations so that the system creates driver balance entries that are based on information in master tables, such as the Sales Order Detail File table (F4211) for the number of sales orders per customer or the Work Order Master File table (F4801) for the quantity shipped by item. When you run the Driver Calculations program (R1632), the system populates the Driver Balances table (F1632) with data from the based-on tables for the drivers that you choose to run.

The following table shows the tables on which you can base driver calculations and examples of data that you can gather from the tables when you run the Driver Calculations program:

Table	Examples of Data
F03012 (Customer Master by Line of Business)	Number of customers who request printed statements. Number of different tax entities per customer.
F03B11 (Customer Ledger)	Invoice amounts by customer. Number of customers per region.
F03B14 (Receipts Detail)	Average number of invoices paid per receipt. Average discount taken per invoice. Amount of gain or loss for currency conversion by invoice paid.
F0401 (Supplier Master)	Amount vouchered year-to-date by supplier. Number of suppliers per region.
F0411 (Accounts Payable Ledger)	Number of invoices paid by supplier. Invoice amounts by supplier.
F0414 (Accounts Payable Matching Document Detail)	Average number of vouchers per check issued. Amount of gain or loss for currency conversion by invoice paid.
F0618 (Employee Transaction History)	Number of employees by job type. Average hourly rate by job type.
F0911 (Account Ledger)	Number of adjustments for automatic journal entries by account. Number of voided transactions by user.
F3112 (Work Order Routing)	Production hours by work center. Production hours by item. Quantity produced by work center.
F31122 (Work Order Time Transactions)	Number of service work orders by item. Number of units scrapped by item.
F4101 (Item Master)	Margin ranking by buyer. Average shelf life by item.
F4102 (Item Branch File)	Number of items for which components in a bill of material are issued manually.
F4111 (Item Ledger File)	On-hand inventory by item.
F4211 (Sales Order Detail File) Note: When you select table F4211, the system displays an additional field so that you can choose whether to retrieve information from table F4211, from the Sales Order History File table (F42119), or from both tables.	Number of sales orders per item. Number of sales orders per customer group. Number of quote orders per item.
F4311 (Purchase Order Detail File)	Number of purchase orders per item. Quantity purchased by supplier. Number of purchase orders per buyer.
F4801 (Work Order Master File)	Number of work orders per item.
F4942 (Shipment Detail)	Number of shipments by ship-to address. Total shipment weight by postal code.
F4981 (Freight Audit History)	Number of purchase orders containing freight per supplier. Number of sales orders containing freight per customer.