| 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 | 105 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
2 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 105 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
3 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 106 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
4 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 105 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
5 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 105 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
6 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 108 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
7 | MMARA | General material data | 108 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPDefense Forces and Public Security |
8 | /ISDFPS/ZEBAN | Copy of EBAN | 107 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPInventory Management |
9 | MWZDM07M2 | ZDM07M2 | 189 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPMaterial |
10 | RSADD | Additional fields for reservation | 34 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPMaterial Master |
11 | MARA | General Material Data | 108 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
12 | MARA_TMP | File for Incorrect Data in Direct Input | 115 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
13 | MVRA | Cross-version fields for MARA | 108 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPMaterials Management |
14 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 113 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPMerchandise and Assortment Planning |
15 | TWISPC_MARA | Retail Planning: Materials for Provisional Planning | 21 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPPurchasing |
16 | AMPL | Table of Approved Manufacturer Parts | 5 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
17 | AMPL_REJECTION | Rejection of AMPL Row | 5 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
18 | EBAN | Purchase Requisition | 107 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
19 | EINA | Purchasing Info Record: General Data | 38 | MFRNR | Manufacturer | nvarchar | 10 | 0 | | |
20 | EKPO | Purchasing Document Item | 192 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
21 | MEREQX | Purchase Requisition Change Parameter | 107 | MFRNR | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPSelf-Service Procurement |
22 | /SRMERP/D_SC_ITM | Shopping Cart Item | 27 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
TOPSimulation |
23 | VSEBAN_CN | Version: Purchase requisition | 108 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |
24 | VSRSADD_CN | Version: Additional fields for reservation | 35 | MFRNR | Number of a Manufacturer | nvarchar | 10 | 0 | | |