| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TBVZ | CO-PA report library (no longer used) | 17 | TFLAG | Flag to connect text in the CO-PA Information System | nvarchar | 1 | 0 | | |
TOPAnalyzer |
2 | AFWCH_FCAT_SAMP | AFW: Sample Customizing Characteristics | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
TOPConsolidation |
3 | TF90F | Active Field Catalog, Consolidation | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
4 | TF90S | Basis Field Catalog Consolidation (Fixed Fields) | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
5 | TF91F | Field Catalog, Consolidation | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
6 | TF9N1 | Master Data Table: & | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
TOPData Collection |
7 | T242B | Characteristic values per characteristic | 5 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
8 | T242P | Window management | 12 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
9 | T2700 | Master data table: Region | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
10 | T2701 | Master data table: Brand | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
11 | T2702 | Master data table: Production group | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
12 | T2703 | Master data table: Manufacturer | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
13 | T2704 | Master data table: Region | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
14 | T2705 | Master data table: Area | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
15 | T2706 | Master data table: Trade channel | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
16 | T2707 | Master data table: Area | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
17 | T2708 | Master data table: Country | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
18 | T2709 | Master data table: Plant | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
19 | T270A | Master data table: Division | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
20 | T270B | Master data table: Product Group | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
21 | T270C | Master data table: Customer Group | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
22 | T270D | Master data table: Distribution Channel | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
23 | T270E | Master data table: Company | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
24 | T270F | Master data table: Month | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
25 | T270G | Master data table: Division | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
26 | T270H | Master data table: Region | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
27 | T270I | Master data table: Product type | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
28 | T270J | Master data table: Source of data | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
29 | T2710 | Master data table: Area (Countries) | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
30 | T2711 | Master data table: Continent | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
31 | T2712 | Master data table: countries | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
32 | T2713 | Master data table: regions | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
33 | T2714 | Master data table: product groups | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
34 | T2715 | Master data table: Continent | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
35 | T2716 | Master data table: Land | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
36 | T2717 | Master data table: State | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
37 | T2718 | Master data table: Prod. Group | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
38 | T2719 | Master data table: Sales Channel | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
39 | T271A | Master Data Table: Company | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
40 | T271B | Master Data Table: Strategic Business U | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
41 | T271C | Master Data Table: demo | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
42 | T271D | Master Data Table: xxrk1 | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
43 | T271E | Stammdatentabelle: T-Segment | 4 | TFLAG | Flag für Textanbindung | nvarchar | 1 | 0 | | |
44 | T271F | Stammdatentabelle: T-Business Unit | 5 | TFLAG | Flag für Textanbindung | nvarchar | 1 | 0 | | |
45 | T271G | Stammdatentabelle: T-Division | 5 | TFLAG | Flag für Textanbindung | nvarchar | 1 | 0 | | |
46 | T271H | Stammdatentabelle: T-Product Line | 5 | TFLAG | Flag für Textanbindung | nvarchar | 1 | 0 | | |
47 | T271I | Master data table: town xx | 5 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
48 | T2720 | Master data table: xarea (Description) | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
49 | T2721 | Master data table: CITY (X) | 5 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
50 | T2722 | Master data table: PRODUCTS (X) | 7 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
51 | T2723 | Master data table: MAYOR (X) | 5 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
52 | T2737 | Master Data Table: Customer Group 00 | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
53 | T2738 | Master Data Table: Customer 00 | 5 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
54 | T27NN | Master Data Table: & | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
55 | TKAF | Field catalog for Accounting | 46 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
56 | TKCF | SAP-EIS Field Catalog | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
57 | TKCHW | SAP-EIS: Hierarchy data | 12 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
58 | TKCK | Key figures | 16 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
59 | TKCS | Basic field catalog SAP-EIS (fixed fields) | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
TOPData Transfer |
60 | T2420 | System control parameters | 4 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
TOPIncentive and Commission Management ICM |
61 | TCACSF | Commissions: Field Catalog Search | 46 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
TOPInformation System |
62 | T804C | Report Writer: Special Fields | 7 | TFLAG | Indicator: Field is required for text routine | nvarchar | 1 | 0 | | |
TOPInvestment Programs |
63 | TAIF | IM Drilldown: Characteristic Catalog | 46 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
TOPPerformance Assessment Workbench |
64 | SLS_PRES | PAW - Person Results Structure | 36 | TFLAG | PAW - 'Transfered to HR' Flag - as checkbox ('X' = yes) | nvarchar | 1 | 0 | | |
TOPProfitability Analysis |
65 | TJBF | Field Catalog IS-B-PA | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
66 | TJBS | Base Field Catalog IS-B-PA (Fixed Fields) | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
67 | TKEB1 | Report Management | 6 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
68 | TKEF | CO-PA field catalog | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
69 | TKES | CO-PA Basis Field Catalog (fixed fields) | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
70 | TKES1 | Row/column structures | 8 | TFLAG | Indicator: Field is required for text routine | nvarchar | 1 | 0 | | |
TOPRisk Analysis |
71 | JBRRMTKEF | RM: Copy of CO-PA Field Catalog | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
72 | JBRRMTKES | RM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
73 | JBRTKCHABK | RM: Backup Table for Characteristic Hierarchies | 11 | TFLAG | Flag to indicate text | nvarchar | 1 | 0 | | |
TOPText Retrieval and Information Extraction |
74 | SRETIDLACD | Indexes of client-specific applications | 13 | TFLAG | Transport flag (import flag) | nvarchar | 1 | 0 | | |
75 | SRETIDLACI | Indexes of cross-client applications | 12 | TFLAG | Transport flag (import flag) | nvarchar | 1 | 0 | | |
TOPTreasury |
76 | TTMRF | Field catalog for Risk Management | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |
77 | TTMRS | Basis field catalog Risk Management (fixed fields) | 45 | TFLAG | Flag: Text | nvarchar | 1 | 0 | | |