| 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 | 8 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 22 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
3 | /FLDQ/AD_QU_INDX | QU2 Index Table | 18 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
4 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 9 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
5 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 9 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
6 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 18 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
7 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 18 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
8 | /SMD/MD_____00ME | SID-Tabelle fuer District | 5 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
TOPAddress ManagementBusiness Address |
9 | ADRC | Addresses (Business Address Services) | 16 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
10 | ADRCITYPRT | Postal districts | 4 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
11 | ADRCS | Shadow Table: Addresses (Business Address Services) | 17 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
12 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 18 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
13 | ADRDIF_CP | District Difference Table for Quarterly Adjustment | 13 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
14 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 23 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
15 | ADRSTREET | Streets | 5 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
16 | ADRSTRPCD | Street (section)/postal code: Assignment | 11 | CITYP_CODE | District code for city and street file | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
17 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 41 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
18 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 16 | CITYP_CODE | Codierung des Ortsteils für Orts- und Straßendatei | nvarchar | 8 | 0 | | |
TOPGlobal Trade Services |
19 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 23 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
20 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 56 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
TOPLocalization |
21 | J_1BNFCPD | Nota Fiscal one-time accounts | 36 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |
TOPMove-InOut |
22 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 14 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | |