| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/ACCRMETH0C | Configured Methods for Accrual | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
2 | /EACC/ACCRMETH0T | Description of an Accrual Method | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
3 | /EACC/CHARNAMES | Characteristic Names for Fixed Fields | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
4 | /EACC/JOURNALS | Journals in E-Accounting | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
5 | /EACC/JRNL_TRANS | Transported Master Objects | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
6 | /EACC/TAR_OBJ | Archiving Objects | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
7 | /EACC/TAR_SEL | Selection Characteristics for Archiving | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
8 | /EACC/TBTA3003 | Transient Journal Characteristics for Generic BTA | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
9 | /EACC/TBTA3004 | Characteristics to Display Simulated Documents | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
10 | /EACC/T_DCCHECK | Characteristics to Display Simulated Documents | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
11 | /EACC/T_DCSEQ | Process Step Sequences per Accounting System | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
12 | /EACC/V_COND | Derivation Steps Condition | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
13 | /EACC/V_CUR | Currency Types | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
14 | /EACC/V_CUR_SUB | Names of Views for Currency Types | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
15 | /EACC/V_DERIV | Derivation Steps | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
16 | /EACC/V_DER_NAME | Derivation Steps - Name | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
17 | /EACC/V_HEAD_C | Header Data | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
18 | /EACC/V_HEAD_N | Header Data - View Name | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
19 | /EACC/V_JOURN_C | Journals | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
20 | /EACC/V_JOURN_N | Journals | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
21 | /EACC/V_QUANT_N | Quantity Types | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
22 | /EACC/V_QUANT_T | Quantity Types | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
23 | /EACC/V_TABLES_I | Journal Tables - Indexes | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
24 | /EACC/V_TABLES_J | Journal Tables | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
25 | /EACC/V_TABLES_T | Journal Tables - Tables | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
26 | /EACC/V_TAB_I_I | Journal Tables - Indexes - Index | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
27 | /EACC/V_TOTALS_F | Journal Totals - Field List | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
28 | /EACC/V_TOTALS_I | Journal Totals - Database Indexes | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
29 | /EACC/V_TOTALS_J | Journal Totals | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
30 | /EACC/V_TOTALS_T | Journal Totals - Texts | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
31 | /EACC/V_TOTAL_II | Journal Totals - Database Indexes - Index | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
32 | /EACC/V_TOTAL_IT | Journal Totals - Database Indexes - Texts | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
33 | FINACHD | Accounting Document Header | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
34 | FINB_TNOASS_NRO | Assignment of Accounting System to Number Range Object | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPBusiness Accounting |
35 | UAV0PRICE001 | Price Table with Period Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
36 | UAV0PRICE001H | Price History Table with Period Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
37 | UAV0PRICE002 | Price Table with Date Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
38 | UAV0PRICE002H | Price History Table with Date Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
39 | UAV0PRICE003 | Price Table with Period Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
40 | UAV0PRICE003H | Price History Table with Period Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
41 | UAV0PRICE004 | Price Table with Date Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
42 | UAV0PRICE004H | Price History Table with Date Dependency | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPFinancials |
43 | ACCSYSTEM01 | Settings for Company on Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
44 | ACCSYSTEM02 | Number Range Object for Accounting System and Company | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
45 | ACCSYSTEM03 | Derivations for Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
46 | ACCSYSTEM0C | Accounting Systems | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
47 | ACCSYSTEM0T | Texts of Accounting Systems | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
48 | FINGLACCTCOMP0C | G/L Account on Accounting System/Company Level | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
49 | FINVALSTRATDERIV | Derivation Table: Valuation Strategy for Business Transactio | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
50 | FINXCOSTCTR0C | Local Values for FIN_COSTCTR (Not Used in Live System) | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
51 | FINXPROFITCTR0C | Local Values for FIN_PROFITCTR (Not Used in Live System) | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
52 | FINXPROFITCTR0T | Local Texts for FIN_PROFITCTR (Not Used in Live System) | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPFinancials Basis |
53 | ACCACCOUNT11 | G/L account | 4 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
54 | ACCACCTGROUP00 | Account Group | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
55 | ACCAREAIDCOMP | Area ID of a Technical Component | 4 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
56 | ACCCLSSTEP_ASGN | Assignment of Period Rules for the Closing Phases | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
57 | ACCCLSSTPPER | Setting for Period Lock | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
58 | ACCCLSSTPPERLE | Period Lock Setting Depending on Legal Unit | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
59 | ACCPERSEL2 | Specify Selction Conditions for the Period Lock | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
60 | ACCROLE21 | Application Role Registration: FieldNames and FinObjectTypes | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
61 | ACCSYS02 | Accounting System: Assignment to Selection Condition | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
62 | ACCSYS04 | Customizing for Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
63 | ACCSYS05 | Setting for Currency Translation | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
64 | ACCSYS08 | Currency IDs per Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
65 | ACCSYS09 | Cust. of fiscal year variant per legal entity and acc system | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
66 | ACCSYS0C | Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
67 | ACCSYS0T | Name of Accounting System | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
68 | FINB_TPRFL_A | Table for Result Elements (Amounts Only) | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
69 | FINB_TPRFL_Q | Table for Result Elements (Quantities Only) | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
70 | FINB_TPROFEL | Table for Result Elements | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPGeneral Ledger |
71 | /EACA/GL_DOCNR_T | Inverse Value Table for GL Number Range Subobject | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
72 | /EACA/TGLBALREP | Configuration for G/L Balance Reporting | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
73 | /EACA/TGLBAS_B | Settings for Balance Tool | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
74 | /EACA/TGLBWINFO | Information for BW Objects | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
75 | /EACA/TGLCONTROL | Posting Logic Control for Account Determination Fields | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
76 | /EACA/TGLMPCONAS | Configuration of Manual Posting Transaction for Acc. System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
77 | /EACA/TGLREADER | Administration of the GUIDs for the Reader Modules | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
78 | /EACA/TGLSYS01 | General Ledger Configuration in Accounting System | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPIndustry Solution Catch Weight Management |
79 | CON_FIN_CKOMPU | Allowance for Price Update | 6 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPInventory Accounting |
80 | FAIBSV01 | Incoming/Outgoing Invoices | 8 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
81 | FAIBSV01C | Rule for Balance Sheet Valuation | 3 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
82 | FAIBSV02 | Valuated Receipts | 6 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
83 | FAIBSV03 | Logistical Goods Movements | 6 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
84 | UAINVDEBCRH | Document for Revaluation Through Material Debit/Credit | 12 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
85 | UAINVREVALH | Document for INV Price Change and Inventory Revaluation | 14 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
86 | UAINVT4000 | Configuration Status of Inventory/WIP for Accounting Systems | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
87 | UAIQS_BALANCE | Quantity Structure: Beginning/Ending Inventories and Values | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
88 | UAIQS_SNDRCV | Quantity Structure: Valuated Quantity Structure | 2 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |
TOPLoans Management |
89 | /FSIH/LINK | Table of Links Between Loan and Insurance Policy | 3 | ACC_SYSTEM | Account System | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
90 | /EACA/TPMACCSYS | Assignment of Accounting Systems | 4 | ACC_SYSTEM | Accounting System | nvarchar | 8 | 0 | | |