| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CFMFND/EAM_TPLF | Customizing Tabelle für Filter auf Technische Plätze | 5 | EQART | Art des technischen Objekts | nvarchar | 10 | 0 | | |
2 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 16 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
3 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 45 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
4 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 16 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
5 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 45 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPAerospace Defence Industry Solution |
6 | DIMSP_NOTIF_TYPE | MSP Notification Types | 3 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
7 | DIMSP_REVI_TYPE | MSP Revision Types | 3 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPBasic Functions |
8 | ANKAZ | Asset class: extension for technical fields | 13 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPConstruction Equipment Management |
9 | /SAPCEM/VSMP | Assignment of Measuring Point in Ship. Doc. Entry | 3 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
10 | /SAPCEM/WF_EQUI | Workflow: Asset from Equi. Master Record, Default Values | 2 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
11 | J_3GEQBSTP | Inventory Management Check per Equipment Type | 2 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
12 | J_3GEQUIVO | Default Values for CEM Equipment Data | 2 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
13 | J_3GVBRP | CEM Additional Data for VBRP | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
14 | J_3GVBRP_Z | Frozen Data from VBRP Conversion | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
15 | J_3GZVBAP | Backup Table for CEM Data in Rel. 3.0 | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPDistributor-Reseller-Management |
16 | S490 | CEM Settlement | 10 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
17 | S490E | S490 - Structure Information | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
18 | S491 | CEM Construction Site Stock Value | 10 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
19 | S491E | S491 - Structure Information | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
20 | S492 | CEM Total Costs for Equipment | 9 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
21 | S492E | S492 - Structure Information | 4 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPEquipment |
22 | EQUI | Equipment master data | 10 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPFunctional Locations |
23 | IFLOT | Functional Location (Table) | 39 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
24 | IFLOT_VS | Functional Location (Version Table) | 40 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPIndustry Solution Engineering Construction |
25 | A267 | Customer or Goods Recipient/Equipment Type/Material | 5 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
26 | A269 | Equipment Type/Document Type | 4 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
27 | A495 | Equipment type/standard dummy customer/document category | 4 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
28 | KOT4004 | Debited Co. Code/Debited Business Area/Recipient/Equi. Type | 7 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
29 | KOTJ004 | Debited Co. Code/Debited Business Area/Recipient/Equi. Type | 7 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPPlant Maintenance |
30 | T370K | Type of technical object | 2 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
31 | T370K_T | Language-Dependent Texts for Object Type | 3 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPProcessing |
32 | EWMINSPDETAIL | Inspection List Detail | 16 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
33 | EWMPERIODEQ | Periods for equipment inspections | 2 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
TOPReporting |
34 | MCIPMIS | PMIS: Master data characteristics for PMIS before image | 8 | EQART | Type of Technical Object | nvarchar | 10 | 0 | | |
35 | S114 | Fahrzeugverbrauchsanalyse | 11 | EQART | Soort technisch object | nvarchar | 10 | 0 | | |
36 | S114E | S114 - Strukturinformationen | 6 | EQART | Soort technisch object | nvarchar | 10 | 0 | | |