| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic Functions |
1 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 21 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
2 | FILCC | FI-LC: Transaction-related fields for table FILCT | 5 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
3 | FILCP | FI-LC: Plan line items for object table | 21 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
4 | FILCT | FI-LC: Global totals table with 2 object tables | 20 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
5 | GLPO2 | Plan Line Items for Object Table Global | 21 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
6 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 21 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
7 | GLTO2 | FI-SL Table with Objects, Structure Corresponds to GLT2 | 18 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
8 | T852 | Subgroups | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
9 | T852G | Subgroup companies | 4 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
10 | T852U | Subgroup companies | 4 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
11 | T852V | Version-dependent subgroup characteristics | 3 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
12 | T853K | Subgroup status | 4 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
13 | T863X | Selections for reporting | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
14 | T863Y | INDX datasets | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
15 | T863Z | Selection: Document status | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
16 | T870 | Consolidation method assignment | 3 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
17 | T873 | Hidden reserves | 9 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
18 | T874 | Elimination of hidden reserves | 4 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
TOPConsolidation |
19 | TFMIG03 | Allocation: Subgroup -> Consolidation Group | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
20 | TFMIG10 | Migration: Processing Options | 9 | RSUBD | Migration: Default Subgroup | nvarchar | 3 | 0 | | |
TOPProduct Cost Planning |
21 | KALA | Costing Run: General Data/Parameters | 28 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |
22 | TCK07 | Costing Variants for Organizational Units | 2 | RSUBD | Subgroup | nvarchar | 3 | 0 | | |