| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SAPSRM/SH_PLANT | Table for ERP Search Help Plants | 9 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| 2 | CNVTDMS_11_SCADR | Scrambling Addresses | 31 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 3 | ADRC | Addresses (Business Address Services) | 78 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| 4 | ADRCS | Shadow Table: Addresses (Business Address Services) | 79 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| 5 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 80 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| TOPFinancial Accounting |
| 6 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 78 | MC_CITY1 | Ortsname in Großbuchstaben für Suchhilfe | nvarchar | 25 | 0 | | |
| TOPIntercompany Data Exchange |
| 7 | TINV_INV_EXTID | Bill Document: External Identification Characteristics | 9 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
| TOPUse AP-MD-BP Components |
| 8 | BUTADRSEARCH | Mass Search Help: Business Partner | 13 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
