While implementing a business data warehouse for Sales data from SAP R3, it is essential to integrate the various conditions data (order and billing conditions) to the item level data. This document illustrates how to design the BW data model for efficient reporting.
Available @ Integrating Sales Conditions Data with Sales Item level Data in SAP BW