| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/CONFIGS_PL | Configurations for Line Item Persistence | 23 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
2 | /EACC/TDR_STEPS | Derivation Steps | 6 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
TOPApplication Framework |
3 | MDG_MDF0010 | Area IDs in Master Data Environment | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
4 | MDG_MDF2001 | Validity of Master Data Characteristics in Application Areas | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
5 | MDG_MDF2002 | Basis Characteristics in Master Data Environment | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
6 | MDG_MDF2005 | Properties of Master Data Fields | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
7 | MDG_MDF2006 | Properties of Master Data Fields (Language-dep. Texts) | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
8 | MDG_MDF2007 | Compounds of Master Data Fields | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
9 | MDG_MDF2030 | Restrictions on Master Data Hierarchies | 2 | AREAID | Master Data: Application Area | nvarchar | 22 | 0 | | |
TOPBusiness Analytics |
10 | UAB_AUDIT_TRAIL | Table for Audit Trail Function | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
11 | UALAYOUT | Layout Table | 2 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
12 | UALAYOUTT | Text Table for UALAYOUT | 2 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
13 | UAPROJECT | Transparent Table to Store Costing Projects | 11 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
14 | UAREP_CONFIG1 | Configuration for UA Reports | 2 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
15 | UAWORKSET | Transparent Table to Store Working Environments of Costing | 12 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
TOPClinical System |
16 | N1BCP2URL | Basic Cat.: Catalog Item to URL Assignment | 5 | AREAID | Basic Catalog: Work Area Key | nvarchar | 4 | 0 | | |
17 | N1BCS | OBSOLETE: Basic Cat.: Basic Catalog Set | 4 | AREAID | Basic Catalog: Work Area Key | nvarchar | 4 | 0 | | |
18 | N1BCSH | Basic Catalog Set: Header Data | 4 | AREAID | Basic Catalog: Work Area Key | nvarchar | 4 | 0 | | |
19 | N1BCUFAVH | Basic Cat.: User-Specific Favorites - Header Data | 3 | AREAID | Basic Catalog: Work Area Key | nvarchar | 4 | 0 | | |
TOPFinancials Basis |
20 | /EACC/TLI4000 | Context of Field Name, Info Object, D Elment, D Srce per D B | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
21 | ACCAREAIDCOMP | Area ID of a Technical Component | 5 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
22 | ACCDBS0C | Data Basis | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
23 | FINB_DMT_CONFIG | Data Retention, Configuration Object of Totals Persistence | 5 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
24 | UGCM0010 | FIN Change Management: Registered Applications | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
25 | UGCM0100 | FIN Change Management: Parameterization of the Generator | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
26 | UGMD0010 | FIN Master Data: Area IDs | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
27 | UGMD2001 | FIN Master Data: Validity of Characteristics in Areas | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
28 | UGMD2002 | FIN Master Data: Basis Characteristics | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
29 | UGMD2005 | FIN Master Data: Field Properties | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
30 | UGMD2006 | FIN Master Data: Field Properties - Language-dep. Texts | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
31 | UGMD2007 | FIN Master Data: Field Compounds | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
32 | UGMD2020 | FIN Master Data: Assignment of RFC Destinations to AREAIDs | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
33 | UGMD2030 | FIN Master Data: Restrictions on Hierarchies | 3 | AREAID | FIN Master Data: Application Area | nvarchar | 22 | 0 | | |
TOPQualifications and Requirements |
34 | T77CS | Suitability Ranges for Career and Succession Planning | 2 | AREAID | Two digit number | nvarchar | 2 | 0 | | |
TOPServices |
35 | FINB_COND_AREAID | Conditions per Area ID | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
36 | FINB_KF_CHAR_KEY | Key Fields Generated Table Types | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
37 | FINB_KF_CHAR_STR | DDIC Structures According to Hash Values of their Components | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
38 | FINB_KF_CHAR_TBL | DDIC Table Types According to Hash Vals of their Components | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
39 | FINB_PR_TCHILD | Child Persistence Objects in Hierarchy | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
40 | FINB_PR_TFIELDS | Fields of a Persistence Object | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
41 | FINB_PR_TIND | Indexes | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
42 | FINB_PR_TIND_FDS | Index fields | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
43 | FINB_PR_TJOINS | Join conditions | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
44 | FINB_PR_TMAP | Field Assignment Read Structure - Persistence Object | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
45 | FINB_PR_TOBJS | Persistence Objects | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
46 | FINB_PR_TOBJST | Business Names in the Persistence Objects | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
47 | FINB_RP_CONFIG1 | Customizing by Report | 4 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
48 | FINB_RP_CONFIG3 | Technical Structure Assignment <--> Long Text | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
49 | FINB_RT_TAB | Runtime Tables | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
50 | FINB_RT_TAB_FLD | Runtime Tables | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
51 | FINB_RT_TKEY | Key of Runtime Tables | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
52 | FINB_RT_TKEY_FLD | Key of Runtime Tables | 3 | AREAID | Registration Identification | nvarchar | 22 | 0 | | |
TOPWorkbench Tools Editors, Painters, Modelers |
53 | WBTOOLTYPE | Visualization types for tools | 17 | AREAID | Area ID in Multi-Area Window | nvarchar | 10 | 0 | | |