| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_DIMM | Collected Header Document Numbers for TDMS_Time-VBUK | 3 | MATID | ACCID/MATID for DIMP | nvarchar | 10 | 0 | | |
TOPJust-In-Time Processing |
2 | JITCO | Call components | 3 | MATID | Internal JIT Material Number for Call Components | nvarchar | 6 | 0 | | |
3 | JITMA | JIT : Material Data | 2 | MATID | Internal JIT Material Number for Call Components | nvarchar | 6 | 0 | | |
4 | JITTE | JIT : Texts / Additional Data for JIT Call | 4 | MATID | Internal JIT Material Number for Call Components | nvarchar | 6 | 0 | | |
TOPliveCache Applications |
5 | /SAPAPO/RSP_LCCO | Maintenance of Objects in RSP liveCache Check | 4 | MATID | Internal Number (UID) for Product | nvarchar | 22 | 0 | | |
6 | /SAPAPO/STOCKANC | Key and Descriptive Data for Stock | 8 | MATID | Internal Number (UID) for Product | nvarchar | 22 | 0 | | |
7 | MATRIXINDEXTAB | (Only in the liveCache) | 3 | MATID | Internal Number (UID) for Product | nvarchar | 22 | 0 | | |
8 | RPM_PERF_DATA | RPM: Performance Results (only in the liveCache) | 3 | MATID | Internal Number (UID) for Product | nvarchar | 22 | 0 | | |
9 | RPM_PLAN_FILE | Matrix: RPM Markings (Only in liveCache) | 3 | MATID | Internal Number (UID) for Product | nvarchar | 22 | 0 | | |
TOPMaintenance Orders |
10 | /MRSS/D_SQM_MEG | Association of Matrices to Employee Groups | 2 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
11 | /MRSS/D_SQM_MH | Qualification Matrix | 2 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
12 | /MRSS/D_SQM_MHT | Qualification matrix: texts | 2 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
13 | /MRSS/D_SQM_MPL | Association of Matrices to Plants | 2 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
14 | /MRSS/D_SQP_ESTR | Employee Profile - Structured Qualifications | 5 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
15 | /MRSS/D_SQP_RSTR | Requirements Profile : Structured Qualifications | 4 | MATID | Matrix Number | nvarchar | 10 | 0 | | |
TOPProduction Backflush |
16 | PPC_MAT | Super BOM for Backflushed Materials | 2 | MATID | Key - Backflush Material (Number Range) | nvarchar | 10 | 0 | | |
17 | PPC_MAT_DET | Super BOM: Special Account/Batch Information | 3 | MATID | Key - Backflush Material (Number Range) | nvarchar | 10 | 0 | | |
TOPSAP Retail Store |
18 | TWIC0110 | Retail Store GR: Basic Settings for Goods Receipt | 21 | MATID | SAP Retail Store: Material ID Type | nvarchar | 4 | 0 | | |
19 | TWIC0220 | SAP Retail Store GM: Basic Settings | 4 | MATID | SAP Retail Store: Material ID Type | nvarchar | 4 | 0 | | |
20 | TWIC0300 | SAP Retail Store PO: Basic Settings | 4 | MATID | SAP Retail Store: Material ID Type | nvarchar | 4 | 0 | | |
21 | TWIC0400 | SAP Retail Store II: Incoming Invoice Basic Settings | 4 | MATID | SAP Retail Store: Materials Identification Type | nvarchar | 4 | 0 | | |
22 | TWIC0600 | SAP Retail Store: Physical Inventory Basic Data | 22 | MATID | SAP Retail Store: Materials Identification Type | nvarchar | 4 | 0 | | |
23 | TWIC0900 | SAP Retail Store: Promotion Basic Data | 4 | MATID | SAP Retail Store: Materials Identification Type | nvarchar | 4 | 0 | | |
24 | TWIC1100 | SRS Vendor Master: Basic Settings | 4 | MATID | SAP Retail Store: Materials Identification Type | nvarchar | 4 | 0 | | |
TOPSCM Basis |
25 | CIFERRLOG | Error Recording in Enhanced CIF Error Handling | 18 | MATID | General Data Element for GUID Fields | nvarchar | 22 | 0 | | |