| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CF002 | Human Resources | 13 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
2 | CF004 | Stock Prices | 9 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
3 | TRK10 | Table for reorg structure | 11 | RECNR | Number of the record in the archive hierarchy | nvarchar | 4 | 0 | | |
TOPBenefits |
4 | PA0172 | HR Master Record: Infotype 0172 (FSA Claims) | 31 | RECNR | Benefit receipt number | nvarchar | 20 | 0 | | |
TOPBudgeting |
5 | FMRBBRECS | Master Data For RIB: Budget Receivers per RIB Object | 8 | RECNR | Sequential Number of a Receiver in the RIB Process | nvarchar | 3 | 0 | | |
TOPBudgeting and Availability Control |
6 | GMRBBRECS | GM Master Data For RIB: Budget Receivers per RIB Object | 4 | RECNR | Sequential Number of a Receiver in the RIB Process | nvarchar | 3 | 0 | | |
TOPBusiness Consolidation |
7 | UCM1001 | Explicit Values: Values | 3 | RECNR | Record Number | nvarchar | 3 | 0 | | |
TOPCapacity and Resource Planning |
8 | /MRSS/CF999 | Broadcast Targets | 7 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
TOPData Collection |
9 | CF001 | Profitability Analysis | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
10 | CF003 | Projects | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
11 | CF005 | Personnel Information | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
12 | CF006 | Balance Sheet | 11 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
13 | CF050 | Balance sheet/P&L (FI/FILC) | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
14 | CF500 | IDES Investment | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
15 | CF501 | Test HGK | 9 | RECNR | Satznummer im RK-C | nvarchar | 8 | 0 | | |
16 | CF600 | HR Aspect | 9 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
17 | CF650 | Profitability 1 | 12 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
18 | CF665 | Attributes | 7 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
19 | CF701 | IDES Marketing | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
20 | CF703 | IDES Profitability | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
21 | CF704 | IDES Sales Info Sys. | 13 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
22 | CF705 | IDES Personnel Info | 15 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
23 | CF706 | IDES Legal Cons. | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
24 | CF707 | IDES Insight | 12 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
25 | CF708 | IDES: Setup Example | 11 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
26 | CF709 | Consolidation Basic | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
27 | CF710 | IDES FPI | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
28 | CF711 | KPI | 9 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
29 | CF712 | EC Integration: EVA | 12 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
30 | CF714 | Strategic Planning | 13 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
31 | CF715 | IDES:PCA-Integration | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
32 | CF720 | Top EIS Aspect | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
33 | CF750 | MCRED | 10 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
34 | CF751 | MCBLUE | 10 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
35 | CF752 | MCBlack | 11 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
36 | CF760 | MC Black SAP Belgium | 10 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
37 | CF770 | | 9 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
38 | CF800 | Aspekt Übung | 8 | RECNR | Satznummer im RK-C | nvarchar | 8 | 0 | | |
39 | CF880 | EC-BP | 10 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
40 | CF899 | aspect 899 | 7 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
41 | CF990 | | 8 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
42 | CF994 | archive example | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
43 | CF995 | profitab: customers | 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
44 | CF996 | profitability (rep.) | 14 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
45 | CF998 | example aspect 998 | 7 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
46 | CF999 | example aspect 999 | 10 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
47 | CFNNN | Reference structure for aspect tables SAP-EIS | 15 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
48 | KCK710 | Comments for FPI | 2 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
49 | KCK770 | Kommentar 770 | 2 | RECNR | Satznummer im RK-C | nvarchar | 8 | 0 | | |
50 | KCK880 | EC-BP | 2 | RECNR | Satznummer im RK-C | nvarchar | 8 | 0 | | |
51 | KCK899 | comments for 899 | 2 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
52 | KCK996 | comments for 996 | 2 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
53 | KCK999 | comment table 999 | 2 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | | |
TOPFrance |
54 | T5F6G | Batch header recording | 7 | RECNR | Record. No. of the file | nvarchar | 5 | 0 | | |
TOPGeneral Ledger Accounting |
55 | FAGL_BW_LOG_HEAD | FI-GL: Log for BW Extraction: Control Data | 5 | RECNR | Record number of the line item record | nvarchar | 18 | 0 | | |
56 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 5 | RECNR | Record number of the line item record | nvarchar | 18 | 0 | | |
57 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 5 | RECNR | Record number of the line item record | nvarchar | 18 | 0 | | |
58 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 3 | RECNR | Record number of the line item record | nvarchar | 18 | 0 | | |
TOPOverhead Cost Controlling |
59 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 3 | RECNR | Record number of the line item record | nvarchar | 18 | 0 | | |
TOPProfitability Analysis |
60 | TKETRPROT | Access Log for Summarization Levels | 3 | RECNR | Record Number for Access Log for Summarization Level | nvarchar | 6 | 0 | | |
TOPRemote Logistics Management |
61 | OIO_MX_MTSTA_HI | RLM tracking extract object status - high | 5 | RECNR | Record number for tracking extract | nvarchar | 6 | 0 | | |
62 | OIO_MX_MTSTA_LO | RLM tracking extract object status - low | 5 | RECNR | Record number for tracking extract | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
63 | TZKN6 | Allocation of charact. group to acct.ass.ref. via invoice no | 4 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |
64 | TZKN7 | Acct assignment reference via the invoice no. | 4 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |
65 | TZSZ6 | Alloc. of characteris.groups to clerk via invoice no. | 3 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |
66 | TZSZ7 | Clerk allocation via the invoice no. | 3 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |
TOPTreasury and Risk Management |
67 | VVWKN6 | Alloc. of charac.group to second.term via the invoice no. | 3 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |
68 | VVWKN7 | Charact.group - Secondary values alloc. (via the inv.no.) | 3 | RECNR | Logical record number in table | nvarchar | 4 | 0 | | |