Data Object Definition
The Settled Orders dataset contains all Sales Orders which have been shipped & invoiced to customers. It does not contain the full orderbook - for example future orders or cancelled orders are not included, only orders which have been executed and have had a financial impact on the P&L. It is sourced from SAP COPA through BW query COPA03. It does contain the P&L at orderline level, i.e. for each orderline it shows cost & margin information which is not available in the regular Sales Order dataset.
In the context of Pricing and the Transparency Dashboard, this dataset is also known as the Sales Query or the P&L Query.
This data is currently being worked on and is planned to be available by end of Q3 2023.
Data Model
Additional Info & Comments
- Data lake source: In the pricing data lake, Settled Orders dataset are sourced mainly from COPA03. Only for composite material until jun2021, there is a file (from Cognos) used as source.