Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the financial balance fact:
| Dimension | Type | Note |
|---|---|---|
| Accounts Receivable | Domain Specific | tfacr200.ttyp + tfacr200.ninv + tfacr200.line |
| Accounts Receivable Detail | Domain Specific | |
| ACR Credit Control | Domain Specific | (1) |
| ACR Document Type | Domain Specific | tfacr200.trec |
| Chart of Accounts | Conformed | tfacr200.leac |
| Company | Conformed | tfacr200.compnr |
| Dimension01 till Dimension12 | Conformed | Twelve separate dimensions tfacr200.dim1 till tfacr200.dim12 |
| Financial Company | Conformed | tfacr200.compnr |
| Financial Period | Conformed | (2) |
| Internal Sales Rep | Conformed | tfacr200.crep |
| Invoice-to BP | Conformed | tfacr200.itbp |
| Pay-by BP | Conformed | tfacr200.pfbp |
| Payment or Receipt Method | Conformed | tfacr200.paym |
| Payment Terms | Conformed | tfacr200.cpay |
| Receipt or Settlement | Domain specific | tfacr200.tdoc + tfacr200.docn + tfacr200.lino |
| Segment Type | Domain specific | tfacr200.sgtp (3) |
| Time | Birst | tfacr200.docd and tfacr200.dued Analyze by Date is enabled on the Document date and the Due Date. |
| Transaction Currency | Conformed | tfacr200.ccur |
- (1) The ACR Credit Control dimension is mapped through tfacr200.itbp + tfgld004.acdp. Attributes of this dimension are read from tccom122. If there is no credit control Invoice-to BP information for the accounting department, the values are retrieved from the empty department Invoice-to BP.
- (2) The Accounts Receivable fact table is targeted only to the fiscal calendars in the Financial Period dimension. The reporting calendars are not used. Mapping is done through tfacr200.year + tfacr200.prod + tfgld.ptyp.financial.
- (3) The Accounts Receivable fact table contains records of all segment types. To avoid data duplication in the aggregations, it is mandatory to filter on the correct segment types. Specific filter columns are available on the Segment Type dimension for this. Mapping is done through tfacr200.sgtp.