| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SDF/UST12 | Copy of table UST12 (used in Security Optimization Services) | 6 | BIS | Authorization Value | nvarchar | 40 | 0 | | |
2 | T548S | Date Conversion | 5 | BIS | Text for end date | nvarchar | 20 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
3 | FPB_GEN_PROF_LOG | Log Entries for Generating Authorizations | 8 | BIS | Authorization Value | nvarchar | 40 | 0 | | |
4 | FPB_VALUES | Authorizations for FG FPB_Berechtigungen | 7 | BIS | Authorization Value | nvarchar | 40 | 0 | | |
TOPCapacity Leveling |
5 | R2AUFNR | Order number for transfer from R/2 to PP-PI | 2 | BIS | Last order number in the interval to be transferred | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
6 | TE011 | Code for Tax Code Determination | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPContract Billing |
7 | DBERCHV | Consumption History | 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
8 | DBERCHZ | Individual Line Items | 21 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
9 | DBERCHZ1 | Individual line items | 21 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
10 | DBERCHZ5 | Individual line items (unimportant rows) | 21 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
11 | EBURNH | Burning Hour Calendar for Lighting Unit | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
12 | EDSCH | Discount Historical Data | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
13 | EKDI | Rate Facts | 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
14 | EPRESCLH | History of Price Adjustment Clause | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
15 | ERCHP | Analysis periods for dynamic period control | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
16 | ERCHV_GEN_PROT | Structure Log of Consumption History | 9 | BIS | To Date of Selection for ERCHV Structure | nvarchar | 8 | 0 | | |
17 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 20 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
18 | ERTFND | Rate Determination | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
19 | ETFND | Rate Determ. | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
20 | ETTAF | Rate Cat.Facts | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
21 | ETTIF | Instln Facts | 8 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
22 | ETTIFB | Installation Facts (Reference Values) | 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
23 | ETTIFN | Installation Facts (Normal) | 7 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPCustomer Service |
24 | EDISCOBJH | Disconn.Doc.: Disc.Period | 4 | BIS | Date to which a disconnection is valid | nvarchar | 8 | 0 | | |
25 | EDISCREMOV | Disconnection Document: Device Removal Periods | 5 | BIS | Date to which a disconnection is valid | nvarchar | 8 | 0 | | |
TOPDevice installation |
26 | EADZ | Multiple-Installation Billing Data: Register | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
27 | EASTI | Register Relationships | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
28 | EASTL | Billing data: Installation Structure at Device Level | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
29 | EASTS | Billing data: Installation Structure at Reg. Level | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
30 | ETDZ | Technical Data for Installed Register | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
31 | EZUG | Device Allocations for Device (Non-Metering Devices) | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
32 | EZUZ | Device Allocations for Register (Metering Devices) | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPDevice Management |
33 | EANAS | IS-U Device Checker: Current Processing Status of Test | 6 | BIS | Number of Last Object to be Tested | nvarchar | 30 | 0 | | |
34 | EDEVGR_CD | Change Document for Dev. Group: Table with Device Data | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
35 | EGERH | Historical Data of ISU Device Master Record | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
36 | EGERR | Device data: Info record for point of delivery - historical | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPEnergy Data Management |
37 | EEDMUISETTLUNIT | Allocation of Point of Delivery to Settlement Unit | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPGRC Access Control Plug-In |
38 | /VIRSA/FUNCTOBJ | Function - Objects | 7 | BIS | 'To' value | nvarchar | 40 | 0 | | |
39 | /VIRSA/ORGRULES | Organizational values | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
40 | /VIRSA/ORGUSERS | Mapping between users and the organizational values | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
41 | /VIRSA/ZCRAUTH | Authorization Objects | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
42 | /VIRSA/ZCRAUTHC1 | Restricted Critical Authorizations | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
43 | /VIRSA/ZCRAUTHL1 | SOD Authorization Object | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
44 | /VIRSA/ZCRAUTHL2 | SOD Authorization Object | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
45 | /VIRSA/ZCRAUTHL3 | SOD Authorization Object | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
46 | /VIRSA/ZCRAUTHL4 | SOD Authorization Object | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
47 | /VIRSA/ZCRAUTHL5 | SOD Authorization Object | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
48 | TFAIN | Calendar: Intervals for company holidays, special shifts | 4 | BIS | Date, until which the rule applies | nvarchar | 8 | 0 | | |
TOPIntegration Customer Relationship Management |
49 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
50 | EVER_CRMQ | ISU Contract CRM-Entry Queue | 7 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPIntercompany Data Exchange |
51 | EGRIDH | Allocation of Distributor to Grid | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
52 | EGRIDRATEDET | Rate Determination for Grid | 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPInvoicing |
53 | DBERDL | Print Document Line Items | 41 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
54 | DBERDZ | DB Table: Individ. Lines - Print Document | 47 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
55 | TE211 | BB: Rounding Parameter | 6 | BIS | Upper limit of budget billing amount for rounding | decimal | 12 | 2 | | |
56 | TE647 | Dynamic Determination of BB Cycle | 4 | BIS | Upper limit for dynamic determination of bud. billing cycle | decimal | 12 | 2 | | |
TOPMaster Data |
57 | EANLH | Install.Time Slice | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
58 | EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
59 | EVERH | IS-U Contract History | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPMeter Reading |
60 | EABLQDCONV | Conversion History for Quantity Det. During Meter Reading | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
61 | EABLQDCONVDEL | Conversion History for QD During (Deleted) Meter Reading | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
62 | EASTE | Register-related Period Consumption | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPMobile Applications |
63 | /ISDFPS/MECAA010 | Local Authorization (Item) for Logging | 11 | BIS | Authorization Value | nvarchar | 40 | 0 | | |
TOPPublic Sector |
64 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 40 | BIS | To-Period (5.0) | nvarchar | 6 | 0 | | |
65 | P01ZFA_NN_KIDS | ZfA: Notifications Not Assigned - Child Data | 18 | BIS | To-Period (5.0) | nvarchar | 6 | 0 | | |
TOPSAP Utilities |
66 | ECONCARDH | Business Partner - Concession Card: Time Slice | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
67 | ELPASS | Allocation of Load Profiles to any BOR Objects | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
68 | EUFASS | Allocation of Usage Factor to any BOR Objects | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
69 | EUFASS_HIST | Table of Usage Factor Applied to a Load Profile (History) | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
TOPUser and Authorization Management |
70 | USKRIA | Entry of Critical Auths for Report RSUSR009 | 5 | BIS | 'To' value | nvarchar | 40 | 0 | | |
71 | USKRIAT | Text table for USKRIA | 6 | BIS | 'To' value | nvarchar | 40 | 0 | | |
72 | UST12 | User master: Authorizations | 7 | BIS | Authorization Value | nvarchar | 40 | 0 | | |
TOPWaste Management |
73 | EEWA_GUARANTORH | Guarantor Contract History | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
74 | EEWA_PROP | Allocation of Cleaning Objects to Property | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
75 | EEWA_ROB | Cleaning Object | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
76 | EWAELOCEO | Allocation Table: Waste Disp. Object to Container Location | 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
77 | EWAELOCSD | Allocation Table: Container Loc.Data <-> Sales Document Item | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
78 | EWAELOCSD_INT | EWAELOCSD Dummy Table With Key Fields as CHAR | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
79 | EWAELOCSD_NEW | Allocation Table: Container Loc.Data <-> Sales Document Item | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
80 | EWAELOC_DIFFC | Allocation Table: Notes for Container Location | 5 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
81 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
82 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 6 | BIS | Valid-To Date | nvarchar | 8 | 0 | | |
83 | EWAOBJH_DATES | Appendix table of changed data for service frequency | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
84 | EWAOBJH_DIFFCULT | Service Frequency Notes | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
85 | EWAOBJH_SDSHARE | Subitems of Sales Document for Service Type | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
86 | EWAOBJH_SEQUENCE | Route Sequence per EWAOBJH | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
87 | EWAOBJH_UPOS | Subitems of Sales Document for Service Type | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
88 | EWAPROPSD | Allocation Table: Property <-> Sales Document Item | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
89 | EWA_CCOC_ASS_EQ | CO Assignment and Vehicle | 20 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
90 | EWA_CCOC_ASS_IUP | Assign CO Data for WD Item and SD Item | 17 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
91 | EWA_CCOC_ASS_IWP | Assign CO Data WD Item and Waste/Waste Disposal Facility | 18 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
92 | EWA_CCOC_ASS_RE | Allocate CO and Container (Rent) | 23 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
93 | EWA_CCOC_ASS_RS | Assign CO Data to Resources | 18 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
94 | EWA_CCOC_ASS_WP | CO Assignment to Waste Disposal Facility | 18 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
95 | EWA_CCOC_ASS_WPC | Allocation of CO Data for Weighing Transaction (Waste) | 18 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
96 | EWA_FAKTOR | Factors for Billing of Waste Management Services | 4 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |
97 | EWA_VBS | Table Supplement for Premise with Historical Data | 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | |