| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 212 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPBatches |
2 | MCH_PUR_TEMP | Assignment of Temporary Batch and Vendor Batch | 4 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPConfirmations |
3 | AFFW | Goods Movements with Errors from Confirmations | 77 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
4 | AFRU | Order Confirmations | 137 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPInventory Management |
5 | CHVW | Table CHVW for Batch Where-Used List | 31 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
6 | MWXVM07M | Fields: Update Control of Module Pool SAPMM07M | 97 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
7 | MWZVM07M | Fields: Update Control of Module Pool SAPMM07M | 97 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPMaterial Master |
8 | MCH1 | Batches (if Batch Management Cross-Plant) | 15 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
9 | MCHA | Batches | 16 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPMaterials Management |
10 | /ISDFPS/CHVW_E | External Batch Where-Used List | 31 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPProduction Orders |
11 | COWIPB_CHVW | WIP Batches with Where-Used List | 24 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPPurchasing |
12 | EKET | Scheduling Agreement Schedule Lines | 26 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
13 | EKETH | Scheduling Agreement Schedules: History Tables | 26 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |
TOPRepetitive Manufacturing |
14 | COMPMOVE | Goods Movement of Components | 94 | LICHA | Vendor Batch Number | nvarchar | 15 | 0 | | |