| 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 | 25 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
2 | /FLDQ/AD_ERRQTR | Table to store address errors generated during RSADRQU2 | 16 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
3 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
4 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
5 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
6 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 40 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
7 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
8 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
9 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 39 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
10 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 35 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
11 | /FLDQ/AD_QU_INDX | QU2 Index Table | 34 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
12 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 26 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
13 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 26 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
14 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 32 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
15 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 34 | PO_BOX_CTY | big field for output from GAC to stop truncation | nvarchar | 100 | 0 | | |
16 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 34 | PO_BOX_CTY | big field for output from GAC to stop truncation | nvarchar | 100 | 0 | | |
17 | CNVTDMS_11_SCADR | Scrambling Addresses | 17 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPAddress ManagementBusiness Address |
18 | ADRC | Addresses (Business Address Services) | 33 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
19 | ADRCS | Shadow Table: Addresses (Business Address Services) | 34 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
20 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 35 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
21 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 33 | PO_BOX_CTY | Land zum Postfach | nvarchar | 3 | 0 | | |
TOPGlobal Trade Services |
22 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 40 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
23 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 73 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPLocalization |
24 | J_1BNFCPD | Nota Fiscal one-time accounts | 53 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPMaster Data |
25 | EFISEL | Field Selection Control for Address Data | 59 | PO_BOX_CTY | PO Box Country | nvarchar | 1 | 0 | | |
TOPMove-InOut |
26 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 28 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPPatient Accounting |
27 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 16 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
28 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 19 | PO_BOX_CTY | BRF: Expression | nvarchar | 20 | 0 | | |
29 | DFMCA_BRF750 | BRF: Address Check | 16 | PO_BOX_CTY | BRF: Expression | nvarchar | 20 | 0 | | |
30 | DFMCA_BRF770 | BRF: Create Location | 20 | PO_BOX_CTY | BRF: Expression | nvarchar | 20 | 0 | | |
31 | DFMCA_BRF820 | BRF: Address Autocorrection | 18 | PO_BOX_CTY | Field Name | nvarchar | 30 | 0 | | |
TOPSales Promotions |
32 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 42 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | |
TOPWaste Management |
33 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 59 | PO_BOX_CTY | PO Box Country | nvarchar | 1 | 0 | | |
34 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 59 | PO_BOX_CTY | PO Box Country | nvarchar | 1 | 0 | | |