| 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 | 51 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
2 | /FLDQ/AD_QTRRVW | Cleansed addresses from RSADRQU2 to review before comitting | 49 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
3 | /FLDQ/AD_QU_INDX | QU2 Index Table | 50 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
4 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 52 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
5 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 52 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
6 | /FLDQ/HNA_PREQU2 | staging table for RSADRQU2 report | 50 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
7 | /FLDQ/HNA_PSTQU2 | Result Table for RSADRQU2 report | 50 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
8 | /MRSS/D_BUND_ORI | Bundled Demand Original data | 62 | TIME_ZONE | Time Zone of Demand | nvarchar | 6 | 0 | | |
9 | /OPT/VT_VA2_PAR | VIM Analytics 2: Parameters for Data Selection | 3 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
10 | /SAPQUERY/TA01 | Airports | 4 | TIME_ZONE | Airport time zone | nvarchar | 6 | 0 | | |
11 | /SDF/DRM_CONF | Data Readyness Monitoring - Configuration | 6 | TIME_ZONE | System Time Zone | nvarchar | 6 | 0 | | |
12 | /SDF/DRM_RESULTS | Data Readyness Monitoring - Results | 4 | TIME_ZONE | System Time Zone | nvarchar | 6 | 0 | | |
13 | /XLSO/USR_TIMZON | Users and there Timezone | 3 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
14 | BBP_PCPOS | Procurement Card Statement: Position Data | 36 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
15 | BBP_SUS_STG_ADR | Staging address table | 35 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
16 | BBP_TIMEZONE_FAV | User-Specific Favorites for Time Zones | 3 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
17 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 36 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
18 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 36 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
19 | EHFNDD_TS_ROOT | Time Series - Root | 13 | TIME_ZONE | Time Zone of Data Series | nvarchar | 6 | 0 | | |
20 | GRACREQUSER | User Associated with Request | 26 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
21 | GRACUSERDEFAULT | User default | 6 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
22 | HRRCF_D_INTVSCDL | Interview Schedule | 15 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
23 | REQADDRESS | Delivery Address for Requirement Coverage Request Lines | 80 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
24 | PIQDB_NL_ADDR | Maintain GBA Address | 38 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
TOPABAP Workbench, Java IDE and Infrastructure |
25 | SAIRPORT | Airports | 4 | TIME_ZONE | Airport time zone | nvarchar | 6 | 0 | | |
TOPAddress ManagementBusiness Address |
26 | ADRC | Addresses (Business Address Services) | 82 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
27 | ADRCITY | Postal cities | 7 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
28 | ADRCS | Shadow Table: Addresses (Business Address Services) | 83 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
29 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 84 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
30 | ADRDIF_CT | City Difference Table for Quarterly Adjustment | 17 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
TOPBusiness Objects, Common Components |
31 | EHFNDD_DTS_ROOT | Data Series - Root | 9 | TIME_ZONE | Time Zone of Data Series | nvarchar | 6 | 0 | | |
TOPCommunication Services Mail, Fax, SMS, Telephony |
32 | SPH_SITES | SAPphone: Site Attributes | 7 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
33 | CCMSBI_CUSTDATA | Time-Dependent General MTE Data | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
34 | CCMSBI_METHODS | Time-Dependent Reaction Methods | 11 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
35 | CCMSBI_THRH_VAL | Time-Dependent Threshold Values | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPEnergy Data Management |
36 | EEDMSETTLDOC | Settlement Document (Header) | 7 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
37 | EPROFHEAD | Profile Header Data | 34 | TIME_ZONE | Time Zone for EDM Objects | nvarchar | 6 | 0 | | |
38 | EPROFHEAD_TMP | Header Data of Temporary Profile | 34 | TIME_ZONE | Time Zone for EDM Objects | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
39 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 82 | TIME_ZONE | Zeitzone der Adresse | nvarchar | 6 | 0 | | |
TOPGeographical Functions |
40 | GEOZ5GOLD | Table for ZIP5GOLD Geo-Coder (Zipcodes USA) | 6 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPGlobal Trade Services |
41 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 66 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
42 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 99 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
TOPIncident Recording |
43 | EHHSSD_INC_PSTAT | Incident - Person Statement | 10 | TIME_ZONE | Time Zone of Statement | nvarchar | 6 | 0 | | |
44 | EHHSSD_INC_VIOLN | Incident - Violation Notice | 13 | TIME_ZONE | Time Zone of NOV Issue Date | nvarchar | 6 | 0 | | |
TOPIntercompany Data Exchange |
45 | EIDESWTDOC | Switch Document Header | 21 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
46 | EIDESWTDOCTMP | Temporary Switch Document Header Data | 21 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPLocalization |
47 | J_1BNFCPD | Nota Fiscal one-time accounts | 79 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | |
TOPLogistics - General |
48 | CMDET_S06667 | Individual Records for Updating External Credit Data | 19 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPMaintenance Orders |
49 | /MRSS/D_DEM_PLR | Data required for planning-relevant items | 62 | TIME_ZONE | Time Zone of Demand | nvarchar | 6 | 0 | | |
50 | /MRSS/D_PN_HD | Planning Node - Header Data | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
51 | /MRSS/D_SHIFTS | Standard Shift Schedule for Organizational Unit | 7 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPMaintenance Processing |
52 | ALM_ME_C002 | MAM Scenario Device Settings | 4 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPMaster Data |
53 | EFISEL | Field Selection Control for Address Data | 45 | TIME_ZONE | Address time zone | nvarchar | 1 | 0 | | |
TOPMonitoring |
54 | ALPFREP_CAT | PerfDB Reporting Catalog | 14 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
55 | ALPFTHRHIST_TB | Performance Threshold History | 8 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
56 | CCMSBIDATA | Time-Dependent General MTE Data | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
57 | CCMSBIMETH | Time-Dependent MTE Reaction Methods | 11 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
58 | CCMSBITHRH | Time-Dependent MTE Threshold Values | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
59 | CCMSBI_MTE_DATA | Time-Dependent General MTE Data | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
60 | CCMSBI_MTE_METH | Time-Dependent MTE Reaction Methods | 11 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
61 | CCMSBI_MTE_THRH | Time-Dependent MTE Threshold Values | 10 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPProduction Orders |
62 | COCF_SR | Shift Reports in PDF Format | 15 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
63 | COCF_SR_DSIGMETA | Signature Tool: Metadata for Shift Report | 16 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPSAP Business Workflow |
64 | SWN_COLSCHED | WF Notif: Selection Schedule | 8 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
65 | SWN_DELSCHED | WF Notif: Schedule for Delivery | 6 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPSAP Multiresource Scheduling |
66 | /MRSS/C_POT_TZN | Pot Time Zone | 4 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
67 | /MRSS/D_POT_MD | Pot Master data attributes | 7 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPService Station Retailing |
68 | OIRC_DRREJ | SSR Stocks - Dip readings rejected records | 120 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
69 | OIRC_GMMH | SSR Meters - History | 23 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
70 | OIRC_GMMH_DEL | SSR Meters - Deleted meter readings history | 24 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
71 | OIRC_MRREJ | SSR Meters - Meter readings rejected records | 26 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
72 | OIRC_PRCHK | SSR Pricing - Price check | 7 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
73 | OIRC_SOCDIP | SSR Stocks - Dip readings history | 117 | TIME_ZONE | SSR Fuels - Service station time zone | nvarchar | 6 | 0 | | |
TOPSupplier Managed Inventory |
74 | SMI_ITEM | SMI Item Data | 41 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |
TOPTravel Planning |
75 | TA21L | IATA Locations | 9 | TIME_ZONE | Time zone (Amadeus-specific) | nvarchar | 3 | 0 | | |
TOPWaste Management |
76 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 45 | TIME_ZONE | Address time zone | nvarchar | 1 | 0 | | |
77 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 45 | TIME_ZONE | Address time zone | nvarchar | 1 | 0 | | |
TOPWork Clearance Management |
78 | WCAMA | WCM: General User Settings | 4 | TIME_ZONE | Time Zone | nvarchar | 6 | 0 | | |