| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | CF002 | Human Resources | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 2 | CF004 | Stock Prices | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| Capacity and Resource Planning | ||||||||||
| 3 | /MRSS/CF999 | Broadcast Targets | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| Data Collection | ||||||||||
| 4 | CF001 | Profitability Analysis | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 5 | CF003 | Projects | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 6 | CF005 | Personnel Information | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 7 | CF006 | Balance Sheet | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 8 | CF050 | Balance sheet/P&L (FI/FILC) | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 9 | CF500 | IDES Investment | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 10 | CF501 | Test HGK | 4 | YEARB | Geschäftsjahr | nvarchar | 4 | 0 | ||
| 11 | CF600 | HR Aspect | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 12 | CF650 | Profitability 1 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 13 | CF665 | Attributes | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 14 | CF701 | IDES Marketing | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 15 | CF703 | IDES Profitability | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 16 | CF704 | IDES Sales Info Sys. | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 17 | CF705 | IDES Personnel Info | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 18 | CF706 | IDES Legal Cons. | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 19 | CF707 | IDES Insight | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 20 | CF708 | IDES: Setup Example | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 21 | CF709 | Consolidation Basic | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 22 | CF710 | IDES FPI | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 23 | CF711 | KPI | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 24 | CF712 | EC Integration: EVA | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 25 | CF714 | Strategic Planning | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 26 | CF715 | IDES:PCA-Integration | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 27 | CF720 | Top EIS Aspect | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 28 | CF750 | MCRED | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 29 | CF751 | MCBLUE | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 30 | CF752 | MCBlack | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 31 | CF760 | MC Black SAP Belgium | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 32 | CF770 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | |||
| 33 | CF800 | Aspekt Übung | 4 | YEARB | Geschäftsjahr | nvarchar | 4 | 0 | ||
| 34 | CF880 | EC-BP | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 35 | CF899 | aspect 899 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 36 | CF990 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | |||
| 37 | CF994 | archive example | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 38 | CF995 | profitab: customers | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 39 | CF996 | profitability (rep.) | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 40 | CF998 | example aspect 998 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 41 | CF999 | example aspect 999 | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 42 | CFNNN | Reference structure for aspect tables SAP-EIS | 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 43 | KCK710 | Comments for FPI | 5 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 44 | KCK770 | Kommentar 770 | 5 | YEARB | Geschäftsjahr | nvarchar | 4 | 0 | ||
| 45 | KCK880 | EC-BP | 5 | YEARB | Geschäftsjahr | nvarchar | 4 | 0 | ||
| 46 | KCK899 | comments for 899 | 5 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 47 | KCK996 | comments for 996 | 5 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 48 | KCK999 | comment table 999 | 5 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| Profitability Analysis Basic Functions | ||||||||||
| 49 | K830002 | Summarization level ST: 400 KC 01 CF996 000001 | 2 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||
| 50 | K830004 | Summarization level ST: 400 KC 01 CF996 000002 | 2 | YEARB | Fiscal Year | nvarchar | 4 | 0 | ||