| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /FLDQ/AD_ERRLOCK | Table to store errors during locking AD_MTCCODE records | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 2 | /FLDQ/AD_ERRQTR | Table to store address errors generated during RSADRQU2 | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 3 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 4 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 5 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 6 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 3 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 7 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 8 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 9 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 10 | /FLDQ/AD_SCR_SUG | Maintain fields and order for address suggestion lists | 2 | ADDR_TYPE | Address type : Street, PO Box or both | nvarchar | 1 | 0 | | |
| 11 | /FLDQ/AD_SUGFLD | Fields for rendering Suggestion List Dialog | 2 | ADDR_TYPE | Address type : Street, PO Box or both | nvarchar | 1 | 0 | | |
| 12 | /FLDQ/AD_SUGLBL | Field labels for the column headings in ALV | 2 | ADDR_TYPE | Address type : Street, PO Box or both | nvarchar | 1 | 0 | | |
| 13 | /FLDQ/AD_SUGTEXT | Suggestion List Text Definitions | 2 | ADDR_TYPE | Address type : Street, PO Box or both | nvarchar | 1 | 0 | | |
| 14 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 15 | /FLDQ/HNA_BM_OUT | HANA task Batch Match Result Records | 3 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 16 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 7 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 17 | T7BREFD_WRKPLC | Workplace information | 16 | ADDR_TYPE | Street type | nvarchar | 3 | 0 | | |
| 18 | T7UNPF_HR_ADRM | Address Mapping Table | 5 | ADDR_TYPE | Address Type | nvarchar | 10 | 0 | | |
| 19 | PIQDB_NL_OUTLOG | Status log of the Outgoing messages | 9 | ADDR_TYPE | Character Field Length = 10 | nvarchar | 10 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 20 | TSADOBJ | Assignments of BOR object types to address reference types | 2 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 21 | TSADOBJT | Semantic description of BOR object type addresses | 3 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| TOPAdvertising Management |
| 22 | JJCPFREESUB | IS-M: Free Subscription - Contact Person Relationship | 13 | ADDR_TYPE | Addresses: Address type | nvarchar | 1 | 0 | | |
| 23 | JJTAF | IS-M/AM: Free Subscription for Media Contact Person | 13 | ADDR_TYPE | Addresses: Address type | nvarchar | 1 | 0 | | |
| TOPCommunication Services Mail, Fax, SMS, Telephony |
| 24 | SPH_USNOLI | SAPphone: Telephone number list for each user | 11 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| 25 | SXADDRTYPE | SAPconnect: Address types | 2 | ADDR_TYPE | SAPconnect: Address type | nvarchar | 3 | 0 | | |
| 26 | SXCOS | SAPconnect: Send attribute classes | 4 | ADDR_TYPE | SAPconnect: Address type | nvarchar | 3 | 0 | | |
| 27 | SXFORMATG | SAPconnect: Format groups | 4 | ADDR_TYPE | SAPconnect: Address type | nvarchar | 3 | 0 | | |
| 28 | SXSERV | SAPconnect: Node capabilities | 3 | ADDR_TYPE | SAPconnect: Address type | nvarchar | 3 | 0 | | |
| TOPGeneral Application Functions |
| 29 | CRMD_PARTNER | Partners | 17 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | nvarchar | 1 | 0 | | |
| TOPProduction and Revenue Accounting |
| 30 | OIUCM_ADDR_TYPE | Address Type Control Table | 3 | ADDR_TYPE | Address Type | nvarchar | 2 | 0 | | |
| 31 | OIUCM_ADDR_TYPET | Address Type Description | 4 | ADDR_TYPE | Address Type | nvarchar | 2 | 0 | | |
| 32 | OIUCM_BADR | Business Associate Additional Addresses (Addr Grp = OIU1) | 4 | ADDR_TYPE | Address Type | nvarchar | 2 | 0 | | |
