| 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 | 5 | CITY1 | City | nvarchar | 40 | 0 | | |
2 | /FLDQ/AD_INI_ERR | Record records which encounter an error in RSADRINI | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
3 | /FLDQ/AD_INI_IDX | Copy of Shadow Table /fldq/ad_mtc_sh | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
4 | /FLDQ/AD_MTCCODE | FirstLogic Match Code Index Table | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
5 | /FLDQ/AD_MTCRSLT | Match Results table to store results from RSADRINI program | 23 | CITY1 | City | nvarchar | 40 | 0 | | |
6 | /FLDQ/AD_MTC_SH | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
7 | /FLDQ/AD_MTC_SH2 | FirstLogic Shadow table for /FLDQ/AD_MTCCODE | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
8 | /FLDQ/AD_PUPDATE | Matchcode Records pending to be updated | 22 | CITY1 | City | nvarchar | 40 | 0 | | |
9 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 19 | CITY1 | City | nvarchar | 40 | 0 | | |
10 | /FLDQ/AD_QU_INDX | QU2 Index Table | 15 | CITY1 | City | nvarchar | 40 | 0 | | |
11 | /FLDQ/BPMTCCD | Generated Match Code Table for BP | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
12 | /FLDQ/BPMTCDISP | Generated Display Table for BP | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
13 | /FLDQ/BPMTCPUD | Generated Pending Update Table for BP | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
14 | /FLDQ/BPMTCSHDW | Generated Match Shadow Table for BP | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
15 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 6 | CITY1 | City | nvarchar | 40 | 0 | | |
16 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 6 | CITY1 | City | nvarchar | 40 | 0 | | |
17 | /FLDQ/HNA_BM_IN | HANA task Batch Match Input Records | 15 | CITY1 | City | nvarchar | 40 | 0 | | |
18 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 15 | CITY1 | locality with increased size to stop truncation | nvarchar | 200 | 0 | | |
19 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 15 | CITY1 | locality with increased size to stop truncation | nvarchar | 200 | 0 | | |
20 | /SAPSRM/SH_PLANT | Table for ERP Search Help Plants | 8 | CITY1 | City | nvarchar | 40 | 0 | | |
21 | CNVTDMS_11_SCADR | Scrambling Addresses | 8 | CITY1 | City | nvarchar | 40 | 0 | | |
22 | TIVXCNLHPCITY | Highly populated cities | 2 | CITY1 | City | nvarchar | 40 | 0 | | |
23 | T7PIQ_NL_INSBRIN | BRIN Number of the Institute | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
24 | T7PIQ_NL_INSTIT | Institutes and Education Details | 16 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPAddress ManagementBusiness Address |
25 | ADRC | Addresses (Business Address Services) | 13 | CITY1 | City | nvarchar | 40 | 0 | | |
26 | ADRCS | Shadow Table: Addresses (Business Address Services) | 14 | CITY1 | City | nvarchar | 40 | 0 | | |
27 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 15 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPBank Customer Accounts |
28 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 32 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPBasic Functions |
29 | FSLSA | Foreign Trade: Legal Control-Sanctioned Party List-Address | 9 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPBasis Components |
30 | /XFT/INV_Q_6 | PO details (header) for an invoice receipt process | 32 | CITY1 | City | nvarchar | 40 | 0 | | |
31 | /XFT/INV_Q_6_S | PO details (header) for an invoice receipt process | 32 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPChina |
32 | PA0528 | HR Master Record: Infotype 0528 (Family information) | 53 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPClaims Management |
33 | ICLX_PARTICIPANT | Error Table for Participants with XI Input | 21 | CITY1 | Participant: Participant City | nvarchar | 40 | 0 | | |
TOPCollectionsDisbursements |
34 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 12 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPContract Accounts Receivable and Payable |
35 | DFKKESR | POR Payment Supplement | 10 | CITY1 | City | nvarchar | 40 | 0 | | |
36 | DFKKGP_SHORT | Data Extract: BP Data | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
37 | DFKKZAX | Repayment Request (Address Data for Check) | 5 | CITY1 | City | nvarchar | 40 | 0 | | |
38 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 15 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPFinancial Accounting |
39 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 13 | CITY1 | Ort | nvarchar | 40 | 0 | | |
TOPGlobal Trade Services |
40 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 20 | CITY1 | City | nvarchar | 40 | 0 | | |
41 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 53 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPHong Kong |
42 | PA0345 | HR Master Record: Infotype 0345 (Hong Kong Tax) | 30 | CITY1 | City | nvarchar | 25 | 0 | | |
TOPLocalization |
43 | J_1BNFCPD | Nota Fiscal one-time accounts | 33 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPLocations Location Structure |
44 | EHFNDD_LOC_REV | Location - Revisions | 26 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPMaster Data |
45 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 8 | CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | |
46 | EFISEL | Field Selection Control for Address Data | 13 | CITY1 | Location | nvarchar | 1 | 0 | | |
47 | TECHSTR | Changes to Street Names | 4 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPMaterials Management |
48 | /ISDFPS/1DPERH | EHS: Single Permit Header | 19 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPMove-InOut |
49 | ECAMIOPRADDR | IS-U: Parked Document: Addresses (Business Partner) | 16 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPNon Profit Organizations |
50 | PA3244 | HR Master Record: Infotype 3244 | 27 | CITY1 | NPO City | nvarchar | 60 | 0 | | |
TOPOffer and Rental Request |
51 | VIOROO | Offered Object | 64 | CITY1 | City | nvarchar | 40 | 0 | | |
52 | VIORRR | Rental Request | 76 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPPayroll |
53 | T5HPBS06 | Technikai azonosító (1) - Közigazgatási szerv | 5 | CITY1 | Helység | nvarchar | 40 | 0 | | |
54 | T5HPBS07 | Szervezeti egységek címe | 4 | CITY1 | Helység | nvarchar | 40 | 0 | | |
TOPPersonnel Administration |
55 | T7PLD1 | Payee data | 18 | CITY1 | City | nvarchar | 40 | 0 | | |
56 | T7PLD2 | GUS reporting entity data | 7 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPPhilippines |
57 | PA0634 | Philippines Previous Employer Information Info-type | 26 | CITY1 | Prev Employer's City | nvarchar | 30 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
58 | DFMCA_BRF540 | BRF: Create Address for Business Partner | 10 | CITY1 | BRF: Expression | nvarchar | 20 | 0 | | |
59 | DFMCA_BRF750 | BRF: Address Check | 7 | CITY1 | BRF: Expression | nvarchar | 20 | 0 | | |
60 | DFMCA_BRF760 | BRF: Read Location | 7 | CITY1 | BRF: Expression | nvarchar | 20 | 0 | | |
61 | DFMCA_BRF770 | BRF: Create Location | 11 | CITY1 | BRF: Expression | nvarchar | 20 | 0 | | |
62 | DFMCA_BRF820 | BRF: Address Autocorrection | 9 | CITY1 | Field Name | nvarchar | 30 | 0 | | |
TOPSales Promotions |
63 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 29 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
64 | TN50A | Default Values for ASL and ISTAT Code | 2 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPSAP NetWeaver Mobile - Use subcomponents |
65 | MEREP_ADDRESS | Address (Sample Application) | 4 | CITY1 | City1 (Sample Application) | nvarchar | 40 | 0 | | |
TOPStakeholder Relationship Management |
66 | USC_CONT_ADD | SRM Contact: Event Info | 12 | CITY1 | City | nvarchar | 40 | 0 | | |
TOPWaste Management |
67 | EEWA_CIC_FILTAB | IS-U CIC for Waste: Store Filter Data | 6 | CITY1 | City | nvarchar | 40 | 0 | | |
68 | EHSWAT_APPBP | MD: Waste Permit Partner | 32 | CITY1 | City | nvarchar | 40 | 0 | | |
69 | EHSWAT_MNBP | Waste Manifest/Delivery Note: Partners | 29 | CITY1 | City | nvarchar | 40 | 0 | | |
70 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 13 | CITY1 | Location | nvarchar | 1 | 0 | | |
71 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 13 | CITY1 | Location | nvarchar | 1 | 0 | | |