| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCapacity and Resource Planning |
| 1 | /MRSS/CF999 | Broadcast Targets | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| TOPData Collection |
| 2 | CF001 | Profitability Analysis | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 3 | CF050 | Balance sheet/P&L (FI/FILC) | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 4 | CF500 | IDES Investment | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 5 | CF501 | Test HGK | 3 | PLACTI | Plan/Ist Kennzeichen (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 6 | CF600 | HR Aspect | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 7 | CF650 | Profitability 1 | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 8 | CF665 | Attributes | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 9 | CF701 | IDES Marketing | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 10 | CF703 | IDES Profitability | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 11 | CF704 | IDES Sales Info Sys. | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 12 | CF705 | IDES Personnel Info | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 13 | CF706 | IDES Legal Cons. | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 14 | CF707 | IDES Insight | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 15 | CF709 | Consolidation Basic | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 16 | CF710 | IDES FPI | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 17 | CF711 | KPI | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 18 | CF712 | EC Integration: EVA | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 19 | CF714 | Strategic Planning | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 20 | CF715 | IDES:PCA-Integration | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 21 | CF720 | Top EIS Aspect | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 22 | CF752 | MCBlack | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 23 | CF760 | MC Black SAP Belgium | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 24 | CF770 | | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 25 | CF800 | Aspekt Übung | 3 | PLACTI | Plan/Ist Kennzeichen (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 26 | CF880 | EC-BP | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 27 | CF899 | aspect 899 | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 28 | CF990 | | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 29 | CF994 | archive example | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 30 | CF995 | profitab: customers | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 31 | CF996 | profitability (rep.) | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 32 | CF998 | example aspect 998 | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 33 | CF999 | example aspect 999 | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 34 | CFNNN | Reference structure for aspect tables SAP-EIS | 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 35 | KCK710 | Comments for FPI | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 36 | KCK770 | Kommentar 770 | 4 | PLACTI | Plan/Ist Kennzeichen (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 37 | KCK880 | EC-BP | 4 | PLACTI | Plan/Ist Kennzeichen (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 38 | KCK899 | comments for 899 | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 39 | KCK996 | comments for 996 | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 40 | KCK999 | comment table 999 | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 41 | TKCCC | EIS: Currency translation with data entry / planning | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 42 | TKCUM | EIS: Conversion table of new fixed fields 4.0 | 4 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| TOPProfitability Analysis Basic Functions |
| 43 | K830001 | Summarization level KT: 400 KC 01 CF996 000001 | 7 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
| 44 | K830003 | Summarization level KT: 400 KC 01 CF996 000002 | 10 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | nvarchar | 1 | 0 | | |
