| 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 | 12 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 26 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
3 | /FLDQ/AD_QU_INDX | QU2 Index Table | 22 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
4 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 13 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
5 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 13 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
6 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 22 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
7 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 22 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
8 | /SMD/MD_____00DL | SID-Tabelle fuer Reg. Struct. Grp. | 3 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
9 | BBP_PCPOS | Procurement Card Statement: Position Data | 56 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
10 | BBP_SUS_STG_ADR | Staging address table | 7 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
11 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 8 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
12 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 8 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
13 | PIQDB_NL_ADDR | Maintain GBA Address | 10 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPAddress ManagementBusiness Address |
14 | ADRC | Addresses (Business Address Services) | 20 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
15 | ADRCITY | Postal cities | 11 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
16 | ADRCS | Shadow Table: Addresses (Business Address Services) | 21 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
17 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 22 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
18 | ADRDIF_CT | City Difference Table for Quarterly Adjustment | 14 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
19 | ADRDIF_ST | Street Difference Table for Quarterly Adjustment | 31 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
20 | ADRREGGRP | Regional structure grouping | 2 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
21 | ADRREGGRPT | Grouping of the regional structure (long texts) | 3 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
22 | ADRSTREET | Streets | 8 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
23 | ADRSTRPCD | Street (section)/postal code: Assignment | 14 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPAMI Event Management |
24 | EFDT_EXPR003 | FDT: Expression - Create Service Order | 6 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
25 | EFDT_EXPR003A | FDT: Expression - Create Service Order | 6 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
26 | EFDT_EXPR003S | FDT: Expression - Create Service Order | 5 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
27 | EFDT_EXPR003T | FDT: Expression - Create Service Order | 5 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPDevice Management |
28 | EGTUR | Periodic Replacement List | 16 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
29 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 20 | REGIOGROUP | Gruppierung der Regionalstruktur | nvarchar | 8 | 0 | | |
TOPGlobal Trade Services |
30 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 27 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
31 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 60 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPIntegration Customer Relationship Management |
32 | ECRMSALSERVDATA | Customizing Table for CRM Organization Data | 2 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPLocalization |
33 | J_1BNFCPD | Nota Fiscal one-time accounts | 40 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPMaster Data |
34 | EFISEL | Field Selection Control for Address Data | 50 | REGIOGROUP | Regional structure grouping | nvarchar | 1 | 0 | | |
35 | EHAUISU | Connect. Obj. | 4 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
36 | EVER | IS-U Cont. | 75 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPProcessing |
37 | EWMINSPDETAIL | Inspection List Detail | 8 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
38 | TEREGPLANTWC | Allocation of Workplace to Service Obj. and Regional Group | 6 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPRegional structure |
39 | EADRREGAREAA | Role-Spec. Allocation: Reg. Str. Area to Reg. Str. Group | 3 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
TOPWaste Management |
40 | EEWA_CAPAB_KEY | IS-U Waste: Capacity Planning - Key and Index Table | 5 | REGIOGROUP | Political regional structure element | nvarchar | 8 | 0 | | |
41 | EEWA_ROB | Cleaning Object | 34 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | |
42 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 50 | REGIOGROUP | Regional structure grouping | nvarchar | 1 | 0 | | |
43 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 50 | REGIOGROUP | Regional structure grouping | nvarchar | 1 | 0 | | |
44 | EWAROUTE | Header table of route | 30 | REGIOGROUP | Political regional structure element | nvarchar | 8 | 0 | | |
45 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 28 | REGIOGROUP | Political regional structure element | nvarchar | 8 | 0 | | |
46 | TEDIFFCULTVALUES | Evaluation of Notes | 3 | REGIOGROUP | Political regional structure element | nvarchar | 8 | 0 | | |
47 | TESERVICETYPEVAL | Valuation of service types | 3 | REGIOGROUP | Political regional structure element | nvarchar | 8 | 0 | | |