| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_CHKSTAT | Table to temporarily hold the check status values | 30 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 38 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
3 | /FLDQ/AD_QU_INDX | QU2 Index Table | 37 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
4 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 31 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
5 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 31 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
6 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 37 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
7 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 37 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPAddress ManagementBusiness Address |
8 | ADRC | Addresses (Business Address Services) | 38 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
9 | ADRCS | Shadow Table: Addresses (Business Address Services) | 39 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
10 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 40 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPBank Customer Accounts |
11 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 43 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPContract Accounts Receivable and Payable |
12 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 42 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPDevice Management |
13 | EGTUR | Periodic Replacement List | 12 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPFinancial Accounting |
14 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 38 | STREETCODE | Codierung der Straße für Orts- und Straßendatei | nvarchar | 12 | 0 | | |
TOPGlobal Trade Services |
15 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 45 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
16 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 78 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPLocalization |
17 | J_1BNFCPD | Nota Fiscal one-time accounts | 58 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPMove-InOut |
18 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 5 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPPortfolio |
19 | VDBILL_RES_HEAD | Bill Results Header | 28 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPProcessing |
20 | EWMINSPDETAIL | Inspection List Detail | 13 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |
TOPStakeholder Relationship Management |
21 | USC_CONT_ADD | SRM Contact: Event Info | 11 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | |