| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 70 | SPARTE | Division | nvarchar | 2 | 0 | | |
2 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 70 | SPARTE | Division | nvarchar | 2 | 0 | | |
3 | EPRODDET | IS-U: Product Determination for Owner Move-in | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
4 | TE305 | Transactions for Company Code and Division | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
5 | TE305T | Transactions for Company Code and Division (Texts) | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPContract Billing |
6 | EDSC | Disc.Header Data | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
7 | EMDUSDIFACEHEAD | Time-of-Use Interface | 6 | SPARTE | Division | nvarchar | 2 | 0 | | |
8 | EMRSHIFT | Test BIN DAI !!!!!!!!!!!!!!!!!!! | 7 | SPARTE | Division | nvarchar | 2 | 0 | | |
9 | EPREI | Mstr Pricing Table for All Prices | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
10 | EPRESCL | Price Adjustment Clause for All Price Categories | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
11 | ERCH | Billing Doc. Data | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
12 | ERCH_RIVA | Header Data for Billing Document Extract (RIVA) | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
13 | ERCH_SHORT | Header Data for Billing Document - Extract | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
14 | ESCH | Billing Schema (Header Data) | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
15 | ETOUDCONSPAT | Consumption Pattern | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
16 | ETRF | Rate (Head. Data) | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
17 | ETTA | General Rate Category (Header Data) | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
18 | TE069 | Rate Types | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
19 | TE221 | Operands | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
20 | TE222 | Consumption Types | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
21 | TEPREPAY | Customizing Settings for Prepayment Meter | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
22 | TEPREPAY_NATURE | Description of Complaint Reason | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPCustomer Contact |
23 | BCONT | Business Partner Contact | 24 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPCustomer Service |
24 | EINIDATCRI | Initial Data Creation Doc.: Premise - Installation Data | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPDevice Management |
25 | EGERR | Device data: Info record for point of delivery - historical | 26 | SPARTE | Division | nvarchar | 2 | 0 | | |
26 | EGTUR | Periodic Replacement List | 15 | SPARTE | Division | nvarchar | 2 | 0 | | |
27 | ETYP | Dev. Cat.: IS-U Additional Material Data | 34 | SPARTE | Division | nvarchar | 2 | 0 | | |
28 | TE025A | Sample Device Determination | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
29 | TE025B | Extension Periods for Official Lots | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
30 | TE025C | Sample Device Determination | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
31 | TE269 | Dev.Req. Planning | 8 | SPARTE | Division | nvarchar | 2 | 0 | | |
32 | TE271 | Sample Lot | 7 | SPARTE | Division | nvarchar | 2 | 0 | | |
33 | TE595 | Allocation of Group Type to Division | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
34 | TELOT_CRDEF | Specifications for Lot Compilation (B/NL) | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
35 | TELOT_LOCKED | Blocked Devices During Lot Compilation (B/NL) | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
36 | TELOT_RESULT | Results of Lot Allocation for Belgium/Netherlands | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
37 | TELOT_RESULT_TOP | Header Table for Lot Allocation Results for B/NL | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPEnergy Data Management |
38 | EEDMIMPORTLOG_DB | EDM Import Log: Database Table | 25 | SPARTE | Division | nvarchar | 2 | 0 | | |
39 | EPROFHEAD | Profile Header Data | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
40 | EPROFHEAD_TMP | Header Data of Temporary Profile | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
41 | ERTPINTERFACE | RTP Interface (Header Data) | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPEquipment |
42 | EQUI | Equipment master data | 65 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
43 | TFSCHVTV | Transactions for Company Code and Division | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
44 | TFSCHVTVT | Transactions for Company Code and Division (Texts) | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPIntercompany Data Exchange |
45 | EDEREGSCENARIO | Supply Scenario | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
46 | ESERVICE | Point of delivery service | 10 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPInvoicing |
47 | DBERDL | Print Document Line Items | 9 | SPARTE | Division | nvarchar | 2 | 0 | | |
48 | DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item | 11 | SPARTE | Division | nvarchar | 2 | 0 | | |
49 | DBERDZ | DB Table: Individ. Lines - Print Document | 24 | SPARTE | Division | nvarchar | 2 | 0 | | |
50 | EITR | Temporary Selection Data for IS-U Invoicing | 11 | SPARTE | Division | nvarchar | 2 | 0 | | |
51 | EJVL | Yearly Advance Payment | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
52 | ERDTS | Additional Charges and Taxes of a Print Document | 9 | SPARTE | Division | nvarchar | 2 | 0 | | |
53 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 18 | SPARTE | Division | nvarchar | 2 | 0 | | |
54 | TE558 | Amount/Process Limits for Pay.Scheme Adjustment in Invoicing | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
55 | TE560 | Percentage Limits for Manual Payment Scheme Changes | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
56 | TE757 | General Amount Adjustment Factor for BB Plan | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPMarketing |
57 | EMKT_ESTM_CONS | Marketing: Extrapolated Consumption for Each Contract | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
58 | EMKT_ESTM_CONS_P | Marketing: Extrapolation Index for Mass Activity | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPMaster Data |
59 | EANL | Installation | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
60 | EKON | Franchise Contract MasterData | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
61 | ELACCZ | Loyalty Account Line Item | 17 | SPARTE | Division | nvarchar | 2 | 0 | | |
62 | EVER | IS-U Cont. | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
63 | TE001 | Alloc. of Co. Code - Division | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
64 | TE097 | Account Determ. IDs | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
65 | TE097T | Account Determ. IDs - Texts | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
66 | TECAMIOVARAS | IS-U: Permitted Contract Model for Parking | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
67 | TECAMIOVARAST | IS-U: Permitted Contract Models (Text Table) | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
68 | TETECHINST | Allocation of division and technical installation | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPMeter Reading |
69 | EBIAS | Table for Calculation of BIAS Factor | 8 | SPARTE | Division | nvarchar | 2 | 0 | | |
70 | ETRG | Billing Order | 6 | SPARTE | Division | nvarchar | 2 | 0 | | |
71 | TE410 | Parameters for MR Data Processing | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
72 | TE411 | Estimation Parameters: MR Data Entry | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
73 | TE630 | Control of Meter Reading Proc. | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
74 | TE935 | Automatic Meter Reading Monitoring | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPMove-InOut |
75 | ECAMIOPRCI | IS-U: Parked Document: Contracts and Installations | 8 | SPARTE | Division | nvarchar | 2 | 0 | | |
76 | TE490AV | Move-Out Control: Contract Level | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
77 | TE490EV | Move-In Control: Contract Level | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
78 | TECAMIOVARAM | IS-U: Pre-entry Variants / Permitted Master Data Templates | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
79 | TECAMIOVARAMT | IS-U: Permitted Master Data Templates (Text Tables) | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
80 | TECAMIOVARAP | IS-U: Pre-entry Variants / Permitted Products | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
81 | TECAMIOVARAPT | IS-U: Permitted Contract Models (Text Table) | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
82 | TECAMIOVARSP | IS-U: Pre-entry Variants: Division-dependent Data | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
83 | JWTWEKO | IS-M/SD: Sales Activity for Business Partner | 16 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPProcessing |
84 | EWMINSPDETAIL | Inspection List Detail | 7 | SPARTE | Division | nvarchar | 2 | 0 | | |
85 | EWMPERIODEQ | Periods for equipment inspections | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
86 | EWMPERIODTI | Periods for technical installation inspections | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
87 | TESERVICE | Alloc. of Service Obj. to Division and Set Level | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPRegional structure |
88 | ADRCITYCCS | Division-Dependent Data for City | 4 | SPARTE | Division | nvarchar | 2 | 0 | | |
89 | ADRCITYKON | Franch. Contracts for City | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |
90 | ADRSTRTCCS | Division-Dependent Data for Street | 9 | SPARTE | Division | nvarchar | 2 | 0 | | |
91 | ADRSTRTKON | Franchise Contracts for Street | 10 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPRegulatory reporting for insurance companies |
92 | ISSRFLDEO | Object table 1 | 10 | SPARTE | Insurance Line of Business Indicator | nvarchar | 2 | 0 | | |
93 | ISSR_RPI_MFT | ISSR: Feste und variable Daten Meldewesen | 14 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
94 | ISSR_RPI_MFT_BCK | ISSR: Feste und variable Daten Meldewesen als Backuptabelle | 14 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
95 | TISSR_ADMIN_FVAL | Festwertsteuerung für Meldewesen-Stammdatenverwaltung | 6 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
96 | TISSR_BPV_ANRECH | Meldewesen Schweiz - Anrechnungsfaktor | 4 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
97 | TISSR_BPV_SKZ_SP | Meldewesen Schweiz - erlaubte Kombinationen SichFonds/Sparte | 4 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
98 | TISSR_CHA_MD_PRO | Protokoll bei Stammdatenänderung | 22 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
99 | TISSR_DEPOT_FVAL | Festwertmodifikation für Meldewesen-Depotdaten | 4 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
100 | TISSR_SPARTE | ISSR: Versicherungssparte | 2 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
101 | TISSR_SPARTET | ISSR: Versicherungssparte Texttabelle | 3 | SPARTE | Kennzeichen Versicherungssparte | nvarchar | 2 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
102 | TNWCHTMDIVIS | IS-H CH: TARMED - Leistungsregel Spartenzuschlag | 4 | SPARTE | IS-H CH: codice settore | nvarchar | 4 | 0 | | |
TOPSAP Utilities |
103 | ELPROF | Load Profile Header Data | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
104 | TECONTYP | Concession Type | 9 | SPARTE | Division | nvarchar | 2 | 0 | | |
105 | TESPT | Alloc. of Div. Cat. to Div. | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPStatistics |
106 | S440 | IS-U rate statistics | 8 | SPARTE | Division | nvarchar | 2 | 0 | | |
107 | S440E | S440: Structure Information | 3 | SPARTE | Division | nvarchar | 2 | 0 | | |
108 | S441 | IS-U Industry Statistics | 12 | SPARTE | Division | nvarchar | 2 | 0 | | |
109 | S441E | S441: Structure Information | 7 | SPARTE | Division | nvarchar | 2 | 0 | | |
110 | TE775 | Update Group Determination | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
111 | TE776 | UIS: Alloc. of Billing Unit of Meas. -> Stat. Unit of Meas. | 2 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPTransaction Manager |
112 | TWD01 | Treasury: Securities Account Master Data | 46 | SPARTE | Insurance Line of Business Indicator | nvarchar | 2 | 0 | | |
TOPVisit Control |
113 | /DSD/VC_VLP | DSD: Visit List - Item Data | 11 | SPARTE | Division | nvarchar | 2 | 0 | | |
114 | /DSD/VC_VPP | DSD: Visit Schedule - Item Data | 13 | SPARTE | Division | nvarchar | 2 | 0 | | |
TOPWaste Management |
115 | TEROBTYP | Customizing for Cleaning Object Category | 5 | SPARTE | Division | nvarchar | 2 | 0 | | |