Statistics Parameters (tdsta0100m000)

Field Information

Effective Date

The date and time the parameters are valid. The parameters are valid up to the effective date of a more recent parameter setting.

Parent BP Levels to Update

The way in which parent business partner data is updated when statistical data is updated in the Update Statistics (tdsta2250m000) session.

Allowed values

Individual Customer

LN updates the statistics for the customer that is indicated on the order, even if a parent customer is linked to the business partner on the order. Parent statistics are not kept.

Single Level Parent

LN updates the statistics for the parent customer that is linked to the order. If no parent customer is linked to the business partner on the order, LN uses the customer on the order (child) as the default.

Multi Level Parent

This value is similar to the Single Level Parent. In addition, LN checks the customer file and determines whether the parent customer is a child of another customer. If so, LN also updates the statistics for the next parent customer. The resulting tree structure enables you to post order lines to more than one customer.

Both Single Level

Statistics are updated at a single level for the child and the parent. If the business partner of the order doesn’t have a parent, statistics are only updated for the child. As a result, this method is a combination of the Individual Customer method and the Single Level Parent method.

Both Multi Level

Statistics are updated for child and all parents. As a result, this method is a combination of the Individual Customer method and the Multi Level Parent method.

Base Price for Gross Profit Calculation

Define how the gross profit percentage is calculated and displayed in statistics.

Allowed values

Standard Cost

The gross profit percentage is calculated as follows:

((TO - CO) ÷ CO) * 100%

Order Price

The gross profit percentage is calculated as follows:

	
((TO - CO) ÷ TO) * 100%

• TO - Turnover
• CO - Costs

Period Table

The period table determines the various periods of a year, including the period number, start date, and end date that are used in statistics.

You can define period tables in the Period Tables (tcccp0160m000) session.

Archiving Company

The archive company where statistical information is stored during archiving. This information is archived through the Archive/Delete Statistics (tdsta2250m100) session.

Detailed Discount Specification

This check box determines whether detailed discounts must be recorded for purchase discounts, sales discounts, rebates, and commissions.

If this check box is selected, the budgets for the discounts that are entered in the Budgets (tdsta2603m000) session can be sorted by discount code in the Sort Budget Data by Discount Type (tdsta2105m000) session. These divided budgets are registered in the statistics.

If this check box is cleared, discounts, commissions, and rebates will not be sorted by discount code.

Discount Code for Order Discount

If the Detailed Discount Specification check box is selected, the discount amounts of orders that do not contain a discount code, are accumulated to the discount code that is specified in this field. The discount amount for order lines that contain a discount code, are accumulated to the discount code of the order line.

If this field is left empty, and the Print detailed discounts check box is selected when printing the statistical results in the Print Statistics (tdsta2400m000) session, the total discount amount that is printed can be lower than the discount amount that is printed if the Print detailed discounts check box is cleared. The reason for this is that the discount amount of order lines without a discount code is not taken into account if this field is empty.

Note: You can only define this field if the Detailed Discount Specification check box is selected.

Discount Code for Promotional Discount

The promotional discounts that result from applied promotions are accumulated to the discount code specified in this field.

Note: 

• You can only define this field if the Detailed Discount Specification check box is selected.
• Premiums are stored in statistics as normal sales order lines.

Item for Customized Items

If a customized item is not derived from a standard item, which you can define in the Derived-from Item field of the Items (tcibd0501m000) session, you must define a standard item code to store the statistical data. This code can be used in the statistics to cumulate any customized item that is not derived from a standard item.

If the Derived-from Item field is filled for the customized item in the Items (tcibd0501m000) session, the customized item data is stored in the statistics under the standard item.

Item for Standard Items

If the Actual Data check box is selected when updating the statistics in the Update Statistics (tdsta2250m000) session, LN does not retrieve the item data from the sales order history or purchase order history sessions, but from the Items (tcibd0501m000) session. However, if item data is available in the history, but the item does not exist anymore in the Items (tcibd0501m000) session, LN retrieves the actual data for the item that is entered in the current field from the Items (tcibd0501m000) session.

Sales Intake Level

Select the level on which you want to update the sales order/schedule intake statistics. Sales intake refers to all sales orders/schedules that are entered in LN.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Intake Update Date

Select the date based on which the sales intake statistics are updated.

Allowed values

Order Date

The period to which the order intake, or the order cancellation must be posted is determined by the order date of the order history line. This date can differ from the transaction date or log date because the user enters the order date, but the log date is determined by LN.

Transaction Date

The period to which the order intake, or the order cancellation must be posted is determined by the transaction date or log date.

Delivery Date

The period to which the order intake, or the order cancellation must be posted is determined by the planned delivery date (sales) and the planned receipt date (purchase) of the order history line.

Sales Intake Update Date (CMS)

Select the date based on which the sales intake statistics are updated for commissions.

Allowed values

Calculation Date

The period to which the commission order intake, or the commission order cancellation must be posted is determined by the date on which the commission was calculated.

Transaction Date

The period to which the commission order intake, or the commission order cancellation must be posted is determined by the transaction date or log date of the commission history.

Sales Turnover Level

