| 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 | 13 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
2 | /FLDQ/AD_ERRQTR | Table to store address errors generated during RSADRQU2 | 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
3 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
4 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
5 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
6 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 35 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
7 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
8 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
9 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
10 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 27 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
11 | /FLDQ/AD_QU_INDX | QU2 Index Table | 23 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
12 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 14 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
13 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 14 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
14 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 27 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
15 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 23 | POST_CODE1 | big field for output from GAC to stop truncation | nvarchar | 100 | 0 | | |
16 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 23 | POST_CODE1 | big field for output from GAC to stop truncation | nvarchar | 100 | 0 | | |
17 | /SAPSRM/SH_PLANT | Table for ERP Search Help Plants | 7 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
18 | CNVTDMS_11_SCADR | Scrambling Addresses | 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
19 | J_1UF_TP_MAIN | Main Information of Notification | 12 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPAddress ManagementBusiness Address |
20 | ADRC | Addresses (Business Address Services) | 21 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
21 | ADRCS | Shadow Table: Addresses (Business Address Services) | 22 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
22 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 23 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
23 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 35 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPBasic Functions |
24 | FSLSA | Foreign Trade: Legal Control-Sanctioned Party List-Address | 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPBasis Components |
25 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
26 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPClaims Management |
27 | ICLX_PARTICIPANT | Error Table for Participants with XI Input | 20 | POST_CODE1 | Participant: Participant Postal Code | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
28 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
29 | DFKKCIBW | FICA: Extraction of Cleared Items | 25 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
30 | DFKKESR | POR Payment Supplement | 9 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
31 | DFKKGP_SHORT | Data Extract: BP Data | 10 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
32 | DFKKOPBW | OI Extraction | 23 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
33 | DFKKZAX | Repayment Request (Address Data for Check) | 7 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
34 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 18 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPCountry-Specific Objects |
35 | COMC_TAXJUR_CITY | Tax Jurisdiction codes by City | 4 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
36 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 21 | POST_CODE1 | Postleitzahl des Orts | nvarchar | 10 | 0 | | |
TOPGlobal Trade Services |
37 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 28 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
38 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 61 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPLocalization |
39 | J_1BNFCPD | Nota Fiscal one-time accounts | 41 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPLocations Location Structure |
40 | EHFNDD_LOC_REV | Location - Revisions | 27 | POST_CODE1 | City Postal Code | nvarchar | 10 | 0 | | |
TOPMaster Data |
41 | EFISEL | Field Selection Control for Address Data | 14 | POST_CODE1 | City postal code | nvarchar | 1 | 0 | | |
42 | TECHSTR | Changes to Street Names | 3 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPMove-InOut |
43 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 12 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPOffer and Rental Request |
44 | VIOROO | Offered Object | 63 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
45 | VIORRR | Rental Request | 75 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
46 | NEHC_PAT | IS-H: Health Insurance Card (Patient Data) | 17 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPPayroll |
47 | T5HPBS06 | Technikai azonosító (1) - Közigazgatási szerv | 7 | POST_CODE1 | Helység irányítószáma | nvarchar | 10 | 0 | | |
48 | T5HPBS07 | Szervezeti egységek címe | 5 | POST_CODE1 | Helység irányítószáma | nvarchar | 10 | 0 | | |
TOPPortfolio |
49 | VDBILL_RES_HEAD | Bill Results Header | 33 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
50 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 13 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
51 | DFMCA_BRF650 | BRF: Business Partner Reading | 28 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
52 | DFMCA_BRF750 | BRF: Address Check | 10 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
53 | DFMCA_BRF760 | BRF: Read Location | 9 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
54 | DFMCA_BRF770 | BRF: Create Location | 14 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
55 | DFMCA_BRF820 | BRF: Address Autocorrection | 12 | POST_CODE1 | Field Name | nvarchar | 30 | 0 | | |
56 | DFMCA_BRF890 | BRF: Business Partner Determination from Form | 29 | POST_CODE1 | BRF: Expression | nvarchar | 20 | 0 | | |
TOPSales Promotions |
57 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 32 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPUse AP-MD-BP Components |
58 | BUTADRSEARCH | Mass Search Help: Business Partner | 14 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
TOPWaste Management |
59 | EEWA_CIC_FILTAB | IS-U CIC for Waste: Store Filter Data | 5 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
60 | EHSWAT_APPBP | MD: Waste Permit Partner | 34 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
61 | EHSWAT_MNBP | Waste Manifest/Delivery Note: Partners | 31 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | |
62 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 14 | POST_CODE1 | City postal code | nvarchar | 1 | 0 | | |
63 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 14 | POST_CODE1 | City postal code | nvarchar | 1 | 0 | | |