Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the sales order line fact:
| Dimension | Type | Note |
|---|---|---|
| Carrier LSP | Conformed | tdsls401.cfrw |
| Company | Conformed | tdsls401.compnr |
| Customer Item | Domain specific | tdsls401.citt Item Code System tdsls401.ofbp Sold-to BP tdsls401.item Item |
| External Sales Rep | Conformed | tdsls400.osrp |
| Financial Company | Conformed | Targeted using tdsls400.fdpt |
| Internal Sales Rep | Conformed | tdsls400.crep |
| Invoice-to BP | Conformed | tdsls400.itbp |
| Item | Conformed | tdsls401.item |
| Pay-by BP | Conformed | tdsls400.pfbp |
| PCS Project | Conformed | tdsls401.cprj |
| Product Variant | Conformed | tdsls401.cpva |
| Project | Conformed | tdsls401.cprj |
| Sales Contract Line | Domain specific | tdsls401.cono Contract tdsls401.cpon Position tdsls400.cofc Sales Office |
| Sales Office | Conformed | tdsls400.cofc |
| Sales Order | Domain specific | tdsls400.orno |
| Sales Order Line | Domain specific | tdsls401.orno Order tdsls401.pono Line tdsls401.sqnb Sequence Nr |
| Sales Order Line Detail | Domain specific | Junk dimension |
| Ship-to Address | Conformed | tdsls401.stad |
| Ship-to BP | Conformed | tdsls401.stbp |
| Site | Conformed | tdsls401.site |
| Sold-to Address | Conformed | tdsls400.ofad |
| Sold-to BP | Conformed | tdsls401.ofbp |
| Time | Birst | (1) End Date |
| Transaction Currency | Conformed | tdsls400.ccur |
| Transaction Unit | Conformed | tdsls401.cuqs |
| Warehouse | Conformed | tdsls401.cwar |
(1) You can analyze measures by End Date, which is the Invoice Date (planned delivery date is used if the sales order line is not invoiced). Note that all dates are available in the Sales Order Line dimension.