| 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 | | |