| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 201 | LVORM | Flag Material for Deletion at Plant Level | nvarchar | 1 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 202 | LVORM | Flag Material for Deletion at Storage Location Level | nvarchar | 1 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 200 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 200 | LVORM | Deletion flag for all material data of a warehouse number | nvarchar | 1 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 201 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
6 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 17 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
7 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 22 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
8 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 17 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
9 | /SMERP/STG_PM004 | Data staging - Equipment list set - Measuring Points | 23 | LVORM | Deletion Flag for 2-Level Deletion Logic | nvarchar | 1 | 0 | | |
10 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 22 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
11 | /SMERP/STG_PM009 | Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab | 23 | LVORM | Deletion Flag for 2-Level Deletion Logic | nvarchar | 1 | 0 | | |
12 | CNV_20551_MATNR | Material numbers scheduled for deletion | 4 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
13 | SGT_MLGN | Segmentation dependent Material Data for Each Warehouse no | 5 | LVORM | Deletion flag for all material data of a warehouse number | nvarchar | 1 | 0 | | |
14 | SGT_MLGT | Segmentation dependent Material Data for Each Storage Type | 6 | LVORM | Deletion flag for all material data of a storage type | nvarchar | 1 | 0 | | |
15 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 9 | LVORM | Flag Material for Deletion at Client Level | nvarchar | 1 | 0 | | |
TOPAssortment Maintenance |
16 | WSOF | Module Assignment (SAP Retail) to Plants | 8 | LVORM | Deletion indicator IS-R tables | nvarchar | 1 | 0 | | |
17 | WSOH | Assortment Modules SAP Retail | 6 | LVORM | Deletion indicator IS-R tables | nvarchar | 1 | 0 | | |
18 | WSOP | Modules SAP Retail / Item Data | 6 | LVORM | Deletion indicator IS-R tables | nvarchar | 1 | 0 | | |
TOPCATT Computer Aided Test Tool |
19 | CATA | CATT: General Test Procedure Data | 16 | LVORM | CATT - Delete flag | nvarchar | 1 | 0 | | |
TOPConstruction Equipment Management |
20 | J_3GSTLKOPF | Header Data for Equipment BOMs | 13 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
21 | CCRHD | Work Center Header | 17 | LVORM | Deletion flag for work center | nvarchar | 1 | 0 | | |
22 | MMARA | General material data | 9 | LVORM | Flag Material for Deletion at Client Level | nvarchar | 1 | 0 | | |
23 | MMARC | Plant Data for Material | 5 | LVORM | Flag Material for Deletion at Plant Level | nvarchar | 1 | 0 | | |
TOPEngineering Change Management |
24 | AENR | Change Master | 21 | LVORM | Deletion Flag for Change Number (Reorganization) | nvarchar | 1 | 0 | | |
25 | ECM_ORD | Change Order | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
26 | ECM_REQ | Data for Engineering Change Request | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
27 | ECM_TSK | Change Task | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPEquipment |
28 | EQUI | Equipment master data | 11 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
29 | EQUZ | Equipment time segment | 14 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
30 | IEQT_WL_ITEMS | Interim Statuses - Items | 32 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
31 | IEQT_WL_ITM_BAC | Interim Statuses - Items (Backup) | 33 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
TOPExchanges |
32 | OIA02 | Exchange item data - sales side | 6 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
33 | OIA03 | Exchange item data - purchasing side | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
34 | OIA05H | Quantity schedule header table - sales side | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
35 | OIA06H | Quantity schedule header table - purchasing side | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPExternal Services |
36 | ASMD | Service Master: Basic Data | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
37 | ACCRBD | Accruals/Deferrals Master Data - Basic Data | 9 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPFunctional Locations |
38 | IFLOT | Functional Location (Table) | 16 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
39 | IFLOT_VS | Functional Location (Version Table) | 17 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
40 | IRLOT | Reference Functional Location (Table) | 12 | LVORM | SAP Development Reserve: Format CHAR, Length 1 | nvarchar | 1 | 0 | | |
TOPInventory Management |
41 | SLGH | Elements of Stock Population | 11 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPMaintenance Task Lists |
42 | MPLA | Maintenance plan | 16 | LVORM | Indicator: maintenance plan locked against calls | nvarchar | 1 | 0 | | |
TOPMaterial Master |
43 | MARA | General Material Data | 9 | LVORM | Flag Material for Deletion at Client Level | nvarchar | 1 | 0 | | |
44 | MARA_TMP | File for Incorrect Data in Direct Input | 16 | LVORM | Flag Material for Deletion at Client Level | nvarchar | 1 | 0 | | |
45 | MARC | Plant Data for Material | 5 | LVORM | Flag Material for Deletion at Plant Level | nvarchar | 1 | 0 | | |
46 | MARC_TMP | File for Incorrect Data in Direct Input | 8 | LVORM | Flag Material for Deletion at Plant Level | nvarchar | 1 | 0 | | |
47 | MARD | Storage Location Data for Material | 6 | LVORM | Flag Material for Deletion at Storage Location Level | nvarchar | 1 | 0 | | |
48 | MARD_TMP | File for Incorrect Data in Direct Input | 9 | LVORM | Flag Material for Deletion at Storage Location Level | nvarchar | 1 | 0 | | |
49 | MBEW | Material Valuation | 5 | LVORM | Deletion flag for all material data of a valuation type | nvarchar | 1 | 0 | | |
50 | MBEW_TMP | File for Incorrect Data in Direct Input | 8 | LVORM | Deletion flag for all material data of a valuation type | nvarchar | 1 | 0 | | |
51 | MBPR | Stock at Production Storage Bin | 6 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
52 | MCH1 | Batches (if Batch Management Cross-Plant) | 4 | LVORM | Deletion Flag for All Data in a Batch | nvarchar | 1 | 0 | | |
53 | MCHA | Batches | 5 | LVORM | Deletion Flag for All Data on a Batch at a Plant | nvarchar | 1 | 0 | | |
54 | MCHB | Batch Stocks | 6 | LVORM | Deletion Flag for All Data on a Batch Stock | nvarchar | 1 | 0 | | |
55 | MEIK | Make-to-Order Stock for Customer Order | 9 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
56 | MGVTYPE | Table of version categories | 9 | LVORM | Deletion indicator | nvarchar | 1 | 0 | | |
57 | MGVTYPE_WRK | Table of version categories | 9 | LVORM | Deletion indicator | nvarchar | 1 | 0 | | |
58 | MKLK | Consignment Stocks and Returnable Packaging with Customer | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
59 | MKOL | Special Stocks from Vendor | 8 | LVORM | Deletion Flag for All Data on a Consignment Stock | nvarchar | 1 | 0 | | |
60 | MKOP | Consignment Price Segment | 5 | LVORM | Deletion Flag for All Data on a Consignment Material | nvarchar | 1 | 0 | | |
61 | MKUB | Material Provided by Customer | 7 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
62 | MLGN | Material Data for Each Warehouse Number | 4 | LVORM | Deletion flag for all material data of a warehouse number | nvarchar | 1 | 0 | | |
63 | MLGN_TMP | File for Incorrect Data in Direct Input | 7 | LVORM | Deletion flag for all material data of a warehouse number | nvarchar | 1 | 0 | | |
64 | MLGT | Material Data for Each Storage Type | 5 | LVORM | Deletion flag for all material data of a storage type | nvarchar | 1 | 0 | | |
65 | MLGT_TMP | File for Incorrect Data in Direct Input | 8 | LVORM | Deletion flag for all material data of a storage type | nvarchar | 1 | 0 | | |
66 | MLIB | Material Provided to Vendor | 6 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
67 | MVEW | Material Valuation | 5 | LVORM | Deletion flag for all material data of a valuation type | nvarchar | 1 | 0 | | |
68 | MVGN | Material Data for Each Warehouse Number | 4 | LVORM | Deletion flag for all material data of a warehouse number | nvarchar | 1 | 0 | | |
69 | MVGT | Material Data for Each Storage Type | 5 | LVORM | Deletion flag for all material data of a storage type | nvarchar | 1 | 0 | | |
70 | MVKE | Sales Data for Material | 5 | LVORM | Ind.: Flag material for deletion at distribution chain level | nvarchar | 1 | 0 | | |
71 | MVKE_TMP | File for Incorrect Data in Direct Input | 8 | LVORM | Ind.: Flag material for deletion at distribution chain level | nvarchar | 1 | 0 | | |
72 | MVRA | Cross-version fields for MARA | 9 | LVORM | Flag Material for Deletion at Client Level | nvarchar | 1 | 0 | | |
73 | MVRC | Cross-version fields for MARC | 5 | LVORM | Flag Material for Deletion at Plant Level | nvarchar | 1 | 0 | | |
74 | MVRD | Storage Location Data for Material | 6 | LVORM | Flag Material for Deletion at Storage Location Level | nvarchar | 1 | 0 | | |
75 | MVVE | Sales Data for Material | 5 | LVORM | Ind.: Flag material for deletion at distribution chain level | nvarchar | 1 | 0 | | |
76 | WRF_DISCONT_HDR | Worklist for Discontinuation for Seasonal Procurement | 12 | LVORM | Set Deletion Flags | nvarchar | 1 | 0 | | |
TOPMeasuring Points and Counters |
77 | IMPTT | Measuring Point (Table) | 17 | LVORM | Deletion Flag for 2-Level Deletion Logic | nvarchar | 1 | 0 | | |
78 | IMRG | Measurement Document | 17 | LVORM | Deletion Flag for 1-Level Deletion Logic | nvarchar | 1 | 0 | | |
TOPNetwork Modeler |
79 | GHO_SIM_INET | Object Links for Network Simulation | 27 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPObject Networking |
80 | INET | Object networking | 26 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
81 | T372I | Network identification | 5 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPPermits |
82 | IHSG | Object-Related Permits in Plant Maintenance | 24 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPProduction Allocation |
83 | GHO_INET_LOG | Change log table for INET - productive networks | 28 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
84 | GHO_SIMU_INETLOG | Log table for simulation changes in production network | 28 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPTechnical Objects |
85 | EAML_D_EVT | EAML: Events DB Table | 3 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPWarranties |
86 | BGMK | Master Warranty Header | 15 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
87 | BGMKOBJ | Master Warranty - Object Assignment | 9 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
88 | BGMP | Master Warranty Item | 19 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPWaste Management |
89 | EWATDEVLOC | Provisional Container/Container Location Allocation | 14 | LVORM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPWork Center |
90 | CRHD | Work Center Header | 17 | LVORM | Deletion flag for work center | nvarchar | 1 | 0 | | |