| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GEP/FLEET_T_CPO | Car Pools | 2 | TPLNR | Car Pool | nvarchar | 30 | 0 | | |
2 | /GEP/T_NEED | Graphischer Leitstand: Bedarfe (einzuplanende Objekte) | 43 | TPLNR | Fuhrpark | nvarchar | 30 | 0 | | |
3 | /GEP/T_SPLIT | Graphischer Leitstand: Splits (eingeplante Objekte) | 44 | TPLNR | Fuhrpark | nvarchar | 30 | 0 | | |
4 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 121 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
5 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
6 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 121 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
7 | /SMERP/STG_PM004 | Data staging - Equipment list set - Measuring Points | 61 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
8 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
9 | /SMERP/STG_PM009 | Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab | 61 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
10 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
11 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
12 | CIF_IMRESTMFL | Integration Model Reference Table for Functional Location | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
13 | CNVTDMS_05_TPLNR | Fill header for Conn. Object | 3 | TPLNR | Char 30 | nvarchar | 30 | 0 | | |
14 | EAM_REG_PLAN | Regular Task Planning Schedule | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
15 | GHO_ALC_SRC_DFEV | Deferment Event source data to invalidate Allocation results | 6 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
16 | GHO_ALERT | Store Network Alerts | 10 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
17 | GHO_DM_EVENT | Deferment Event Data | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
18 | GHO_EVT_SRC_DATA | Table to store deferment events souce data used in alloc run | 11 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
19 | GHO_WC_NATURE | Well completion nature | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
20 | GHO_WELLCLASS_LC | Well class Lifecycle | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
21 | IEAM_TASK_LT | Task Attributes | 5 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
22 | S555E | S555 - Structural Information | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
23 | S901E | S901 - Strukturinformationen | 5 | TPLNR | Technischer Platz | nvarchar | 30 | 0 | | |
24 | SFTT_EQUI | Equipment Status diary | 6 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
25 | SFTT_EQUIC | Equipment Current Status | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
26 | SFTT_EQUIM | Equipment Master Data | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
27 | SFTT_REG_TASK | Regular Tasks List for Item Data | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
28 | SFTT_SN | Shift Notes: Master Data | 7 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
29 | TTS_SM_DATA | Safety Measure and Supplemental Safety Measure Data | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPAerospace Defence Industry Solution |
30 | EQUIPKPI | Used to store the Delta values and counters for MTBE calc | 5 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPAppropriation Requests |
31 | IMAK | Appropriation requests - general data | 17 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPBasic Functions |
32 | ANLZ | Time-Dependent Asset Allocations | 21 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPBills of Material |
33 | TPST | Link Between Functional Location and BOM | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPBulk Distribution Requirements Planning |
34 | OIIGMMK | GMM: General meter header table | 6 | TPLNR | Functional location ID | nvarchar | 30 | 0 | | |
TOPData Collection |
35 | S064E | S064 - Structural information | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
36 | S116 | Customer Analysis | 14 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
37 | S116E | S116 - Structural information | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
38 | S555 | Info structure Wolgang Backes | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
39 | S901 | Garantieauswertung | 10 | TPLNR | ??????????? ????? | nvarchar | 30 | 0 | | |
TOPDistributed Maintenance |
40 | /ISDFPS/PMDISFL | Distributed Maintenance - Dismantled Functional Locations | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPEquipment |
41 | IEQT_WL_ITEMS | Interim Statuses - Items | 65 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
42 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 66 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPFlexible Real Estate Management |
43 | VIBDPMFL | OBSOLETE: Link from RE Object to Functional Location | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPFunctional Locations |
44 | IFLOCUST | System-Specific Settings | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
45 | IFLOS | Functional Location Labels | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
46 | IFLOS_VS | Functional Location Labels (Version Table) | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
47 | IFLOT | Functional Location (Table) | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
48 | IFLOTX | Functional Location: Short Texts | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
49 | IFLOTX_VS | Functional Location Data Fields: Short Texts (Version Table) | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
50 | IFLOT_VS | Functional Location (Version Table) | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
51 | ILOA | PM Object Location and Account Assignment | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
52 | ILOA_VS | Location & Account Assignment for PM Object (Version Table) | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPGeographical Information System |
53 | GHO_TEMP_TPLNR | Stores temp tplnr table | 1 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPIndustrial Hygiene and Safety |
54 | CCIHT_IAL | EHS: Incident/Accident Log - Header | 23 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPInvestment Programs |
55 | IMPR | Investment Program Positions | 25 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPLogbook |
56 | ADFSH_FLGTDET | Flight Scheduling: Flight Schedule Details | 11 | TPLNR | Flight Scheduling: Actual Aircraft Registration | nvarchar | 30 | 0 | | |
57 | ADFSH_FLGTMAS | Flight Scheduling: Flight Schedule Master | 22 | TPLNR | Flight Scheduling: Planned Aircraft Registration | nvarchar | 30 | 0 | | |
TOPMaintenance |
58 | /ISDFPS/PM_MB_H | PM Maintenance Book - Header | 20 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMaintenance History |
59 | HIVG | PM order history - operations | 71 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMaintenance Notifications |
60 | QMFE | Quality notification - items | 57 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMaintenance Orders |
61 | /CUM/CUDESIGN | CU: Design Header Data | 21 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
62 | /CUM/PRF_ORD | CU: Profile for Order Generation | 15 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
63 | T352R | Maintenance revisions | 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
64 | TPMIM | IM allocation key | 11 | TPLNR | Funct.Loc. f. autom. deriv. of charactstcs for IM allocation | nvarchar | 1 | 0 | | |
65 | TPMUS | PM/SM - User default values | 24 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMaintenance Program Definition |
66 | MPDCD | MPD: OBSOLETE - Counter Data for Maintenance Document Items | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
67 | MPDCYCLE | MPD: Cycle Data for Maintenance Document Items | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMaintenance Task Lists |
68 | MPLA | Maintenance plan | 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
69 | TAPL | Allocation of task lists to functional locations | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMarketing Retail Network |
70 | OIFOIFLO | Object links - PM functional location (IS-Oil MRN) | 12 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMeasurement System |
71 | GHO_IMPTT_EXT | Data Capture Header | 6 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
72 | GHO_IMRG_EXT | Extension Table for IMRG (Measurement Document) | 5 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPMigration |
73 | VIGW_IM_LO | Abbildung Immoobjekt zu Technischem Platz | 3 | TPLNR | Toimintopaikka | nvarchar | 30 | 0 | | |
TOPNetwork Objects |
74 | GHO_IFLOT_EXT | Function location extension table | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
75 | GHO_IFLOT_PLAN | Function location extension table | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
76 | GHO_ILOA_EXT | OBSOLETE: DO NOT USE | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
77 | GHO_NETOBJ_TD | Well Time Dependency | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
78 | GHO_PROD_NW_FREQ | Frequencies for Production Network | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
79 | GHO_PROD_NW_MED | Mediums for Production network | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
80 | GHO_WELL_TD | Well Time Dependency | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPOperative Structures |
81 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 40 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPOwnership |
82 | GHO_OWN_NET_ASG | Ownership (DOI) assignment to Network Objects | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPPermits |
83 | IHSG | Object-Related Permits in Plant Maintenance | 15 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPPlant Maintenance |
84 | MCB_BUD | MCB Retraction data for Budget check | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
85 | PLMN_FL_EXT | GHO Object characteristics | 2 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPPool Asset Management |
86 | PAMS_TPOOLTP | PAM Pools for Functional Locations | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPProduct Structure Browser |
87 | USROBJECTS | Table of Previous Initial Object in Structure Overview | 12 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPProduction and Revenue Accounting |
88 | OIU_ME_CNTNR | General measurement container | 10 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPProduction Orders |
89 | AFVC | Operation within an order | 181 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPQuality Inspection |
90 | QAPP | Inspection point | 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPReal Estate Management |
91 | VIOB29 | OLD, replaced by VIOB39 for 3.0 | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
92 | VIOB39 | Relationship between Real Estate objects and SAP-PM | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPRemote Logistics Management |
93 | OIO_MX_OBJECT | RLM tracking extract object data | 44 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPReporting |
94 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 19 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
95 | S061 | Location and planning | 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
96 | S061E | S061 - Structural Information | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
97 | S063 | Damage Analysis 30 . | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
98 | S063E | S063 - Structural Information | 3 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
99 | S064 | Single object - damage analysis | 8 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
100 | S070 | Breakdown Statistics | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
101 | S070E | S070 - Structural Information | 4 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
102 | S115 | Cost Evaluation | 10 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
103 | S115E | S115 - Structural Information | 5 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPRouting |
104 | PLPO | Task list - operation/activity | 218 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPService Station Retailing |
105 | OIRBOIFLO | Object links - PM functional location (IS-Oil SSR) | 13 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPSimulation |
106 | VSAFVC_CN | Version: Operation in order | 185 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
107 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 41 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPStatus Board |
108 | /ISDFPS/LINKSMEQ | Object Relationships of Master Equipment (Performance) | 5 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPTakeoverHandover of Technical Objects |
109 | PHINT | Phase In Table | 23 | TPLNR | Functional Location | nvarchar | 40 | 0 | | |
TOPTechnical Objects |
110 | TITOB_IBASE | Creation of IBase: Buffer Table Structures | 6 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPTemplates |
111 | PRPSS | Standard WBS Element (WBS element) - Master Data | 40 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPTraders and Schedulers Workbench |
112 | OIISOCK | SOC: Storage object characteristic segment header | 8 | TPLNR | Functional location ID | nvarchar | 30 | 0 | | |
TOPWaste Management |
113 | EEWA_PROP_H | Header data of property | 9 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
114 | EWAPROPSD | Allocation Table: Property <-> Sales Document Item | 11 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
115 | EWA_EL_WDPLANT | Waste Disposal Facility | 6 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
TOPWork Clearance Management |
116 | WCAAP | WCM: Application | 26 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
117 | WCAHE | WCM: Work Clearance Document (Header) | 26 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
118 | WCAJ | WCM: Lineup | 14 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |
119 | WCAW | WCM: Work Approval | 24 | TPLNR | Functional Location | nvarchar | 30 | 0 | | |