| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000187000 | PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item) | 36 | EMATN | | nvarchar | 18 | 0 | | |
2 | /BIC/B0000189000 | PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line | 34 | EMATN | | nvarchar | 18 | 0 | | |
3 | /SMERP/STG_PM001 | Data staging - Equipment complex table | 73 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
4 | /SMERP/STG_PM002 | Data staging - Functional Location complex table | 58 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
5 | /SMERP/STG_PM003 | Data staging - Equipment List Set - Hdr - complex tab | 73 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
6 | /SMERP/STG_PM008 | Data staging - Functional Loc. List Set - Hdr - complex tab | 58 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
7 | ZEIM_LIPS | SD document: Delivery: Item data | 198 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
8 | EEORD | Purchasing Source List | 16 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPDefense Forces and Public Security |
9 | /ISDFPS/ZEBAN | Copy of EBAN | 19 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPEquipment |
10 | EQUI | Equipment master data | 68 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPFunctional Locations |
11 | IFLOT | Functional Location (Table) | 52 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
12 | IFLOT_VS | Functional Location (Version Table) | 53 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPInventory Management |
13 | MSEG | Document Segment: Material | 170 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
14 | MWXMSEG | ZMSEG: Interface for Posting of Value | 170 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
15 | MWZMSEG | ZMSEG:Interface for Posting of Value | 170 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPMaster Data |
16 | PLAF | Planned Order | 111 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPMaterial Requirements Planning |
17 | MPNSET | MPN-MRP Set: Group of Interchangeable MPNs in MRP | 5 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPMaterials Management |
18 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 24 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPPOS Interface |
19 | WVFB | DRS Interface, Intermediate Buffer, Order Item FM | 21 | EMATN | Material Number | nvarchar | 18 | 0 | | |
TOPPurchasing |
20 | AMPL | Table of Approved Manufacturer Parts | 4 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
21 | AMPL_REJECTION | Rejection of AMPL Row | 4 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
22 | EBAN | Purchase Requisition | 19 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
23 | EKBE | History per Purchasing Document | 41 | EMATN | Material Number | nvarchar | 18 | 0 | | |
24 | EKBEH | Removed PO History Records | 41 | EMATN | Material Number | nvarchar | 18 | 0 | | |
25 | EKES | Vendor Confirmations | 20 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
26 | EKPO | Purchasing Document Item | 9 | EMATN | Material Number | nvarchar | 18 | 0 | | |
27 | EORD | Purchasing Source List | 16 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
28 | EQUP | Quota File: Item | 21 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
29 | MEREQX | Purchase Requisition Change Parameter | 19 | EMATN | Updated information in related user data field | nvarchar | 1 | 0 | | |
30 | PEKES | Variant Vendor Confirmations | 20 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
31 | WDFR_POS | Perishables Planninng Item | 32 | EMATN | Material Number | nvarchar | 18 | 0 | | |
TOPRepetitive Manufacturing |
32 | COMPMOVE | Goods Movement of Components | 110 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPSelf-Service Procurement |
33 | /SRMERP/D_SC_ITM | Shopping Cart Item | 23 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPSerial Numbers |
34 | T377X | Documents Allowed for Serial Number Management | 53 | EMATN | Optionality of Parameter Transfer | nvarchar | 1 | 0 | | |
TOPShipping |
35 | LIPS | SD document: Delivery: Item data | 198 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |
TOPSimulation |
36 | VSEBAN_CN | Version: Purchase requisition | 20 | EMATN | Material Number | nvarchar | 18 | 0 | | |
37 | VSPLAF_CN | Version: Planned order | 112 | EMATN | Material Number Corresponding to Manufacturer Part Number | nvarchar | 18 | 0 | | |