Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the purchase order line fact:
Dimension | Type | Note |
---|---|---|
Buy-from Address | Conformed | tdpur400.otad |
Buy-from BP | Conformed | tdpur401.otbp |
Buyer | Conformed | tdpur400.ccon |
Carrier LSP | Conformed | tdpur401.cfrw |
Company | Conformed | tdpur401.compnr |
Financial Company | Conformed | Financial company of Financial Department tdpur400.fdpt |
Invoice-from BP | Conformed | tdpur400.ifbp |
Item | Conformed | tdpur401.item |
Manufacturer | Conformed | tdpur401.cmnf |
Pay-to BP | Conformed | tdpur400.ptbp |
PCS Project | Conformed | tdpur401.cprj |
Planner | Conformed | tdpur400.plnr |
Product Variant | Conformed | tdpur401.cpva |
Project | Conformed | tdpur401.cprj |
Purchase Contract Line | Domain specific | tdpur401.cono Contract tdpur401.pono Line tdpur401.cofc Purchase Office |
Purchase Office | Conformed | tdpur400.cofc |
Purchase Order | Domain specific | tdpur401.orno |
Purchase Order Line | Domain specific | tdpur401.orno + tdpur401.pono + tdpur401.sqnb |
Purchase Order Line Detail | Domain specific | Junk dimension |
Ship-from Address | Conformed | tdpur401.sfad |
Ship-from BP | Conformed | tdpur401.sfbp |
Ship-to Address | Conformed | tdpur401.cadr Warehouse Address |
Site | Conformed | tdpur401.site |
Supplier Item | Domain specific | tdpur401.citt Item Code System tdpur401.otbp Buy-from BP tdpur401.item Item |
Time | Birst | (1) End Date |
Transaction Currency | Conformed | tdpur400.ccur Order Currency |
Transaction Unit | Conformed | tdpur401.cuqp Purchase Unit |
Warehouse | Conformed | tdpur401.cwar |
(1) You can analyze measures by End Date, which is the Actual Receipt Date (current planned receipt date is used if the purchase order line not invoiced). The fact table also allows to analyze by Order Date, but expressions all use the End Date. Note that all dates are available in the Purchase Order Line dimension.