| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /1CADMC/00000410 | ADCP | 8 | NATION | | nvarchar | 1 | 0 | | |
| 2 | /1CADMC/00000415 | ADRC | 7 | NATION | | nvarchar | 1 | 0 | | |
| 3 | /1CADMC/00000416 | ADRP | 7 | NATION | | nvarchar | 1 | 0 | | |
| 4 | /FLDQ/AD_ERRLOCK | Table to store errors during locking AD_MTCCODE records | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 5 | /FLDQ/AD_ERRQTR | Table to store address errors generated during RSADRQU2 | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 6 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 7 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 8 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 9 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 10 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 11 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 12 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 13 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 14 | /FLDQ/AD_QU_INDX | QU2 Index Table | 11 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 15 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 16 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 17 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 18 | /FLDQ/HNA_BM_OUT | HANA task Batch Match Result Records | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 19 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 11 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 20 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 11 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 21 | /SAPSRM/SH_PLANT | Table for ERP Search Help Plants | 13 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 22 | /SMD/MD_____00KK | SID-Tabelle fuer Address Version | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 23 | /SMD/MD_____00KZ | SID-Tabelle fuer Address number | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 24 | /SMD/MD_____00MK | SID-Tabelle fuer Address Version | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 25 | /SMD/MD_____00MY | SID-Tabelle fuer Address number | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 26 | NWS_EXT_ADRC2 | Texts for Addresses (Central Address Management) | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 27 | NWS_EXT_ADRCT | Texts for Addresses (Central Address Management) | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 28 | PA0616 | HR Master Record: Infotype 0616 | 36 | NATION | HESA: Nationality code | nvarchar | 4 | 0 | | |
| 29 | PAPBSGBH_13_P | HESA: Person table (2012/13 onwards) | 31 | NATION | HESA: Nationality | nvarchar | 2 | 0 | | |
| 30 | PAPBSGB_HESA_P | HESA: Archive table for NISR Person table | 12 | NATION | HESA: Nationality code | nvarchar | 4 | 0 | | |
| 31 | T5GPBSH_NA | HESA: Mapping of Nationality to HESA Code | 3 | NATION | HESA: Nationality code | nvarchar | 4 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 32 | ADCP | Person/Address Assignment (Business Address Services) | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 33 | ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 34 | ADRC | Addresses (Business Address Services) | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 35 | ADRCS | Shadow Table: Addresses (Business Address Services) | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 36 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 37 | ADRCT | Address Texts (Business Address Services) | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 38 | ADRCTS | Shadow Table: Texts for Addresses (Business Addr. Services) | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 39 | ADRCTS2 | Shadow Table 2: Address Texts (Business Address Services) | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 40 | ADRP | Persons (Business Address Services) | 4 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 41 | ADRPS | Shadow Table: Persons (Business Address Services) | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 42 | TSAD9V | Screen Variants for Version-Specific Address Masks | 2 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 43 | TSADV | International versions of addresses | 1 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 44 | TSADVC | Customizing international address versions | 1 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 45 | TSADVC_CLIDEP | International Address Version Customizing (Client-Specific) | 2 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 46 | TSADVC_REG | Obsolete; Use Table TSADVC_REG2 | 2 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 47 | TSADVC_REG2 | Version-Specific Control of Regional Structure | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 48 | TSADVT | Name of internationalen versions of addresses | 2 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPBasis Components |
| 49 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 22 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 50 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 22 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPBelgium |
| 51 | T5B1V | Correspondence of customer entries in TSADV | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPBusiness Partner Enhancements for Financial Services |
| 52 | BP000 | Business Partner Master (General Data) | 41 | NATION | Nationality | nvarchar | 3 | 0 | | |
| TOPClinical System |
| 53 | N1PDKNATION | PERINATAL: Table of Nationality Keys | 2 | NATION | | nvarchar | 2 | 0 | | |
| TOPCross-Application Components |
| 54 | J_2GFIELDS | Customer/Vendor/Company - Field mappings | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPFinancial Accounting |
| 55 | /BGLOCS/FIADRC | BG VAT internationalization | 3 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 56 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 4 | NATION | Versionskennzeichen für internationale Adressen | nvarchar | 1 | 0 | | |
| TOPGlobal Trade Services |
| 57 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 9 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 58 | /SAPSLL/TCOCMP | SLL: Control Procedure for Address or String Comparison | 5 | NATION | International Address Version ID | nvarchar | 1 | 0 | | |
| TOPLOGFAS |
| 59 | /ISDFPS/GEOLOC | Geolocation Database Table | 4 | NATION | Country | nvarchar | 2 | 0 | | |
| TOPMarketing Retail Network |
| 60 | OIFSMCADDR | Link Table Between OIFSPBL and ADRC for Matchcode | 5 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPOrganizational Management |
| 61 | T77NI | Country-Specific Infotypes | 2 | NATION | Country Key for Country-Specific Infotype | nvarchar | 3 | 0 | | |
| TOPReal Estate Management |
| 62 | S401 | RE standard analysis partner | 45 | NATION | Nationality | nvarchar | 3 | 0 | | |
| 63 | VIAR02 | RE: REse@rch - RE Requests | 82 | NATION | Nationality | nvarchar | 3 | 0 | | |
| TOPReusable Components of Business Suite Foundation |
| 64 | /BOFU/ADCPUUID | Table for ADCP-UUID (Downport 7.10 to 7.0) | 9 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 65 | /BOFU/ADRCUUID | Table for ADRC-UUID (Downport 7.10 to 7.0) | 9 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 66 | /BOFU/ADRPUUID | Table for ADRP-UUID (Downport 7.10 to 7.0) | 7 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPStructures Workbench |
| 67 | HRP1952 | DB Table for Infotype 1952 | 20 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| TOPUse AP-MD-BP Components |
| 68 | BUT020 | BP: Addresses | 6 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 69 | BUT020S | Shadow Table BP: Addresses | 7 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 70 | BUT052 | BP Relationship: Addresses | 9 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
| 71 | BUT052S | Shadow Table BP Relationship: Addresses | 10 | NATION | Version ID for International Addresses | nvarchar | 1 | 0 | | |
