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.