| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTEI/DU_WD_DCTP | Document types customzing table | 3 | VIEWID | View | nvarchar | 3 | 0 | | |
2 | /OTEI/DU_WD_EMAL | Email customizing table | 3 | VIEWID | View | nvarchar | 3 | 0 | | |
3 | /OTEI/DU_WD_TIST | Ticket Subject | 3 | VIEWID | View | nvarchar | 3 | 0 | | |
4 | /OTEI/DU_WD_TISU | Ticket Subject | 3 | VIEWID | View | nvarchar | 3 | 0 | | |
5 | /OTEI/DU_WD_TITL | Title and subtitle customizing table | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
6 | /OTEI/DU_WD_TITT | Title and subtitle customizing text table | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
7 | /OTEI/T_ACT_DELC | Configure Activity Log delete options | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
8 | /OTEI/T_A_LOG_CU | Table for activity logging configuration | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
9 | /OTEI/T_BUSDOC_C | Master for business document types | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
10 | /OTEI/T_CHANGE_C | Customizing options for changing actions in EFM | 5 | VIEWID | View | nvarchar | 3 | 0 | | |
11 | /OTEI/T_SET | EFM: General settings | 4 | VIEWID | View | nvarchar | 3 | 0 | | |
12 | NWVIEW_019 | Special View Data for Workflow Tasks | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
13 | RSCRMVIEWSTORE | Repository for ISQ Views | 3 | VIEWID | New View ID in BW30 | nvarchar | 30 | 0 | | |
TOPBusiness Analytics |
14 | UALAYOUT | Layout Table | 6 | VIEWID | Character Field Length = 10 | nvarchar | 10 | 0 | | |
15 | UALAYOUTT | Text Table for UALAYOUT | 6 | VIEWID | Character Field Length = 10 | nvarchar | 10 | 0 | | |
TOPBusiness Package for Manager Self-Service HR |
16 | TWPC_NAV | Define Navigation Types | 3 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
17 | TWPC_OTYPES | Object Types to be Displayed in the List | 2 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
18 | TWPC_OTYPES_C | Object Types to be Displayed in the List - Customer | 2 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
19 | TWPC_V | View Definition | 2 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
20 | TWPC_VG | Grouping the Views | 3 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
21 | TWPC_VG_C | Grouping the Views | 3 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
22 | TWPC_V_C | View Definition - Customer | 2 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
23 | TWPC_V_T | Texts for Views | 3 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
24 | TWPC_V_T_C | Texts for Views | 3 | VIEWID | View of an Organizational Structure | nvarchar | 6 | 0 | | |
TOPClinical System |
25 | N1VIEW_017_PERS | i.s.h.med: Personal Setting for View Type 017 | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
26 | NWVIEW_006 | IS-H / IS-H*MED: Special View Data Documents | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
27 | NWVIEW_011 | IS-H / IS-H*MED: Special View Data Surgeries | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
28 | NWVIEW_012 | IS-H / IS-H*MED: Special View Data Drug Order | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
29 | NWVIEW_013 | IS-H / IS-H*MED: Special View Data Drug Events | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
30 | NWVIEW_015 | Medication: Medication Order, Cross-Institutional | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
31 | NWVIEW_016 | IS-H / ISHMED: Special View Data Dictations | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
32 | NWVIEW_017 | i.s.h.med: Special View Data Surgery Progress Monitor | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
33 | NWVIEW_018 | IS-H/ISHMED: Special View Data Surgery Planning Work Station | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
34 | NWVIEW_P01 | IS-H / IS-H*MED: Spezialization Table for Patient Organizer | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
TOPCustomer Interaction Center |
35 | EWVIEW | CIC View: View of Object Data Environment | 2 | VIEWID | CIC View Identifier | nvarchar | 10 | 0 | | |
36 | EWVIEWATTR | CIC View: Attribute Control | 2 | VIEWID | CIC View Identifier | nvarchar | 10 | 0 | | |
TOPDealer Portal |
37 | /SAPDII/CCOM_SET | Component View Settings | 4 | VIEWID | Id-For view descriptions and Sequence | nvarchar | 4 | 0 | | |
38 | /SAPDII/C_COMPID | Value Table for Component ID | 4 | VIEWID | Id-For view descriptions and Sequence | nvarchar | 4 | 0 | | |
TOPEnd User Technology |
39 | RSRA_BC_LOG | Log Table for the Batch Runs for Precalculating Template | 11 | VIEWID | View ID | nvarchar | 40 | 0 | | |
40 | RSZWVIEW | Header Table for BW Views | 1 | VIEWID | Technical Name of a View | nvarchar | 30 | 0 | | |
41 | RSZW_WBITEMS | Table of Deleted BDS Items and Views | 3 | VIEWID | Medium-Length Description | nvarchar | 40 | 0 | | |
TOPMedia Product Sales and Distribution |
42 | JKSDDYN_FORM | Dynamic Formulas for Calc. Methods in Quantity Planning | 2 | VIEWID | Quantity Planning View | nvarchar | 3 | 0 | | |
43 | TJKSDVIEWFIHIER | Assignment of Quantity Planning Views to Filter Hierarchies | 2 | VIEWID | Quantity Planning View | nvarchar | 3 | 0 | | |
TOPOLAP Technology |
44 | RSRA_IXDS | Cluster table for storing the key for the DataStore | 3 | VIEWID | View ID | nvarchar | 40 | 0 | | |
TOPPatient Accounting |
45 | NWVIEW_L01 | IS-H: NL10 - View Type L01 - Table Control Settings | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
46 | NWVIEW_L02 | IS-H: NL10 - View Type L02 - Table Control Settings | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
47 | NWVIEW_L03 | IS-H: NL10 - View Type L03 - Table Control Settings | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
48 | NWVIEW_L04 | IS-H: NL10 - View Type L04 - Table Control Settings | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
49 | NWVIEW_L07 | IS-H: Definition of Form Folders | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
50 | NWVIEW_L07_FORMS | IS-H: Forms Entered for Case | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
51 | NWVIEW_W01 | IS-H: Workplace - View Type W01 - MiniApp Reports | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
TOPPatient Management |
52 | NWPVZ | Work Environment-to-View Assignment | 5 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
53 | NWPVZT | Work Environment-to-View Assignment | 6 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
54 | NWPVZ_USZ | IS-H / IS-H*MED: Work Environment-to-Service View Assignment | 5 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
55 | NWVIEW | Views in Work Stations | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
56 | NWVIEWT | Views in Work Stations | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
57 | NWVIEW_001 | IS-H / IS-H*MED: Speical View Data for Occupancy | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
58 | NWVIEW_002 | IS-H / IS-H*MED: Special View Data for Arrivals | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
59 | NWVIEW_003 | IS-H / IS-H*MED: Special View Data for Departures | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
60 | NWVIEW_004 | IS-H / IS-H*MED: Special View Data for Requests | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
61 | NWVIEW_005 | IS-H / IS-H*MED: Special View Data for Transport Orders | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
62 | NWVIEW_007 | IS-H/IS-H*MED: Special View Data Svce Facility/Outp. Clinic | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
63 | NWVIEW_008 | IS-H/IS-H*MED: Special View Data Medical Controlling | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
64 | NWVIEW_009 | IS-H / IS-H*MED: Special View Data Occupancy Characteristic | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
65 | NWVIEW_010 | IS-H / IS-H*MED: Special View Data Preregistrations | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
66 | NWVIEW_A01 | IS-H: Clinical Process Builder - Additional Data of View | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
67 | NWVIEW_A02 | IS-H: Clinical Process Builder - Modules for View | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
68 | NWVIEW_A05 | IS-H: Clinical Process Builder - Selection for Appt List | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
69 | NWVIEW_AP1 | IS-H: View Type AP1 - Search Variant for Standard Search | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
70 | NWVIEW_AP2 | IS-H: View Type AP2 - Search Variant for Enh. Time Slot Sear | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
71 | NWVIEW_FCD | Function Bar: Function Code Data | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
72 | NWVIEW_FCDT | Function Bar: Function Code Data | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
73 | NWVIEW_PERS | Personalization Information for View | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
TOPPlanning |
74 | N1WVIEW_PG_CL | IS-H*MED: Planning Grid Settings of Planning Objects | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
75 | N1WVIEW_PG_DT | IS-H*MED: Planning Grid Tab Page for Date View Type | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
76 | N1WVIEW_PG_DT_OU | IS-H*MED: PG Org. Unit Setting for DT and PO View Type | 4 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
77 | N1WVIEW_PG_OU | IS-H*MED: Planning Grid Tab Page for OU View Type | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
78 | N1WVIEW_PG_PO | IS-H*MED: Planning Grid Tab Page for Plan. Object View Type | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
79 | NWVIEW_014 | IS-H / IS-H*MED: Appointment Planning Special View Data | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
TOPSales and Distribution |
80 | SCEINVIEW | Allocation of Characteristic of Class to Org. Area | 5 | VIEWID | Organizational area to which characteristic can be assigned | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
81 | NWVIEW_FR1 | IS-H-FR: Special View Data for Absences | 3 | VIEWID | Identification of a View | nvarchar | 10 | 0 | | |
82 | NWVIEW_NL1 | Sichtdaten cockpit | 3 | VIEWID | Identifikation einer Sicht | nvarchar | 10 | 0 | | |
TOPWithout Description |
83 | RSCRMOLDBDSKEY | Query View: Links Old BDS Key with New View ID | 2 | VIEWID | Technical Name of a View | nvarchar | 30 | 0 | | |