| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/CHARNAMES | Characteristic Names for Fixed Fields | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
TOPBusiness Analytics |
2 | TCOCOMAP | Mapping Fields: Remote <--> SEM | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
3 | TCOCOMAP2 | Mapping Fields: Remote <--> SEM | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
4 | TCOCOMAPTYPES | Mapping: Type Remote System <--> Object Type SEM | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
5 | TIPPE_EDGEFIELDS | Import iPPE: Assignment Link Fields | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
6 | TIPPE_EDGES | Import iPPE: Assignment Links | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
7 | TIPPE_EDGES2 | Import iPPE: Assignment Links | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
8 | TIPPE_TYPEFIELD2 | Import iPPE: Assignment Type Fields | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
9 | TIPPE_TYPEFIELDS | Import iPPE: Assignment Type Fields | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
10 | TIPPE_TYPES | Import iPPE: Assignment Types | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
11 | TIPPE_TYPES2 | Import iPPE: Assignment Types | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
12 | UABWEDGCALCFLAT | BW Extraction: Extracted Replacement Links for Costing | 6 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
13 | UABWMDEXT | BW Objects for Master Data Extraction | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
14 | UABWTDEXT | BW Objects for Transaction Data Extraction | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
15 | UAB_ARCH_LOCK | Persistent Locking for Archived Objects | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
16 | UACOSTCOMPGROUP | Cost Component Split | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
17 | UACOSTCOMPGROUPT | Cost Component Split Element Groups: Texts | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
18 | UACOSTCOMPONENT | Cost Component Split Elements | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
19 | UACOSTCOMPONENTT | Cost Component Split Element Texts | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
20 | UACOSTCOMPSPLIT | Cost Component Split | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
21 | UACOSTCOMPSPLITT | Cost Component Split Texts | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
22 | UAGRPCOMPASSIGN | Cost Comp. Split Element Groups: Assignment Group-Element | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
23 | UAGRPCOMPASSIGNT | CComp. Split Element Groups: Texts Assignmnt Groups-Elements | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
24 | UANRGR | Number Range Groups Costing Platform | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
25 | UAPRICETABLE | Price Tables Assignment | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
26 | UATPLMAP | Field Assignment during Template Call | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
27 | UATPLTPL | Template Selection for Template Call | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
28 | UATUBD_LIGHT | BDLib Light: Generated Methods (Data Basis-Dependent) | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
29 | UAUPLCMD | Actions During Upload | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
30 | UAUPLCMD_MISSKEY | Assignment of Object Type | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
31 | UAUPLMAP | Field Assignment During Upload | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
32 | UAUPLMAP_PRELIM | Field Name Assignment with Switch of Object Type | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
33 | UAUPL_MISSINGKEY | Missing Key Field | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
TOPFinancials |
34 | ACCSYSTEM0C | Accounting Systems | 7 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
35 | FINPRCTABDERIV | Assignment Table for Table Type of Prices | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
36 | FINPRICELABEL01 | Price Type Controls | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
37 | FINPRICELABEL0C | Master Data for Price Types | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
38 | FINPRICELABEL0T | Text Table for Price Types | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
39 | FINVALFUNC0C | Master Data for Strategy Functions | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
40 | FINVALFUNC0T | Texts for Strategy Functions | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
41 | FINVALMETHOD0C | Valuation Functions for Strategy Formulas | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
42 | FINVALMETHOD0T | Texts for Valuation Functions for Strategy Formulas | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
43 | FINVALSTRAT0C | Master Data for Valuation Strategy | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
44 | FINVALSTRAT0T | Texts for Valuation Strategies | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
45 | FINVALSTRATDERIV | Derivation Table: Valuation Strategy for Business Transactio | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
TOPFinancials Basis |
46 | ACCACCTGROUP00 | Account Group | 4 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
47 | ACCAREAIDCOMP | Area ID of a Technical Component | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
48 | ACCASSTYPE00 | Account Assignment Category | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
49 | ACCASSTYPE0C | Account Assignment Category | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
50 | ACCASSTYPE0T | Account Assignment Category | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
51 | ACCDBS01 | Data Basis <-> Business Domain Assignment | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
52 | ACCDBS02 | Assignment Data Basis - Generated ALV Reference Structure | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
53 | ACCDBS0C | Data Basis | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
54 | ACCDBS0T | Data Basis Name | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
55 | ACCENTCONF01 | Entities: Local Storage of Configuration | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
56 | ACCQNTTYPE0C | Data Elements of Quantity Type | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
57 | ACCROLE11 | Application Role Registration: Classes | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
58 | ACCROLE21 | Application Role Registration: FieldNames and FinObjectTypes | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
59 | ACCSTRU0C | Structure IDs | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
60 | ACCSYS06 | Settings for Reference Valuation | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
61 | ACCSYS07 | Reference Accounting Systems | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
62 | ACCSYS0C | Accounting System | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
63 | FINB_ATTRIBUTES | Attributes of Field on Data Basis | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
64 | FINB_FIELDS | Fields on the Data Basis | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
TOPGeneral Ledger |
65 | /EACA/GLCONFIG1 | GL Configuration: Active Subcomponents | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
66 | /EACA/TGLMPCONDB | Configuration of Manual Posting Transaction for Data Basis | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
TOPServices |
67 | FINBSCMIDRFC0C | RFC Data for Object Navigation | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
68 | FINB_FUNCTIONS | Function Builder | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
69 | FINB_FUNCTIONS_T | Function Builder | 3 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |
70 | FINB_SIGNATURE | Function Builder | 2 | ACC_DATABASIS | Data Basis | nvarchar | 5 | 0 | | |