Sales Schedule Line
The Sales Schedule Line facts include measures based on Sales Schedule (tdsls311) and Sales Schedule Lines (tdsls307).
Transformation of extracted data:
- Plan and actual lines
- Sales schedule lines with requirement type Planned are planned requirements. Sales schedule lines with requirement type Immediate or Firm are actual requirements. Measures for plan and actual sales schedule line should not be aggregated. To ensure this, two fact tables are populated: Sales Schedule Line Plan and Sales Schedule Line Actual. Both tables have the same dimensions. However, the planning fact table has less measures. For example, measures on delivery and invoicing are not supported.
- Deleted lines
- Deleted sales schedule lines are stored in the Sales Schedule Line fact tables. Processed or terminated sales schedule lines that are deleted remain available for analysis. However, sales schedule lines with status Created that are deleted, are hidden in the fact tables and are not available for analysis.
- Canceled lines and replaced lines
- Canceled sales schedule lines and replaced sales schedule lines are stored in the fact tables but are always hidden and not available for analysis. This also applies to schedule lines with the status Canceling in Process and Replacing in Process.
- Revision 0
- Sales schedule lines with revision 0 are not stored in the fact tables and are not available for analysis.
This diagram shows the star schema:
