| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/GL1T | Index master Description | 4 | TXT20 | Text (20 Characters) | nvarchar | 20 | 0 | | |
2 | /ATL/GL2T | Calculation Method Descriptions | 3 | TXT20 | Text (20 Characters) | nvarchar | 20 | 0 | | |
3 | CNV_20100_SKAT | CNV backup copy for implementation of country-spec. CoA - ID | 6 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
4 | T028E | Text Table for T028D | 4 | TXT20 | Text, length 40 | nvarchar | 40 | 0 | | |
5 | T082E | Description asset views | 4 | TXT20 | View name | nvarchar | 20 | 0 | | |
6 | T241E | Text to sort reports into report portfolio | 7 | TXT20 | Short text for hierarchy node | nvarchar | 20 | 0 | | |
7 | T241H | Text for report portfolio hierarchy | 5 | TXT20 | Short text for hierarchy node | nvarchar | 20 | 0 | | |
8 | T241S | Sender field description | 5 | TXT20 | Description of object | nvarchar | 20 | 0 | | |
9 | TSAKR | Create G/L account with reference | 4 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
10 | ZSAFI | Zuordnung Sako-Fipo | 4 | TXT20 | Sachkontenkurztext | nvarchar | 20 | 0 | | |
TOPAnalyzer |
11 | I82NN | RM texts for characteristics: & | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
TOPBank Accounting |
12 | TCCLGT | Payment cards: Settlement run log (texts) | 4 | TXT20 | Payment Cards: Short Text for a Settlement Run | nvarchar | 20 | 0 | | |
TOPBasic Functions |
13 | GLACCREFI | G/L Account Master Record: Create with Reference | 6 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
14 | T028I | Text Table for T028H | 6 | TXT20 | Text, length 40 | nvarchar | 40 | 0 | | |
15 | T082T | Names For Field Groups | 4 | TXT20 | Field group name | nvarchar | 20 | 0 | | |
TOPConsolidation |
16 | /1SAP1/FC_TFG300 | Master Data Table: Type of ConsUnit | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
17 | /1SAP1/FC_TFG301 | Master Data Texts: Tax Equal. Indicator | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
18 | TF9N2 | Master Data Texts: & | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
TOPData Collection |
19 | T241B | Description of Characteristic Values | 6 | TXT20 | Description of object | nvarchar | 20 | 0 | | |
20 | T2800 | Master data texts: Region | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
21 | T2801 | Master data texts: Brand | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
22 | T2802 | Master data texts: Production group | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
23 | T2803 | Master data texts: Manufacturer | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
24 | T2804 | Master data texts: Region | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
25 | T2805 | Master data texts: Area | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
26 | T2806 | Master data texts: Trade channel | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
27 | T2807 | Master data texts: Area | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
28 | T2808 | Master data texts: Country | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
29 | T2809 | Master data texts: Plant | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
30 | T280A | Master data texts: Division | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
31 | T280B | Master data texts: Product Group | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
32 | T280C | Master data texts: Customer Group | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
33 | T280D | Master data texts: Distribution Channel | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
34 | T280E | Master data texts: Company | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
35 | T280F | Master data texts: Month | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
36 | T280G | Master data texts: Division | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
37 | T280H | Master data texts: Region | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
38 | T280I | Master data texts: Product type | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
39 | T280J | Master data texts: Source of data | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
40 | T2810 | Master data texts: Area (Countries) | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
41 | T2811 | Master data texts: continents | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
42 | T2812 | Master data texts: countries | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
43 | T2813 | Master data texts: regions | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
44 | T2814 | Master data texts: product groups | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
45 | T2815 | Master data texts: Continent | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
46 | T2816 | Master data texts: Land | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
47 | T2817 | Master data texts: State | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
48 | T2818 | Master data texts: Prod. Group | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
49 | T2819 | Master data texts: Sales Channel | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
50 | T281A | Master Data Table: Company | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
51 | T281B | Master Data Table: Strategic Business U | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
52 | T281C | Master Data Texts: demo | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
53 | T281D | Master Data Table: xxrk1 | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
54 | T281E | Stammdatentexte: T-Segment | 4 | TXT20 | Bedeutung | nvarchar | 20 | 0 | | |
55 | T281F | Stammdatentexte: T-Business Unit | 4 | TXT20 | Bedeutung | nvarchar | 20 | 0 | | |
56 | T281G | Stammdatentexte: T-Division | 4 | TXT20 | Bedeutung | nvarchar | 20 | 0 | | |
57 | T281H | Stammdatentexte: T-Product Line | 4 | TXT20 | Bedeutung | nvarchar | 20 | 0 | | |
58 | T281I | Master data texts: town xx | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
59 | T2820 | Master data texts: xarea (Description) | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
60 | T2821 | Master data texts: CITY (X) | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
61 | T2822 | Master data texts: PRODUCTS (X) | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
62 | T2823 | Master data texts: MAYOR (X) | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
63 | T2837 | Master Data Texts: Customer Group 00 | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
64 | T2838 | Master Data Texts: Customer 00 | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
65 | T28NN | Master Data Texts: & | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
66 | TKCHNT | SAP-EIS: Hierarchy node texts | 7 | TXT20 | Description | nvarchar | 20 | 0 | | |
67 | TKCODT | SAP-EIS: Texts for object types in object list | 3 | TXT20 | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPData Retention Tool |
68 | TXW_S_BSEG | Retrieve BSEG from archive | 121 | TXT20 | Account short text | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
69 | SKAT | G/L Account Master Record (Chart of Accounts: Description) | 5 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
70 | T053B | Selection Rules for Payment Advices (Texts) | 4 | TXT20 | Text | nvarchar | 25 | 0 | | |
71 | T053S | Classification of Payment Differences (Texts) | 5 | TXT20 | Reason Code Short Text | nvarchar | 20 | 0 | | |
TOPGeneral status management |
72 | TBO01 | Language-specific values for object type | 6 | TXT20 | Text, length 20 | nvarchar | 20 | 0 | | |
TOPGL transfer |
73 | TBKKC_GLACC_TEXT | GL-ACCOUNT-TEXT | 5 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
TOPInformation system |
74 | PSOBKFI | Bestände Kassenbuch-Tagesabschluss | 11 | TXT20 | Text in Länge 20 | nvarchar | 20 | 0 | | |
TOPInvestment Programs |
75 | TAIGS | Key figure key for scale (language-dependent) | 6 | TXT20 | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPLocalization |
76 | IDCN_GLACCATTRT | G/L account time-depen.attributes-texts(CN) | 6 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
77 | IDCN_ZJFSKIPACCT | Skip G/L Account from P&L Account Closing Posting (Text) | 5 | TXT20 | G/L account short text | nvarchar | 20 | 0 | | |
TOPMarket Risk Analysis |
78 | I8200 | IS-B: RM Characteristics : Organisation INT/EXT | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |
TOPOverhead Cost Orders |
79 | TRFBT | Language-dep. values for reference document type | 4 | TXT20 | Text (20 Characters) | nvarchar | 20 | 0 | | |
TOPRisk Analysis |
80 | I82NNK | IS-B: RM Texts for Characteristics : & | 4 | TXT20 | Description | nvarchar | 20 | 0 | | |