Select the level on which you want to update the sales turnover statistics. Sales turnover refers to all sales orders/schedules that are processed in the Sales Order Actual Delivery Line History (tdsls4556m000) session.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Turnover Update Date

Select the date based on which the sales turnover statistics are updated.

Allowed values

Delivery Date

The period to which the turnover must be posted is determined by the delivery date.

Invoice Date

The period to which the turnover must be posted is determined by the invoice date.

Default value

The Delivery Date is defaulted from the Actual Delivery Date and the Invoice Date is defaulted from the Invoice Date in the Sales Order Actual Delivery Line History (tdsls4556m000) session.

Sales Turnover Update Date (CMS)

Select the date based on which the sales turnover statistics are updated for commissions.

Allowed values

Invoice Date

The commission is determined at the commission invoice date.

Transaction Date

The commission is determined at the transaction date.

Commission turnover for employees is always based on the transaction date, irrespective of the parameter, because invoices are not created for employees.

Sales Cancellation Level

Select the level on which you want to update the sales cancellation statistics. Sales cancellation refers to all sales order/schedule lines that are entered and then deleted or canceled in LN.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Sales Cancellation Update Date

Select the date based on which the sales cancellation statistics are updated.

Allowed values

Order Date

The period to which the order intake, or the order cancellation must be posted is determined by the order date of the order history line. This date can differ from the transaction date or log date because the user enters the order date, but the log date is determined by LN.

Transaction Date

The period to which the order intake, or the order cancellation must be posted is determined by the transaction date or log date.

Delivery Date

The period to which the order intake, or the order cancellation must be posted is determined by the planned delivery date (sales) and the planned receipt date (purchase) of the order history line.

Sales Cancellation Update Date (CMS)

Select the date based on which the sales cancellation statistics are updated for commissions.

Allowed values

Calculation Date

The period to which the commission order intake, or the commission order cancellation must be posted is determined by the date on which the commission was calculated.

Transaction Date

The period to which the commission order intake, or the commission order cancellation must be posted is determined by the transaction date or log date of the commission history.

Sales Last Statistics Update Date

The date on which the sales statistics were updated last.

Note: This field is used for information purposes only and is filled when the Update Statistics (tdsta2250m000) session is used.

Sales Actual Level

Select the level on which you want to update the sales actual level statistics. Sales actual refers to the current (actual) sales business partner and sales item data.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Intake Level

Select the level on which you want to update the purchase order intake statistics. Purchase intake refers to all purchase orders/schedules that are entered in LN.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Intake Update Date

Select the date based on which the purchase intake statistics are updated.

Allowed values

Order Date

The period to which the order intake, or the order cancellation must be posted is determined by the order date of the order history line. This date can differ from the transaction date or log date because the user enters the order date, but the log date is determined by LN.

Transaction Date

The period to which the order intake, or the order cancellation must be posted is determined by the transaction date or log date.

Delivery Date

The period to which the order intake, or the order cancellation must be posted is determined by the planned delivery date (sales) and the planned receipt date (purchase) of the order history line.

Purchase Cancellation Level

Select the level on which you want to update the purchase cancellation statistics. Purchase cancellation refers to all purchase order/schedule lines that are entered and then deleted or canceled in LN.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Cancellation Update Date

Select the date based on which the purchase cancellation statistics are updated.

Allowed values

Order Date

The period to which the order intake, or the order cancellation must be posted is determined by the order date of the order history line. This date can differ from the transaction date or log date because the user enters the order date, but the log date is determined by LN.

Transaction Date

The period to which the order intake, or the order cancellation must be posted is determined by the transaction date or log date.

Delivery Date

The period to which the order intake, or the order cancellation must be posted is determined by the planned delivery date (sales) and the planned receipt date (purchase) of the order history line.

Purchase Turnover Level

Select the level on which you want to update the purchase turnover statistics. Purchase turnover refers to all purchase orders/schedules that are processed in LN.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.

Purchase Turnover Update Date

Select the date based on which the purchase turnover statistics are updated.

Allowed values

Receipt Date

The period to which the turnover must be posted is determined by the receipt date.

Transaction Date

The period to which the turnover must be posted is determined by the transaction date.

Purchase Turnover Update Date (Consignment)

Select the date based on which the purchase turnover statistics are updated for consignment.

Allowed values

Usage Date

The period to which the turnover must be posted is determined by the usage/consumption date.

Transaction Date

The period to which the turnover must be posted is determined by the transaction date.

Purchase Turnover Update Date (Stage Payment)

Select the date based on which the purchase turnover statistics are updated for supplier stage payments.

Allowed values

Release Date

The period to which the turnover must be posted is determined by the released date for the stage payment.

Transaction Date

The period to which the turnover must be posted is determined by the transaction date.

Purchase Last Statistics Update Date

The date on which the purchase statistics were updated last.

Note: This field is used for information purposes only and is filled when the Update Statistics (tdsta2250m000) session is used.

Purchase Actual Level

Select the level on which you want to update the purchase actual level statistics. Purchase actual refers to the current (actual) purchase business partner and purchase item data.

Note: You can select the level attributes (fields) that must be included in the statistics for this level and level type in the Statistics Level (tdsta0601m000) session.