Sales Order Line
The Sales Order Line fact includes measures based on Sales Orders (tdsls400), Sales Order Lines (tdsls401), and Commissions/Rebates (tdcms050).
The Sales Order Lines (tdsls401) table stores delivery lines at the lowest level: you notice this for count measures and ratios that are based on count measures.
Transformation of extracted data:
- Deleted lines
- Deleted sales order lines are stored in the Sales Order Line fact table. Closed sales order lines that are deleted are available for analysis. However, sales order lines that are deleted, but are not closed yet, are hidden in the fact table and are not available for analysis.
- Canceled lines
- Canceled sales order lines are stored in the fact table but are always hidden and not available for analysis.
- Total lines
- Sales order lines can be of type detail, back order, or total. Total lines are an aggregate of the detail delivery lines. Consequently, total lines are not stored in the fact table to avoid overcounting.
- Change requests
- Change requests are not stored in the fact table.
This diagram shows the star schema:
